Data Modernization for a Large UK Specialty Insurer: Leveraging AWS and Snowflake

Challenges.

The client faced significant challenges in their data management processes: 

• Legacy DWH Modernization: Needed to upgrade their legacy data warehouse system to a modern platform. 
• Unified Data Engine: Required a unified data engine for digital data sources (Pega, Sitecore, Salesforce). 

Solution.

Coforge implemented a comprehensive data modernization solution: 

• AWS-Based Architecture: Designed a scalable and future-ready AWS cloud-based enterprise data lake and warehouse. 
• Snowflake as EDW: Utilized Snowflake as the enterprise data warehouse (EDW). 
• Data Replication: Employed Attunity for data replication from system databases and accumulated data from messages. 
• Orchestration with Airflow: Used Airflow for orchestration of data processes. 
• Centralized Data Management: Established centralized and controlled management of reference data. 
• DevSecOps Configuration: Implemented DevSecOps for faster and more secure release cycles. 

Key Highlights: 

Coforge's innovative solution delivered significant value to the client's operations:

• UI-Based Business Rule Engine: Enabled real-time business rule changes by the business users. 
• Meta Model Service: Facilitated the reuse of ETL mappings and automatic incorporation of changes. 
• Reconciliation Service: Established business transparency and control over data quality. 
• Solid Data Governance and Security: Ensured robust data governance and security measures. 

The Impact.

• Business Rule Changes
• Real-time, UI-based
• Data Quality Control
• Enhanced transparency and control
• Data Governance and Security
• Robust and solid