Enterprise Data Warehouse & ETL Implementation
Client
Private Reference
Sector
Insurance
Project duration
2023–2024
CFT partnered with the client to implement an enterprise Data Warehouse and ETL ecosystem based on a packaged insurance data model owned by our technology partner.
The initial implementation was completed in 2023, covering source-to-target mapping and implementation of the out-of-the-box DWH model and ETL processes. During the second phase through 2024, our team delivered model and ETL enhancements and customisations, together with integration testing and UAT support.
The solution connects on-premises source systems to a Microsoft Azure target environment owned and managed by the client.
Key Scope
- Source-to-target mapping
- Out-of-the-box DWH model implementation
- ETL design and implementation
- Model and ETL enhancements and customizations
- Integration testing and UAT support
- Dedicated team of approximately 4 FTE
Technology Environment
On-premises source systems · Microsoft Azure target environment
Technologies Used