Job Description - B2b - 279036 Specialty Development Consultant/Expert in Dearborn
Return to jobs

B2b - 279036 Specialty Development Consultant/Expert

Ref: US_EN_6_971578_1340171

Posted on 17 June 2020
Job Location
Dearborn, Michigan
Contract Type
Information Systems

Seeking a candidate responsible for Informatica MDM HUB (master data management) development support. 

This person should have in-depth hands-on knowledge and experience of the Informatica MDM product, including PowerCenter and IDQ tools. 

Will drive technical solutions and issue resolutions, as well as produce and develop detailed MDM design specs, and develop custom mapping functions and customizations to the database tier of the MDM HUB. 

Will interact with various internal and external stakeholders, and participate in MDM design reviews.

This is a long-term role, seeking someone looking to settle into and grow with the team over the years. 

Modis offers medical benefits and, for those who require it, full sponsorship.

Skills Required:

  • Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations, Informatica Powercenter and IDQ tools Extensive experience in Master Data Management (MDM) HUB Console Configurations such as Staging Process Configurations, Landing Process Configurations, Match and Merge Process, Cleansing Functions, User Exits.
  • Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations.
  • Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
  • Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
  • Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation.
  • Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
  • Helpful Experience/Skills:

  • Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
  • Worked with Sif API to interact with real time applications.
  • Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g, Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server. Experience in Agile, Waterfall and UML Methodologies.
  • Good Exposure to development, testing, debugging, implementation, documentation and production support.
  • Extensive experience in implementation of Data Cleanup procedures, Transformations, Scripts and Execution of Test Plans for loading the data into the targets.
  • Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident.
  • Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.
  • Apply today!

    Equal Opportunity Employer/Veterans/Disabled

    To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit

    The Company will consider qualified applicants with arrest and conviction records.


    Find your local office.

    Modis has over 100 offices in the United States, Canada and Europe. With both industry and location-specific expertise, our people know their area and their labor market and can find the right position for you.