Description

Develop and maintain ETL pipelines using Talend Open Studio to load data into MySQL.

This role is hybrid.

Responsibilities

• Design and build ETL jobs in Talend Open Studio for data extraction and transformation.
• Write and optimize SQL queries for data validation, reconciliation, and performance tuning in MySQL.
• Implement data quality checks and handle error scenarios to ensure consistent job outcomes.
• Monitor job runs, troubleshoot failures, and support reruns and recovery procedures.
• Use Linux environments for log review, script execution, and operational support.

Required Skills

• 6-8 years of experience in data integration or ETL development.
• Proficiency in MySQL, including queries, schema understanding, and data loading.
• Hands-on experience with Talend Open Studio for job design, mappings, and transformations.
• Strong SQL skills for performance tuning and data validation.
• Ability to debug and test ETL workflows using database checks and job logs.
• Knowledge of performance and reliability practices for batch data processing.

Preferred Skills

• Basic Linux shell skills, log inspection, and troubleshooting.

Key Skills

Education

Any Graduate