Teradata

Tata Consultancy Services; Chennai District; On-site; INR 1,200,000 - 1,500,000; Full time

Job summary

A leading IT services firm is seeking a Teradata Engineer in Chennai, India. The position requires at least 8 years of hands-on experience with Teradata development and utilities, including strong skills in Teradata SQL, performance tuning, and data warehousing. Responsibilities include designing and optimizing solutions, developing complex SQL queries, and collaborating with stakeholders. This is a full-time role at a mid-senior level with opportunities for mentoring junior developers.

Qualifications

• 8+ years of hands-on experience with Teradata development and utilities.
• Strong proficiency in Teradata SQL and utilities (BTEQ, FastLoad, MultiLoad, FastExport, TPT, TPump).
• Experience in performance tuning and query optimization in Teradata.

Responsibilities

• Design, develop, and optimize Teradata solutions for data warehousing.
• Utilize Teradata utilities for data extraction, transformation, and loading.
• Develop complex SQL queries, views, and procedures as required.

Skills

Teradata SQL

ETL processes

Performance tuning

Data warehousing concepts

Data modeling

Shell scripting

Analytical skills

Communication skills

Tools

Informatica

AWS

Azure

Google Cloud

Job description

Greetings from TATA CONSULTANCY SERVICES!

TCS is hiring for Teradata Engineer

Years of Experience: 8 - 10 years

Job Description:

Responsibilities

• Design, develop, and optimize Teradata solutions to support data warehousing and analytical needs.
• Utilize Teradata utilities such as BTEQ, FastLoad, MultiLoad, FastExport and TPT (Teradata Parallel Transporter) for data extraction, transformation, and loading (ETL).
• Collaborate with data architects, business analysts, and other stakeholders to gather and analyze requirements.
• Develop complex SQL queries, views, and stored procedures to meet business requirements.
• Perform data validation, quality checks, and ensure data accuracy across Teradata environments.
• Optimize Teradata queries for performance and scalability.
• Monitor and troubleshoot data loads and resolve issues related to ETL processes.
• Ensure adherence to best practices and standards for data integration and management.
• Provide technical guidance and mentoring to junior developers as needed.

Required Skills & Experience

• 8+ years of hands‑on experience with Teradata development and utilities.
• Strong proficiency in Teradata SQL and utilities (BTEQ, FastLoad, MultiLoad, FastExport, TPT, TPump).
• Experience in performance tuning and query optimization in Teradata.
• Solid understanding of data warehousing concepts and ETL processes.
• Experience with data modeling and database design principles.
• Familiarity with shell scripting and automation tools for managing data pipelines.
• Strong analytical and problem‑solving skills.
• Experience working with large datasets in a complex data environment.
• Proactive, good communication skills and should be able to handle demanding customers and stakeholders.

Preferred Skills

• Experience with data integration tools like Informatica or IICS.
• Knowledge of cloud platforms (AWS, Azure, or Google Cloud) and their data services.
• Exposure to Agile/Scrum development methodologies.
• Experience in implementing data security and governance best practices.

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

Information Technology

Industries

IT Services and IT Consulting

Referrals increase your chances of interviewing at Tata Consultancy Services by 2x