![case study](https://cdn.quantiphi.com/2024/02/4419c78a-an-insurer-migrates-its-data-13.png)
Data Lake and Analytics Cloud Migration
InsuranceBusiness Impacts
Conforming reports into the new data lake
Setup ETL pipelines without impacting ongoing business
Reduced the execution time for faster results
Reduced cost with at scale capabilities for business growth
Customer Key Facts
- Location : North America
- Industry : Insurance
Challenges
- 60+ DBs aggregated for Single Version of Truth
- ~1000 ETL mappings adopted
- ~5000 DB Objects Migrated
- Around 200 SAP BI Reports pointed to the new Data Lake.
Technologies Used
![Teradata](https://cdn.quantiphi.com/2024/02/teradata.jpg)
Teradata
![Snowflake](https://cdn.quantiphi.com/2024/02/a755db66-5fa0775c8dc32dc5cce9150b_snowflake-icon.png)
Snowflake
![AWS](https://cdn.quantiphi.com/2024/02/aws-2.png)
AWS
![SAP ERP, BusinessObjects BI](https://cdn.quantiphi.com/2024/02/530372fe-sap-icon-e1637835322349.png)
SAP ERP, BusinessObjects BI
Solution
Quantiphi enabled swift Migration of SAP, Teradata DWH, and BI reports to Snowflake without impacting ongoing business functions and reconciliation available at every step.
Results
- Created high-performing yet highly cost-efficient Data Lake on the cloud.
- Shifted from systems like Teradata, stopped recurring license costs, and salvaged the infrastructure.