We are seeking an experienced Teradata Developer to design, develop, and maintain end-to-end ETL and analytics solutions on Teradata-based data warehouse platforms. The ideal candidate will have strong technical expertise, excellent problem-solving skills, and the ability to work collaboratively with global teams and business partners.
Roles and Responsibilities
- Design, build, and optimize end-to-end ETL/ELT data pipelines using Teradata SQL, BTEQ, TPT, and FastExport.
- Translate business requirements into robust technical specifications, data mappings, and transformation logic.
- Implement incremental data loads, Slowly Changing Dimension (SCD) strategies, and reconciliation checks to ensure data accuracy and completeness.
- Develop reusable modules, parameterized scripts, and enforce standards for code consistency.
- Model and maintain data structures (staging, ODS, dimensional models) aligned with Teradata best practices.
- Collaborate with business analysts, data architects, and other stakeholders to deliver high-quality solutions.
- Participate in CI/CD pipelines for development and deployment using JIRA and BitBucket.
- Work with Big Data technologies and frameworks like Hadoop, Hive, Sqoop, Impala, Kafka, and Python/Spark/PySpark workloads as required.
- Troubleshoot and optimize performance of Teradata SQL scripts and ETL processes.
- Maintain documentation, diagrams, and ensure adherence to development standards.
Required Skills & Experience
- 7+ years of experience in ETL and analytics development on Teradata platforms.
- Extensive experience with Teradata SQL and native utilities (BTEQ, TPT, FastExport).
- Strong knowledge of Unix/Linux shell scripting and job scheduling tools (e.g., Autosys).
- Experience with CI/CD development and deployment processes using JIRA and BitBucket.
- Exposure to Big Data ecosystems and technologies (Hadoop, Hive, Sqoop, Impala, Kafka, Python/Spark/PySpark) is a plus.
- Strong analytical and problem-solving skills with a detail-oriented mindset.
- Excellent written and verbal communication, presentation, and diagramming skills.
- Ability to work collaboratively with global teams and adapt to changing business needs.
Education