Teradata Developer

Job Summary

We are seeking an experienced Teradata Developer to join our data engineering team. The ideal candidate will be responsible for designing, developing, and optimizing Teradata-based solutions to support business intelligence and data analytics requirements.

Responsibilities

• Design and develop Teradata database objects including tables, views, macros, procedures, and indexes.
• Write efficient SQL queries for data extraction, transformation, and loading (ETL).
• Work with large-scale data systems and data warehouses, ensuring performance and scalability.
• Collaborate with data architects, analysts, and business teams to understand data requirements and translate them into Teradata solutions.
• Troubleshoot and resolve issues related to data loads, performance, and integrity.
• Develop and maintain data pipelines and ETL processes.
• Optimize query performance using tools like Teradata Explain, Visual Explain, and Statistics.

Qualifications

• 5+ years of experience in Teradata development.
• Strong SQL scripting and performance tuning skills.
• Proficient in Teradata utilities like FastLoad, MultiLoad, TPT, BTEQ, TPump.
• Solid understanding of data warehouse concepts and data modeling.
• Experience with ETL tools (e.g., Informatica, DataStage, Talend – optional but preferred).
• Familiarity with Unix/Linux scripting and job scheduling tools (like Control-M, Autosys).
• Good understanding of business intelligence reporting and analytics requirements.

Preferred Skills

• Experience with ETL tools such as Informatica, DataStage, or Talend.
• Knowledge of Unix/Linux scripting for job automation.

Experience

• Minimum of 5 years of relevant experience in Teradata development.