What were the Drivers?

• Teradata License.
• Informatica PowerCenter End of Date.
• Slow Data Processing
• Flexibility over integration of new Technology.
• Reduce overall Infrastructure cost.

Engagements

One of the top US Stockbroker looking to migrate the current Analytics platform to Google Cloud and Informatica Cloud from their On-Prem Solution using Teradata, Informatica PowerCenter. The Migration Helps Client saving millions in terms of license and platform cost.

Approach

• Access The Informatica PowerCenter code using Informatica Corporation, Migrate the code to Informatica Cloud.
• Access the objects using Datametica to convert code from Teradata to Big Query, Migrate the Code and Data to Big Query.
• Divide the migration into Phases based on objects dependency(Lineage).
• Test each pipeline output against On Prem results continuously for 3 success executions.
• Test against live production data in UAT, Upon Results look good migrate to production.

Benefits

• Flexible Environment.
• Increased Data Availability.
• Easy to Integrate with External Data
• Cost Effective.
• AI/ML Integration.
• Turn Around time for reporting needs.
• Dependency on Informatica PowerCenter is brought down because of end of life.
• Teradata License cost.

Tools

• Google Cloud – Big Query, Cloud Storage, Composer, Compute Engine, Data Catalog, DataProc, Data Transfer Service.
• Informatica – Cloud Data Integration, Migration Utility, Informatica Support.
• Datametica – Teradata to Big Query Migration Service.