ETL Informatica

Job Description

• Experience in ETL Informatica and SQL.
• Experience in shell scripting in Agile environment.
• Hands-on experience in performance tuning for complex ETL Mappings.
• Good in Complex mapping design, Mapplet design, workflow design scheduling.
• Knowledge on various transformations used in Informatica like Joiner, Normalizer, Lookup, Filter, Router, Custom transformation.
• Experience in publishing data from semi structured data like JSON.
• Experienced in ETL concepts and tools such as Informatica PowerCenter, SQL, Data Mapping, XML, Web Services.
• Experience in scripting languages like Batch, Shell.
• Experience with integration of data from multiple data sources like DB2, Oracle, SQL server.
• Tests, debugs, and documents ETL processes and SQL queries.
• Ability to gather, analyze, prioritize and present requirements.
• Strong SQL development knowledge for Relational Databases.
• Hands on with SQL tuning with Explains, query plans.
• Experience in Agile Scrum Methodology for Software development.
• Experience in the Banking domain.
• Experience on scheduling tools like Autosys.
• Must possess strong written verbal communication skills with Stakeholders.
• Experience in Production and On call support.