Data/ETL Operations (Assistant Manager or Manager Level)

Role Overview: You are a seasoned Support Lead (Assistant Manager or Manager Level) responsible for taking full ownership of L2.5 Data/ETL Operations. Your role involves managing real-time ETL support, driving root cause analysis, and implementing 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. Qualification Required: - Strong hands-on experience with SSIS, Informatica PowerCenter 10.5.1, and Informatica IICS. - Proficiency in SQL Server (2016-2022), including T-SQL, Agent jobs, and stored procedures. - Familiarity with monitoring tools such as SQL Agent, Informatica Console, and 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. Additional Company Details: Omit this section as there are no additional details provided in the job description.,