Teradata to Snowflake Migration
InsuranceBusiness Impacts
Standardize ETL pipelines using Snowflake and reduce turnaround time
Enhance Security
Standardize reports with Snowflake and reduce cost with at scale capabilities
Customer Key Facts
- Location : United States
- Industry : Supplemental Insurance
Challenges
- Migrate databases within a limited time while considering internal dependencies
- Large scale data ingestion which requires a higher turnaround time
- Standardize ETL Pipelines without impacting business outcomes
- Manage security aspects with respect to PII sensitive data
- Build scalable data validation strategy
Technologies
Informatica
Apache Hive
Python
Tableau
SAP Business Object
Enable Migration of Data Assets from Teradata
Solution
- Migration of data assets from Teradata to the Snowflake Data Cloud was completed over 6-8 months along with the configuration of downstream data availability through the cloud warehouse and on-premise systems.
- Custom Snowflake accelerators were designed to meet the needs during the design, implementation, and validation phases.
- The team was awarded the CDIO award for the successful implementation
Result
- Quantiphi team was able to deliver the migration and minimize dependencies from Teradata as a source before the license expiration date.
- Quantiphi team, along with the customer, enabled successful validation for seamless transition without impacting end-user experiences.
- The migration established Snowflake as the Cloud Data Warehouse across both group and individual users on the cloud-native data platform for the customer.
