Informatica / ETL Production support

 Title: Informatica / ETL Production support
Experience: 4+ Years

Detailed JD:
 

• 4 to 6 years of production support experience on Informatica/ETL Applications. 
• Good understanding 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 quickly.  
• 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.
• Hands-on experience in Unix scripting/file operations and PMCMD command lines.
• Basic understanding of Informatica-Mainframe connectivity (Power exchange).  Knowledge on Mainframe systems would be plus. 
• Strong knowledge of SQL/PL-SQL and oracle Databases.  Able to debug complex queries.
• Good understanding on scheduling tool such as TWS/Others.
• Worked at least 4 years on ServiceNow for application incident management, problem management in a 24*7 model.
• Ability to do the Root cause analysis, recap the issues and problem in an email and communicate to all stakeholders and cross commit teams.
• Strong analytical capability to do independent ticket analysis and resolution.
• Strong communication skills both written and verbal with the ability to follow the processes.
• Should be flexible working in different shifts during India day/evening (weekends). Willingness to work in night shifts as needed.