loading

Business Impact

  • 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

Problem Context

The customer, one of the largest providers of supplemental insurance in the US, leverages Teradata on-premise to primarily host the EODS & ADW components of their enterprise data platform. Teradata acts as the data service layer for downstream sales operations and 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 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
Challenges

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.

Looking for similar project?

Let's Talk

Get your digital transformation started

Let's Talk