Teradata Developer

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

• Strong hands‑on experience in 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.