Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using Informatica, Best Practices and Troubleshooting.
Exceptional Informatica Power Center expertise, version 10.x or later
Translate business requirements into technical requirements
Proven experience in designing and building integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.)
Design, Development and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 10.x.
Performance tuning of end-to-end integration processes within Informatica workflow, or in the source/target database endpoints as needed.
Strong PL/SQL knowledge
Experience with batch process ETL mapping
Ability to create and manage ETL documentation
Experience with SQL (advance queries, tuning), PL/SQL
Ability to work with business and technology users to elicit requirements and refine mapping documents
Very good analytical and debugging skills
Proactive in identifying any issues and look for the better solution
Proactively identify system and feature improvements and opportunities to improve the platform.