JOB DESCRIPTION *
Strong development experience in Informatica PowerCenter 9.6.1 or above. Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services.
Experience in Referential data and metadata management is a good plus. Good understanding of data governance principles.
Familiar with RDBMS like Oracle and SQL Server, understanding the data modeling, and excel in PL-SQL. Assist in the identification, planning, implementation, and support of various Data Services initiatives and support business-critical analysis.
JOB REQUIREMENTS
Analyze highly complex business requirements, design and write technical specifications to design or redesign complex ETL solutions.
Perform detailed data analysis to understand the source system data.
Responsible for the development and modification of Informatica jobs and ETL processes for Enterprise Data Warehouse.
Hands on experience in Design, Development, Build & Test activities in Informatica.
Understanding of the SDLC, good practices and experience with different development and change management tools.
Experience in troubleshooting of Informatica jobs and addressing production issues like performance tuning and enhancement.
Develop solution in highly demanding environment and provide hands on guidance to other team members.
Develop & Implement an Informatica based ETL solution fulfilling stringent performance requirements.
Collaborate with product development teams and senior designers to develop architectural requirements to ensure business requirements are met.
Assist and verify design of solution and production of all design phase deliverables.
Review physical Database objects including staging, materialized views, indexes provided by Data Modeler.
Prior experience in migrating legacy application data to new data warehouse / application database.
Knowledge on Unix / Linux, Shell Scripting will be an added advantage.
Knowledge in Replication tools(i.e.Attunity, etc..) is a big plus.