Desirable experience with Informatica IDQ
Exposure / understanding of Informatica MDM
Consulting designing, developing and deploying a business intelligence and data warehousing project.
Provide consulting to clustering of ETL solution with failover design
Provide solutions to performance bottlenecks
Work as a guide and mentor of the development team
Help manage security of Informatica environments define guidelines for privileges and roles at ETL level
Assess nonfunctional requirements and align ETL solution to cater to those
Provide leadership and direction on ETL portion of project using Informatica PowerCenter, data services - IDQ and MDM.
Hands-on development using Informatica PowerCenter to create initial ETL load routines and establish standard and templates
Create design pattern templates for deliverable objects
Define and implement ETL development standards and procedures
Define and implement ETL tool configuration
Ensure effective ETL functional decomposition into deliverable objects
Ensure ETL quality through reviews
Strong analysis and design skill
Strong experience with business intelligence and data warehousing design principles and industry best practices
Deep understanding of database and data warehouse design concepts and SQL programming
Understanding of banking domain and CRM would be an added advantage.