Talend Developer (ETL Developer)

EY; New Delhi; On-site; INR 800,000 - 1,200,000; Full time

Job summary

EY in Delhi seeks an experienced ETL Developer to design, build, and optimize Talend-based data integration pipelines. The role focuses on data extraction, transformation, and loading from multiple sources to support reporting and analytics. Strong SQL skills and warehousing knowledge are essential.

The candidate will work with cross-functional teams, ensure data quality, and contribute to governance, documentation, and code reviews. Relevant Unix/Linux and Git experience are a plus.

Qualifications

• Strong experience in Talend ETL Development.
• Proficiency in Talend Data Integration (DI) and Talend components.
• Strong SQL skills with experience in relational databases such as Oracle, SQL Server, PostgreSQL, MySQL.
• Experience with Data Warehousing concepts including Star Schema and Snowflake Schema.
• Understanding of ETL/ELT methodologies and data migration projects.
• Knowledge of UNIX/Linux commands and scripting.
• Experience with version control tools such as Git.
• Strong debugging and performance tuning skills.

Responsibilities

• Design, develop, test, and deploy ETL workflows using Talend Open Studio/Talend Data Integration.
• Develop and maintain data extraction, transformation, and loading processes from various source systems.
• Build scalable data pipelines for data warehousing, reporting, and analytics requirements.
• Perform data mapping, cleansing, validation, and transformation activities.
• Optimize ETL jobs for performance, reliability, and scalability.
• Work with business analysts, data architects, and stakeholders to understand data integration requirements.
• Troubleshoot ETL issues and provide production support.
• Implement error handling, logging, auditing, and monitoring frameworks.
• Develop and maintain technical documentation, source-to-target mappings, and design specifications.
• Ensure data quality, consistency, and adherence to governance standards.
• Participate in code reviews and follow ETL development best practices.

Skills

Talend ETL Development

SQL

Data Warehousing concepts

ETL/ELT methodologies

UNIX/Linux commands

Git

Debugging & tuning

Tools

Talend Open Studio

Talend Data Integration

Job description

Role & responsibilities

• Design, develop, test, and deploy ETL workflows using Talend Open Studio/Talend Data Integration.
• Develop and maintain data extraction, transformation, and loading processes from various source systems.
• Build scalable data pipelines for data warehousing, reporting, and analytics requirements.
• Perform data mapping, cleansing, validation, and transformation activities.
• Optimize ETL jobs for performance, reliability, and scalability.
• Work with business analysts, data architects, and stakeholders to understand data integration requirements.
• Troubleshoot ETL issues and provide production support.
• Implement error handling, logging, auditing, and monitoring frameworks.
• Develop and maintain technical documentation, source-to-target mappings, and design specifications.
• Ensure data quality, consistency, and adherence to governance standards.
• Participate in code reviews and follow ETL development best practices.

Preferred candidate profile

• Strong experience in Talend ETL Development.
• Proficiency in Talend Data Integration (DI) and Talend components.
• Strong SQL skills with experience in relational databases such as:
• Oracle
• SQL Server
• PostgreSQL
• MySQL
• Experience with Data Warehousing concepts including Star Schema and Snowflake Schema.
• Understanding of ETL/ELT methodologies and data migration projects.
• Knowledge of UNIX/Linux commands and scripting.
• Experience with version control tools such as Git.
• Strong debugging and performance tuning skills.