Teradata Developer

Dear Candidates,

Greetings from TCS!!!!

TCS is looking for Teradata Developer

Experience: 8-12 years

Location: Kolkata / Hyderabad / Chennai / Bangalore /Pune

Required technical skill: Teradata

Job summary:

We are seeking a skilled and detail-oriented Mid-Level Teradata Developer to join our data engineering team. The ideal candidate will have solid experience in Teradata development, data warehousing concepts, performance tuning, and writing efficient SQL. You will work on designing, developing, and maintaining large-scale data warehouse solutions that support business intelligence and analytics.

Roles and responsibilities:

• Design, develop, and optimize Teradata SQL queries, procedures, views, and macros.
• Develop ETL processes using BTEQ, FastLoad, MultiLoad, and TPT utilities.
• Participate in data modeling and schema design based on business requirements.
• Work closely with business analysts, data architects, and other developers to understand data requirements.
• Optimize performance of Teradata queries and load processes.
• Conduct data profiling, data validation, and data quality checks.
• Participate in code reviews, unit testing, and system integration testing.
• Monitor and troubleshoot production jobs and provide L2/L3 support as needed.
• Document data flows, processes, and code as per company standards.

Primary skill:

• Hands-on experience with Teradata development.
• Proficiency in Teradata SQL and scripting (BTEQ, FastLoad, MultiLoad, TPT).
• Strong knowledge of data warehousing concepts, dimensional modeling, and ETL best practices.
• Experience in performance tuning of SQL queries and database objects.
• Familiarity with job scheduling tools like Control-M, Autosys, or equivalent.
• Experience working in Agile/Scrum methodologies.
• Good understanding of version control tools (Git, Bitbucket, etc.).
• Strong analytical and problem-solving skills.
• Good communication and collaboration skills.