ETL Informatica MDM Consultant


Richmond, VA

Industry: IT Consulting/Services


Not Specified years

Posted 292 days ago

  by    Cynet Sytems

This job is no longer available.

Job Description:

  • 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