ETL Informatica MDM Consultant

Confidential Company  •  Richmond, VA
Salary depends on experience
Posted on 02/21/18 by Cynet Sytems
Confidential Company
Richmond, VA
IT Consulting/Services
Salary depends on experience
Posted on 02/21/18 Cynet Sytems

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

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.