Senior ETL Informatica Developer

We are looking for a ETL Developer to develop, maintain and support applications involving predominately operational and relevant analytical data stores for the ETL Team within the Brokerage Technology domain. This position provides an exciting opportunity for the individual to lead, learn and support and end-to-end platform that supports two of the largest datastores in the company.

Requirements

• Provide production support for Informatica/AWS suit of applications in 24X7 environment.
• 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.
• 2-8 years of production support experience on Informatica/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/DataLake 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 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

Benefits

• 24X7 environment
• Flexible timings (2:00p-10:30p)