Sr. ETL Engineer

Sr. ETL Engineer

Must Have Technical/Functional Skills

8+ years of experience

Experienced ETL Engineer skilled in designing, developing, and optimizing ETL workflows for large-scale data integration projects.

Proficient in SQL, ETL tools (Informatica, Talend, SSIS, Data Stage, etc.), data warehousing concepts, and performance tuning.

Strong knowledge of data modeling, pipeline automation, and cloud-based data platforms.

Roles & Responsibilities

• Designs and develops ETL processes to extract, transform, and load data from diverse source systems into data warehouses or data lakes.

• Analyzes source data, defines data mapping, and creates technical specifications for ETL jobs.

• Implements data quality checks, validation rules, and error handling within ETL workflows.

• Optimizes ETL jobs for performance, scalability, and reliability.

• Works with data architects and business analysts to understand requirements and design robust data integration solutions.

• Schedules, monitors, and troubleshoots ETL jobs to ensure timely data availability.

• Creates and maintains documentation of ETL processes, data flows, and dependencies.

• Provides metrics and status updates on ETL operations and data pipeline performance.

• Participates in sprint planning, daily stand-ups, and retrospectives to align ETL development with agile processes.

• Mentors junior ETL developers and shares best practices in data integration and automation.