Data/ETL Operations (Assistant Manager or Manager Level)

JD: Data/ETL Operations (Assistant Manager or Manager Level)

Exp.: 6+ years

Work Location: Hyderabad

Work Timing: Rotational Shifts

Work Mode: WFO

Position Type: Permanent (Fulltime)

Notice Period: Immediate

JOB SUMMARY:

We are seeking a seasoned Support Lead (Assistant Manager or Manager Level) to take full

ownership of our L2.5 Data/ETL Operations. This role demands a proactive leader who can manage real-time ETL support, drive root cause analysis, and implement preventive automation strategies.

The ideal candidate will be a hands-on expert in ETL tools and SQL Server, with a strong track record in incident management and team leadership.

KEY RESPONSIBILITIES:

? Coordinate and manage ETL support incidents and escalations with full ownership of the

L2.5 support model.

? Oversee real-time monitoring and detection of failed jobs, incomplete data, and

orchestration issues using ETL logs and workflow monitors.

? Drive immediate triage, reruns, and validation of failed processes to minimize business

impact.

? Lead root cause analysis (RCA) and ensure implementation of long-term corrective actions.

? Develop preventive automation scripts and controls to auto-restart jobs or alert upstream

dependencies.

? Track and report key performance metrics including job success rates, downtime reduction,

and RCA closure.

? Maintain and document corrective actions, RCA reports, and process improvements in the

knowledge base.

? Ensure SLA adherence and provide regular status updates to stakeholders and leadership.

? Collaborate effectively with client teams and offshore/onshore counterparts.

? Mentor and lead L2.5 support engineers, promoting continuous improvement and

accountability.

REQUIRED SKILLS & QUALIFICATIONS:

? Strong hands-on experience with:

o SSIS

o Informatica PowerCenter 10.5.1

o Informatica IICS

? Proficiency in SQL Server (20162022), including:

o T-SQL

o Agent jobs

o Stored procedures

? Familiarity with monitoring tools such as:

o SQL Agent

o Informatica Console

o Email/Slack alert systems

? Excellent leadership, coordination, and communication skills.

? Proven ability to manage teams, track performance, and ensure SLA compliance.

? Strong analytical skills with expertise in RCA documentation and reporting.

MUST HAVE:

? Customer management

? Client management

? Incident coordination

? Escalation matrix reporting

? Monitoring tools

? Etl tools