Teradata DW ETL/SQL Performance Engineer

Tata Consultancy Services; Charlotte (NC); On-site; USD 95,000 - 135,000; Full time

Job summary

Tata Consultancy Services in Charlotte, NC is seeking an experienced Teradata SQL developer to design, build and optimize data warehousing solutions. You will develop ETL/ELT processes, implement S2T mappings, and drive performance tuning across large datasets.

You'll collaborate with business and data teams in an Agile/Scrum environment, use Unix scripting for job orchestration, and apply data validation to ensure quality in Retail, Loans, Payments and Risk domains.

Qualifications

• Strong hands-on Teradata SQL development and performance tuning.
• Design, develop, and maintain complex Teradata scripts, stored procedures, macros, and views.
• Expertise in data warehousing concepts – Staging, ODS, EDW, Data Marts.
• Analyze and implement Source-to-Target (S2T) mappings.
• Develop and optimize ETL/ELT processes using Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT).
• Strong experience in query optimization, indexing strategies, partitioning (PPI), and workload management.
• Work with large-scale datasets and ensure high-performance data processing.
• Implement data validation and data quality checks within Teradata environments.
• Experience handling incremental loads, CDC, and batch processing pipelines.
• Collaborate with business and data teams to translate requirements into technical solutions.
• Strong understanding of banking domain data (Retail, Loans, Payments, Risk, Finance).
• Support production deployments, performance monitoring, and issue resolution.
• Experience working in Agile/Scrum environments with tools like JIRA.
• Good knowledge of Unix scripting for job orchestration and automation.

Responsibilities

• Design, develop, and maintain complex Teradata scripts, stored procedures, macros, and views.
• Analyze and implement Source-to-Target (S2T) mappings.
• Develop and optimize ETL/ELT processes using Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT).
• Collaborate with business and data teams to translate requirements into technical solutions.
• Support production deployments, performance monitoring, and issue resolution.

Skills

Teradata SQL

Performance tuning

ETL/ELT development

Data warehousing concepts

Source-to-Target mappings

Teradata utilities

Query optimization

Big data processing

Data validation

CDC/batch processing

Agile/Scrum (JIRA)

Unix scripting

Tools

BTEQ

FastLoad

MultiLoad

TPT

Job description

Tata Consultancy Services in Charlotte, NC is seeking an experienced Teradata SQL developer to design, build and optimize data warehousing solutions. You will develop ETL/ELT processes, implement S2T mappings, and drive performance tuning across large datasets.

You'll collaborate with business and data teams in an Agile/Scrum environment, use Unix scripting for job orchestration, and apply data validation to ensure quality in Retail, Loans, Payments and Risk domains.