BACK

Retire Legacy Data Warehouse by Moving to the GCP

Our Client is a manufacturer and retailer of products across multiple categories, sought to modernize their legacy data warehouse.

Challenges

  • Low performance while running data on on-premises DW and ETL

Higher maintenance costs

  • Time to building new use cases to cater to growing business needs was high

Implementation

  • Built a GCP foundation, including Firewall, IAM Rules and Private Service Connect based on GCP best practices
  • Redesigned the data model, architecture and transformed the code by leveraging GCP native technologies
  • Conversed Teradata tables, view DDLs, SPs and Informatica workflows, Informatica codes and scripts
  • Data ingestion pipelines were refactored for GCP

Results

  • Significant improvement in operational performance through automated GCP migration (46 mins to 4 mins on GCP BQ
  • Reduced the migration cost by 40% and associated business risks
  • Time to build new use cases were reduced from days to hours
  • Improved the report execution time by 60%

Tech Stack