Job Summary:We are seeking a highly skilled Production Support Lead to manage and support mission-critical applications and systems involving Informatica IICS, SQL, Oracle, Unix/Linux, and Snowflake. The ideal candidate will have deep technical expertise, strong troubleshooting abilities, and leadership experience in a 24x7 production support environment. This role requires hands-on involvement with ETL workflows, database performance tuning, shell scripting, and data warehouse optimization.
Job Responsibilities:- Lead and manage production support for critical enterprise applications.
- Monitor, troubleshoot, and resolve issues related to Informatica IICS ETL workflows.
- Optimize SQL queries and ensure Oracle database performance and reliability.
- Write and maintain Unix/Linux shell scripts and manage job scheduling tools.
- Ensure Snowflake data warehouse performance, including tuning and optimization.
- Act as the primary escalation point for production issues and coordinate resolution efforts.
- Maintain uptime and performance of systems in a 24x7 production environment.
- Coordinate with cross-functional teams for issue resolution and system improvements.
- Document incidents, root causes, and resolutions for knowledge base.
- Provide leadership and technical direction to support team members.
Required Skills:- Minimum 8 years in a 24x7 production support environment.
- Strong experience managing and troubleshooting Informatica IICS ETL workflows.
- Expertise in SQL and Oracle with a focus on query optimization and performance tuning.
- Hands-on experience with Unix/Linux shell scripting and job scheduling tools.
- Experience with Snowflake, including data warehousing, query tuning, and performance optimization.
- Proven leadership in a production support environment.
Mandatory Skills:- Informatica Axon
- Informatica Data Privacy
- Informatica PowerCenter
- Informatica Data Quality
- Informatica ILM
- Informatica EDC
Experience:8+ years in a production support role, particularly in 24x7 environments.
Deep experience with Informatica products and data platforms.
