7+ of ETL development experience including experience with Informatica PowerCenter,
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,
Experience writing complex SQL, PL/SQL and Performance Tuning is a plus,
Strong database experience ( Oracle, DB2, Redshift, PostGre ), 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 modeling and ETL designs for loading Star Schemas,
At Least 2+ years experience working with Informatica Data Quality and Informatica MDM.,
Informatica cloud experience is nice to have,
Strong UNIX experience, Experience working and interacting with Business stakeholders.
Experience working in a team and onsite-offshore model.
Cognizant Technology Solutions