← Back to Jobs
HCLTech | london, United-Kingdom | Posted May 25, 2026
Position 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.
- 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 Ind...