Job Summary:
The Informatica PowerCenter Support Lead will be responsible for leading enterprise production support operations across Data ETL environments, with deep hands-on expertise in Informatica PowerCenter. The role requires strong experience in L2/L3 production support, incident management, performance optimization, and troubleshooting complex ETL workflows. The candidate will oversee critical production incidents, batch job failures, root cause analysis, production deployments, and environment coordination across DEV, SIT, UAT, and PROD. The position also involves providing technical leadership, mentoring support teams, improving operational processes, and ensuring production stability and reliability.
Key Responsibilities:
• Lead L2/L3 production support operations, managing critical P1/P2 incidents, batch job failures, problem management, root cause analysis (RCA), and permanent corrective actions.
• Manage and troubleshoot Informatica PowerCenter mappings, mapplets, workflows, sessions, Workflow Manager, Workflow Monitor, and Repository Manager.
• Diagnose long-running or failed workflows, session failures, data discrepancies, source-to-target dependencies, and batch processing issues.
• Perform advanced Oracle SQL and PL/SQL analysis, including complex query troubleshooting, stored procedures, and database/ETL performance tuning.
• Monitor and recover production batch processes using UNIX/Linux shell scripting and enterprise scheduling tools such as AutoSys and CA Workload Automation.
• Drive performance optimization and stability improvements across PowerCenter mappings, sessions, source queries, and large-volume data loads.
• Own production deployments, release management, change management, and environment coordination across DEV, SIT, UAT, and PROD.
• Perform post-production validation to ensure successful deployments and application stability.
• Provide technical leadership and mentorship to the production support team.
• Establish and maintain operational runbooks, knowledge articles, and support documentation.
• Drive automation initiatives and reduce recurring production incidents.
• Manage customer and stakeholder communications during critical incidents.
• Lead critical incident bridges and coordinate resolution activities across application, database, and infrastructure teams.
• Communicate executive-level incident status and provide timely updates to stakeholders.
• Support 24x7 on-call operations as required.
Required Qualifications:
• Minimum of 15 years of overall Data ETL experience, with extensive hands-on expertise in Informatica PowerCenter and enterprise production support environments.
• Strong expertise in Informatica PowerCenter, including mappings, mapplets, workflows, sessions, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensive experience in L2/L3 production support, incident management, and complex production troubleshooting.
• Advanced hands-on experience with Oracle SQL and PL/SQL, including complex query analysis, stored procedures, and database/ETL performance tuning.
• Experience diagnosing workflow failures, session failures, data discrepancies, source-to-target dependencies, and batch processing issues.
• Strong experience with UNIX/Linux shell scripting.
• Experience with enterprise scheduling tools such as AutoSys and CA Workload Automation.
• Expertise in ETL performance tuning and optimization involving PowerCenter mappings, sessions, source queries, and large-volume data loads.
• Experience managing P1/P2 incidents, problem management, root cause analysis, and permanent corrective actions.
• Experience managing production deployments, release management, change management, and environment coordination across DEV, SIT, UAT, and PROD.
• Strong customer and stakeholder management skills.
• Ability to coordinate across application, database, and infrastructure teams during critical incidents.
• Excellent communication skills, including executive-level status reporting.
• Ability to support 24x7 on-call operations when required.
Preferred Qualifications:
• Experience with Microsoft Fabric Data Engineering.
