Informatica Production Support SpecialistProvide production support for Informatica suit of applications in 24X7 environment.Good understanding of Informatica environment and able to handle batch recoveries and production support issues.Assess & recommend solutions for permanent fixes to improve application stability and resiliency.Ability to handle production incident bridge calls for P1 and high priority P2 incidents.Strong analytical capability to do independent ticket analysis and resolution.Incident Management/Problem management and Change management.Ability to do the Root cause analysis, recap the issues and problem in an email and communicate to all stakeholders and cross commit teams.Required Qualifications:4-6 years of production support experience on Informatica suit of applications.Must have good understanding and technical knowledge on Mainframes on Informatica architecture/client components such as Workflow Manager, Mapping Designer, workflow monitor and Repo manager.Hands-on expertise in debugging Informatica ETL Mapping to narrow down the Issue.Hands-on experience in ETL transformation such as lookup/joiners/source qualifier/normalizer.Hands-on experience in dealing with various types of sources in Informatica such as Flat files/Mainframes/XML files and Databases.Basic understanding of Informatica-Mainframe connectivity (Power exchange).Hands-on experience in Unix scripting/file operations and PMCMD command lines.Strong knowledge of SQL/PL-SQL and oracle Databases. Able to debug complex queries.Good understanding on scheduling tool such as TWS/OthersWorked at least 4 years on ServiceNow for application incident management, problem management in a 24*7 model.Strong communication skills both written and verbal with the ability to follow the processes