Architecting for Change: How We Helped a Leading U.S. Insurer Cut Technical Debt by 97% and Modernize at Scale
Case Study
Restaurants
Data Warehouse Migration from Teradata to AWS Redshift
An American company that franchises and operates a chain of restaurants needed to migrate its on-premise Data Warehouse (Teradata Database) to AWS Cloud Infrastructure (Redshift Database)
Client Challenges and Requirements
- Large volume of data. Approx. size of data to be migrated was 8TB
- Data field mapping issues
- Time duration for the entire Migration
- Large size of a few fact tables
- Data Validation
Tools & Technologies We Used
Amazon SCT
Teradata
Aginity for Redshift
Amazon S3
Key Results
Reduced maintenance and operating costs for the Data Warehouse
Faster execution of queries in comparison with the previous setup
The deployment time was reduced from 24 hours to less than an hour
An American company that franchises and operates a chain of restaurants needed to migrate their on-premise Data Warehouse (Teradata Database) to AWS Cloud Infrastructure (Redshift Database)
Related Insights
