Job Description :
Skills:
7 years of Experience with Informatica Powercenter 9.X
Design, Develop, Test, Implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment
Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment
Strong experience optimizing Informatica mappings, sessions and workflows
Experienced writing complex SQL’s, PL/SQL and Performance tuning is a plus
Strong database experience, data analysis and analytical skills
Experience creating ETL design documentation and maintaining overall design document and deliverables
Strong working experience of the SDLC processes
Strong written and oral communication skills
Good understanding of dimensional modelling and ETL designs for loading Star Schema
Skilled in developing Informatica objects - mappings, sessions, and workflows based on design documents
Experience in debugging mappings and identifying errors and error rows so that they can be corrected and re-loaded into a target system