Large-Scale Data Warehouse & ETL Transformation
Client
Private Reference
Sector
Insurance
Project duration
Multi-year transformation program
CFT supports client in a large-scale enterprise data transformation program delivered in collaboration with our technology partner, with up to 60 specialists across the broader project team.
The engagement includes implementation of an Operational Data Store, enterprise Data Warehouse, and ETL ecosystem integrating data from more than 15 source systems across both on-premises and Microsoft Azure environments into an Azure-based target architecture.
CFT and Link contribute a combined team of approximately 35 professionals across multiple parallel workstreams, requiring careful management of complex and sometimes interdependent source-system deliveries. The broader program is expected to span up to three years, with additional phases covering continued DWH evolution, reporting, and data migration.
Key Scope
- ODS and enterprise Data Warehouse implementation
- ETL development across 15+ source systems
- Hybrid integration across on-premises and Azure environments
- Management of parallel source-system dependencies
- Approximately 35 CFT resources at peak delivery
- Future DWH enhancements
- Migration and development of 1,000+ reports
- Data migration supporting future insurance portfolio takeovers
Technology Environment
Microsoft Azure · Hybrid on-premises/Azure source landscape
Technologies Used