loading

Business Impact

  • Standardize ETL pipelines using snowflake without impacting business outcomes

  • Reduce the execution time for faster results

  • Reduce cost with at scale capabilities for business growth

  • Standardize reports using snowflake without impacting business

Customer Key Facts

  • Location : United States
  • Industry : Supplemental Insurance

Problem Context

The client, one of the largest provider of supplemental insurance in the US leverages Teradata on-premise to host majorly its EODS & ADW components of their enterprise data platform. Teradata acts as the data service layer for downstream sales operations & analytical reporting applications. It intends to leverage the cloud infrastructure setup and Snowflake as its’ target Cloud Warehouse Layer.

Challenges

 

  • Migrate databases within a limited time while considering internal dependencies
  • Large scale data ingestion required a higher turnaround time
  • Standardize ETL Pipelines without impacting business outcomes
  • Manage security aspects with respect to PII sensitive data
  • Building scalable data validation strategy
Challenges

Technologies

Informatica
Apache Hive
Python
Tableau
SAP Business Object

Enable Migration of Data Assets from Teradata

Solution

  • Complete migration of data assets from Teradata to the Snowflake Data Cloud was done over 6-8 months along with the configuration of downstream data availability through the cloud warehouse & 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.
  • Additionally, the Quantiphi team along with the client enabled successful validation to enable seamless transition without impacting end-user experiences.
  • Finally – This migration has given a big lift in establishing snowflake as the Cloud Data Warehouse across both group and individual users on the cloud-native data platform for the client

Looking for similar project?

Let's Talk

Get your digital transformation started

Let's Talk