Teradata Subject Matter Expert

Teradata SME (Subject Matter Expert)

Role Overview

• We are seeking a highly experienced Teradata Subject Matter Expert (SME) with strong expertise in Teradata development, performance optimization, and metadata management.
• The role involves designing, maintaining, and modernizing enterprise data warehouse solutions while supporting migration initiatives from Teradata to modern data platforms.

Key Responsibilities - Teradata Development & Engineering

• Design, develop, and maintain high-performance Teradata data warehouse solutions.
• Write and optimize complex SQL queries, stored procedures, macros, and views.
• Implement data modeling techniques including star and snowflake schemas.
• Develop and manage ETL/ELT pipelines using Teradata utilities and integrated tools.
• Ensure data quality, integrity, and consistency across enterprise systems.

Performance Optimization & Database Management

• Perform query tuning and optimization using explain plans.
• Implement indexing strategies including PI, SI, Join Index, and PPI.
• Manage workload using TASM/TDWM.
• Monitor and troubleshoot production issues.

Teradata Metadata & System Tables

• Deep understanding of DBC.Tables, DBC.Columns, DBC.Indices, TablesV, ColumnsV.
• Use metadata for lineage, diagnostics, and schema discovery.
• Develop automation scripts using metadata.

Data Migration & Modernization

• Lead migration from Teradata to cloud platforms.
• Define migration strategies and re-engineer ETL pipelines.
• Perform validation, reconciliation, and benchmarking.

Required Qualifications

• 8–12+ years of Teradata development experience.
• Strong SQL, data modeling, and performance tuning skills.
• Experience with ETL tools such as Informatica or DataStage.
• Knowledge of Unix/Linux scripting.

Preferred Qualifications

• Experience in Teradata migration projects.
• Knowledge of GCP is a plus.
• Experience with Apache Spark is a plus.
• Experience with DataStage or similar ETL tools.