Software Engineer

Nagarro; Pune District; On-site; INR 1,500,000 - 3,000,000; Full time

Job summary

Nagarro in Pune seeks a seasoned Technical Lead ETL Operations to manage production support for data pipelines. You will lead L1/L2 teams, drive incident resolution within SLAs, and improve support processes across stakeholders.

Responsibilities include monitoring, scheduling, automation, RCA, and collaboration with development and business teams. Strong ETL tool experience and cloud data platforms are essential.

Qualifications

• 4+ years of experience in ETL development and/or operations.
• Proven track record of leading production support teams in 24x7 or critical data environments.
• Strong hands-on knowledge of ETL tools (Informatica, Talend, SSIS, DataStage).
• Proficient in SQL, Python, PySpark and data warehouse concepts.
• Experience with job orchestration/scheduling tools (Control-M, Airflow, Autosys).
• Familiarity with incident management and ITSM tools (ServiceNow, Jira).
• Exposure to cloud-based data platforms (AWS Glue, Azure Data Factory).
• Strong communication and leadership skills.
• Willing to work in 24x7 support projects.

Responsibilities

• Operational Leadership & Incident Management: act as primary escalation point for critical ETL incidents and outages.
• Own and drive incident triage, resolution, and communication across support, development, and business teams.
• Lead root cause analysis (RCA) and ensure timely documentation and follow-up.
• Team & Process Ownership: lead L1 and L2 support teams, prioritization, shift planning, and knowledge sharing.
• Ensure SLAs and KPIs for incident resolution, job monitoring, and support activities are met.
• Develop and maintain SOPs, runbooks, and operational playbooks; planning capacity and KT.
• Monitoring, Scheduling & Automation: own ETL job monitoring framework; alerting and response.
• Oversee job scheduling across Control-M, Airflow, Autosys; coordinate updates and enhancements.
• Identify automation opportunities to reduce manual effort and improve response time.
• Stakeholder Engagement: interface with development data owners and business stakeholders; lead review meetings and reports.
• Change & Release Support: coordinate ETL enhancements, hotfixes, and production deployments; ensure documented changes.
• People Development: mentor and coach L1/L2 engineers; conduct KT sessions and maintain documentation hygiene.

Skills

ETL Development

Production Support Leadership

SQL

Python

PySpark

Data Warehouse Concepts

Job Orchestration Tools

Informatica

Talend

SSIS

DataStage

Control-M

Airflow

Autosys

ITSM Tools

ServiceNow

Jira

Cloud Platforms

AWS Glue

Azure Data Factory

Communication Skills

Leadership

24x7 Support

Tools

Informatica

Talend

SSIS

DataStage

Control-M

Airflow

Autosys

ServiceNow

Jira

Job description

Preferred candidates

Please share the resumes of candidates who meet the following criteria:

• Available for a face-to-face interview
• Interview location: Pune/Noida/Gurgaon.
• Able to complete the online test within 15 hours of receiving the assessment.
• The test must be taken without using headphones.
• There is no negative marking in the test.

Role & responsibilities

We are seeking a seasoned Technical Lead ETL Operations to drive and manage production support for our data integration pipelines. The role involves leading L1 and L2 teams, ensuring incident resolution within SLAs, managing operational escalations, performing root cause analysis, and continuously improving support processes.

Key Responsibilities

Operational Leadership & Incident Management

Act as the primary escalation point for critical (P1/P2) ETL incidents and outages.

Own and drive incident triage, resolution, and communication across support, development, and business teams.

Lead root cause analysis (RCA) and ensure timely documentation and follow-up.

Team & Process Ownership

Lead L1 and L2 support teams, including task prioritization, shift planning, and knowledge sharing.

Ensure SLAs and KPIs for incident resolution, job monitoring, and support activities are consistently met.

Develop and maintain SOPs, runbooks, and operational playbooks.

Participates in plannig capacity, onboarding new workflows, KT plans

Monitoring, Scheduling & Automation

Own the ETL job monitoring framework; ensure effective alerting, escalation, and response.

Oversee job scheduling and orchestration tools (e.g., Control-M, Airflow, Autosys), coordinating updates and enhancements as needed.

Identify and implement automation and tooling improvements to reduce manual effort and improve response time.

Stakeholder Engagement

Interface with development teams, data owners, and business stakeholders to communicate support issues and planned changes.

Lead operational review meetings, provide weekly/monthly reports, and contribute to service improvement initiatives.

Change & Release Support

Coordinate minor ETL enhancements, hotfixes, and production deployments in collaboration with development and release teams.

Ensure change tickets are well-documented, tested, and approved.

People Development

Mentor and coach L1/L2 engineers.

Conduct KT sessions, track skill gaps, and ensure documentation hygiene across the support team.

Required Skills & Qualifications

4+ years of experience in ETL development and/or operations.

Proven track record of leading production support teams in a 24x7 or critical data environment.

Strong hands-on knowledge of ETL tools (e.g., Informatica, Talend, SSIS, DataStage).

Proficient in SQL, python, PySpark and data warehouse concepts.

Experience with job orchestration/scheduling tools (e.g., Control-M, Airflow, Autosys).

Familiarity with incident management and ITSM tools (e.g., ServiceNow, Jira).

Solid understanding of root cause analysis, incident workflows, and SLA-based support.

Exposure to cloud-based data platforms (AWS Glue, Azure Data Factory, etc.) is a plus.

Strong communication and leadership skills.

Willing to work in 24x7 support projects