ETL Developer

Job description

We are seeking an experienced ETL Developer with 3+ years of hands-on experience in designing, developing and maintaining ETL processes to support data warehousing and analytics solutions. The ideal candidate will work closely with data architects, analysts and business stakeholders to ensure reliable, high-quality data pipelines.

Key Responsibilities:

Design, develop, and optimize ETL workflows to extract, transform and load data from multiple sources

Build and maintain scalable data pipelines for structured and semi-structured data

Perform data profiling, validation and reconciliation to ensure data accuracy and quality

Collaborate with data architects and business teams to understand data requirements

Tune ETL jobs for performance, scalability and reliability

Troubleshoot and resolve ETL job failures and data issues

Implement error handling, logging and monitoring mechanisms

Maintain technical documentation for ETL processes and data flows

Support production deployments and ongoing maintenance activities

Required Skills & Qualifications:

3+ years of experience as an ETL Developer or Data Engineer

Strong experience with ETL tools such as Informatica, Talend, SSIS, DataStage, or AWS Glue

Proficiency in SQL (complex joins, subqueries, performance tuning)

Experience with relational databases (Oracle, SQL Server, PostgreSQL, MySQL)

Good understanding of data warehousing concepts (star/snowflake schema, facts & dimensions)

Experience handling large datasets and batch processing

Knowledge of Unix/Linux shell scripting

Familiarity with version control tools (Git, SVN)

Nice to Have:

Experience with cloud platforms (AWS, Azure, GCP)

Exposure to Python or Spark for data processing

Experience with scheduling tools (Airflow, Control-M, Autosys)

Knowledge of data governance, security and compliance standards