Teradata Developer

Tata Consultancy Services Limited
Charlotte, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 110K

Job location

Charlotte, United States of America

Tech stack

Batch Processing
Big Data
Unix
Data Validation
ETL
Data Mart
Data Warehousing
Operational Data Store
Performance Tuning
Query Optimization
Software Deployment
SQL Stored Procedures
Teradata
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.

Benefits & conditions

(part of Tata group) 3.93.9 out of 5 stars Charlotte, NC $100,000 - $110,000 a year

Apply for this position