ETL Developer

Key Responsibilities

• Design, develop, test, and deploy ETL workflows using Ab Initio, Informatica PowerCenter, or IBM DataStage.

• Develop and optimize complex SQL queries, stored procedures, and database objects.

• Build and maintain data integration processes for large-scale enterprise data warehouses.

• Work extensively with Teradata databases for data extraction, transformation, and loading activities.

• Develop and maintain PySpark applications for big data processing and data transformation.

• Analyze source-to-target mappings and implement data transformation logic.

• Perform data validation, reconciliation, and quality checks to ensure data accuracy and consistency.

• Troubleshoot ETL job failures, performance bottlenecks, and data issues.

• Collaborate with business analysts, data architects, and stakeholders to gather and understand requirements.

• Follow best practices for ETL development, coding standards, and documentation.

• Participate in code reviews, testing, deployment, and production support activities.

• Monitor ETL processes and ensure timely execution of data loads

Technical Skills

• Strong experience with at least one ETL tool:

  • Ab Initio (Preferred)

  • Informatica PowerCenter

  • IBM DataStage

• Advanced SQL development and query optimization skills.

• Hands-on experience with Teradata databases.

• Strong knowledge of PySpark and distributed data processing concepts.

• Experience with data warehousing concepts, dimensional modeling, and ETL methodologies.

• Knowledge of Unix/Linux shell scripting.

• Experience with data validation, data quality, and reconciliation processes.

• Understanding of performance tuning and optimization techniques.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

• 5+ years of experience in ETL/Data Engineering development.

• Strong analytical, problem-solving, and troubleshooting skills.

• Excellent communication and collaboration abilities.