ETL L2 support Professionals

Required Qualifications:

• 3-5 years

  of production support experience on Informatica/Python/AWS Technologies and applications.


• Must have good understanding and technical knowledge on Informatica architecture/client components such as Workflow Manager, Mapping Designer, workflow monitor and Repo manager.


• Excellent knowledge on AWS/Python concepts. Informatica to Cloud Migration.


• 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 such as Flat files/Mainframes/XML files and Databases.


• Experience on AWS environment, Data Pipelines, RDS, Reporting tools.


• Hands-on experience in Unix scripting/file operations.


• Strong knowledge of SQL/PL-SQL and oracle Databases. Able to debug complex queries.


• Good understanding on scheduling tool such as TWS/TIDAL/Others


• Worked at least 2 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

Preferred qualifications:

• Experience working with US Clients and Business partners.


• Exposure to BFSI domain is a good to have.


• Experience in mainframe technologies will be plus.

Job responsibilities:

• Provide production support for Informatica/Python/AWS suit of applications in 24X7 environment.


• Good understanding of Informatica/Python and AWS environment and able to handle batch recoveries and provide batch support.


• 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.



• Ability to drive production issues bridges and able to work across the teams to collate the impacts and send leadership communications.


• Propose solutions to perform complex troubleshooting.


• Should be able to identify the areas of improvement and re-engineering scope.


• Helping other team members to resolve their technical issues.


• Mentoring the interns and new joiners.

Monitor and report issues and work with the required team/vendor for quick resolution