Manufacturing, Supply Chain & Logistics
Data Engineering
Cloud Data Migration for Premier Industrial Solutions Company
- Subsidiary of world-class auto and industrial distribution organization
- $7.9B in annual sales
Business Need
- Increased access to financial, inventory, and item data for self-service reporting
- Faster report turnaround time via simplified data handling
- Improved data accuracy
- Modernized and enhanced reporting infrastructure
- Curate and migrate data from on-premise to the cloud
Challenge
- Move 30 raw database objects within Google BigQuery
- +1B records across 11 domains
- High performance expectations
- Manual processes – cleanse, standardize, and denormalize
- Gap in Informatica knowledge to make the data migration to the cloud
- Ensure 100% of data is pushed to Google BigQuery for processing
Solution & Results
- Enabled data transformation, migrating to the cloud (Informatica CDI and Google BigQuery)
- Decrease in data refresh time
- Automated 1B+ row refresh, enabling easy data drill-downs and faster reads for broader and deeper insights
- Reporting efficiency increase – enabled self-service reporting for business end-users
- Reduction in technical debt/costs via scalable/futureproof infrastructure (reusable code and change data capture)
- Provided advisory and best practices for moving data from on-premise to the cloud