Teradata Developer Full Time

Job Summary

We are seeking an experienced Teradata Developer with strong expertise in Informatica ETL and Data Quality (DQ) activities. The candidate will be responsible for developing, optimizing, and supporting enterprise data warehouse solutions using Teradata and Informatica tools while ensuring high standards of data quality, integrity, and governance.

Key Responsibilities

Teradata Development

• Design, develop, and maintain Teradata database objects including tables, views, macros, stored procedures, and scripts.
• Write complex SQL queries for data extraction, transformation, and loading.
• Perform query tuning and performance optimization in Teradata.
• Develop and support ETL workflows for data warehouse and reporting systems.
• Analyze source systems and map business requirements to technical solutions.
• Support batch processing and scheduling activities.

Informatica ETL Activities

• Develop and maintain Informatica PowerCenter mappings, workflows, sessions, and reusable transformations.
• Implement ETL processes for large-scale data integration projects.
• Handle incremental loads, CDC (Change Data Capture), and error handling mechanisms.
• Perform unit testing, integration testing, and deployment support.
• Troubleshoot ETL failures and production issues.

Data Quality (DQ) Activities

• Implement data quality checks and validation rules across source and target systems.
• Analyze data anomalies, duplicates, missing values, and integrity issues.
• Create DQ scorecards, reconciliation reports, and audit reports.
• Work with business users to define data quality standards and KPIs.
• Perform root cause analysis for data issues and coordinate remediation activities.
• Ensure compliance with data governance and data validation processes.

Required Skills

• Strong experience in Teradata SQL and performance tuning.
• Hands-on experience with Informatica PowerCenter.
• Experience in Data Quality (DQ) frameworks and validation processes.
• Knowledge of ETL design and data warehousing concepts.
• Experience with Unix shell scripting.
• Understanding of SDLC and Agile methodologies.
• Strong analytical and troubleshooting skills