Legacy data warehouse offload



Client challenges

Project scope

Our client is a major retail player who wished to offload Teradata jobs to Hadoop for a cost effective and scalable data warehouse architecture.


Offload Teradata

Datametica helped the client to offload their Teradata Data Warehouse to Hadoop. As part of this engagement, we began with an assessment of the current system using Eagle, an accelerator for automated workload analysis. The analysis helped to build consensus among stakeholders and decision makers for the design of a Complete Migration Strategy. A high-level approach in this case involved:

  • Migration of Storage Layer
  • Migration of Processing Layer with Required Optimizations
  • Migration of Analytics/Access Layer
  • Continuous Data Validation through direct comparison of the workload data of both Teradata and Hadoop clusters



Accelerated Delivery

Leveraging experience and best practices

User Migration 

Seamless User Migration through well-defined Collaboration

Minimized person dependency

Leveraged Datametica's tools to minimize person dependency

Data quality checks

Continuous data quality checks to avoid last minute surprises

Automated plan

An automated plan based on the output reports to enable various types of drill down