Experience in Informatica Power Center 9.x (ETL) - (Designer, Repository Manager, Workflow Manager), Job Schedulers.
Extensive experience on Informatica Power Must have experience in Installation, Configuration and Administration of Informatica Power Center.
Must have experience in building complex SQL queries and Shell scripting.
Strong on DW Fundamentals, concepts.
Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems.
Excellent understanding of various relational database design concepts.
Extensive experience in Data Modeling & Architecture.
Experience full lifecycle data warehouse development.
Experience in managing BI App Support & Maintenance projects.
Exposure to Informatica MDM is a big plus.
Strong experience in Data Migration and Data Quality initiatives.
Error handling and Performance Improvements.
Conduct and participate in design and code walkthroughs.
Good hands on capability - can independently develop good quality deliverable and guide/mentor junior team members effectively.
Participate in requirements gathering sessions with stakeholders from business and IT teams.
Communicates effectively with business partners to identify needs and evaluate options.
Help BI reporting developers with analysing data source, designing, testing and implementing Analytics reports and dashboards.