Teradata Developer

Role & 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.
• 3-6 years of 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.
• Experience with BI/reporting tools such as Tableau, Power BI, or MicroStrategy.
• Exposure to cloud platforms (AWS, Azure, or GCP) and Teradata on cloud.
• Knowledge of Python or shell scripting for automation.

Familiarity with data governance and data privacy principles (GDPR, HIPAA, etc.).