Perform data profiling and source to target mappings (while capturing ETL and business metadata) for populating Kimball style dimensional models.
Write scripts for automated testing of data in the target facts and dimensions.
Capture audit information during all phases of the ETL process.
Write and maintain documentation of the ETL processes via process flow diagrams.
Informatica MDM with development skills in Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager
Informatica MDM (Hub and IDD) and Power Exchange
Informatica MDM Service Integration Framework (SIF)
Source control systems and continuous integration tools
Interfacing with ESB?s
Build, Support & Maintain multiple Enterprise Database platforms including Informatica (PowerCenter, Data Quality, Metadata Manager, Master Data Manager, Dashboard Reporting, IDD), Oracle, MS SQL Server, RealTime System, Unix/Linux, Windows, etc.
Experience in Administering the Informatica platform (Install, Upgrade) on Linux o/s & Weblogic application server
Must have participated in and led the requirement gathering /solution architecture for MDM initiatives
Must have designed and implemented end-to-end Informatica MDM including Informatica Data Director (IDD), Hierarchy Manager, Informatica PowerCenter & Data Quality tools
Hands-on experience with MDM Hub configurations - Data modeling & Data Mappings (Landing, Staging and Base Objects) , Mapping, Data Validation , Match and Merge Rules, Writing & Customizing user exits, customizing/configuring Informatica Data Director/Entity360 applications
Build Informatica Platform for the current & future projects by scoping the current & future business growth.
Creating services for real time data integrations using Service Integration framework
Installation, configuration and Administration of CDC at server and client side