Senior ETL Informatica Developer

We are looking for a Senior ETL Informatica Developer to develop, maintain and support applications involving operational and analytical data stores. The position involves leading, learning and supporting an end-to-end platform that supports two of the largest datastores in the company.

Requirements

• 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