Gathr > Case Studies > Fortune 100 telecommunications company seamlessly migrates from Teradata to Amazon Redshift

Fortune 100 telecommunications company seamlessly migrates from Teradata to Amazon Redshift

Customer Company Size

Large Corporate

Region

America

Country

United States

Product

Amazon Redshift
Amazon S3
Amazon Athena
Amazon EMR
Gathr

Tech Stack

Cloud Computing
Data Warehousing
ETL
Data Migration
Data Validation

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Cost Savings
Digital Expertise
Productivity Improvements

Technology Category

Analytics & Modeling - Real Time Analytics
Infrastructure as a Service (IaaS) - Cloud Computing
Infrastructure as a Service (IaaS) - Cloud Storage Services
Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Telecommunications

Applicable Functions

Business Operation

Services

Cloud Planning, Design & Implementation Services
Data Science Services
System Integration

About The Customer

The customer is a US-based Fortune 100 broadband connectivity company and cable operator. They serve more than 30 million customers across the country. In their existing setup, they received data from multiple sources that was fed into an SFTP server. Once ETL was performed, the data was read by an Informatica workload and persisted to their Teradata data warehouse. Business analysts then accessed this data and ran queries to gather insights. However, this workflow was posing several technical and business challenges, prompting the client to seek a strategic shift to the cloud.

The Challenge

The customer, a US-based Fortune 100 broadband connectivity company and cable operator serving more than 30 million customers, was facing several technical and business challenges with their existing data workflow. They received data from multiple sources that was fed into an SFTP server. After ETL was performed, the data was read by an Informatica workload and persisted to their Teradata data warehouse. Business analysts then accessed this data and ran queries to gather insights. The client wanted to make a strategic shift to the cloud to enhance scalability, reduce costs, improve query performance, realize a unified view, simplify management, seamlessly integrate with other cloud-native services, and automate workflows for CI/CD.

The Solution

To meet the customer’s business requirements, an end-to-end data flow solution was built leveraging key components such as Amazon Redshift, Amazon S3, Amazon Athena/EMR/Redshift, and Gathr. Gathr was used to configure ETL flows, ingest data, perform full load, incremental load, and CDC from Teradata to Redshift, transform and persist data feeds to Amazon S3, enable one-time migration by directly loading Teradata tables into Amazon Redshift, validate data post migration, provide a unified view of the complete workflow, set up CI/CD for upgrading ETL flows and moving them seamlessly from one environment to another, and schedule and trigger the data flow process at a pre-configured frequency.

Operational Impact

The solution enabled the client to accelerate and de-risk the entire migration process.
The client was able to seamlessly integrate with Amazon’s cloud-native services.
The client was able to switch to a cost-effective pay-as-you-go business model.
The client was able to handle 30 billion rows and easily scale to manage fluctuating production loads.
The client achieved 20% better query performance for analytical queries.

Quantitative Benefit

Support for 40% more analytics users across the enterprise.
15% increase in the number of queries executed, enabling users to unlock new business opportunities.
Lower licensing and infrastructure cost.