Teradata Developer

Tata Consultancy Services Limited

Charlotte, NC, United States

about 1 month ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$100,000.0 - $110,000.0

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Batch Processing Big Data Unix Data Validation Extract Transform Load (ETL) Data Mart Data Warehousing Operational Data Store Performance Tuning Query Optimization Software Deployment SQL Stored Procedures

+5 more

Teradata SQL Data Processing Macros Database Optimization Performance Monitor

Requirements

Must Have Technical/Functional Skills

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.