MDM

MDM Lead

Location Raritan NJ Onsite

Long Term

Find below Questionnaire and share strong profiles as per skill set

SQL PLSQL Match rules add new source mapping is correct

Need people who has experience on backend of Informatica rather than frontend

Backend tables

Writing procedures

Merge and Un-Merge

Do external match

API packages Data Analysis Impact analysis SIF packages

User Exits

How much you know about merge history and xref history..

You also include any MDM performance analysis - Any slow performance observed and how he resolved it or improved performance

What are your strengths

Scenario based Questions:

1) Daily delta volume is 100k but buinsess wants to load 2 Million data from a new source in a day.

How will you plan your load Also how would you estimate the time the load will

take (STG LOAD Match and merge process User Exits) for your load to complete

So that business is updated accordingly and Daily Production jobs are adjusted for your load window.

Expectations: Should load data in small chunks.

Need to be aware of MDM logs --> block wise processing of data in MDM.

Can use External match load by Rowid and some more tweaks to complete load faster.

2) Decommissioning of a source data (5M volume). How would do that

Again how will you estimate the time it will take considering daily Production jobs are in progress.

Expectations: Need to be aware of MDM Soft deletes and RecalculateBVT process. Also should be aware

of MDM hard deletes.

3) MDM history table volume is increasing and causing concerns. What steps to be taken

Expectations: We can do archiving of MDM history and then perform SQL deletes on History tables.

4) How to perform Full load of an existing Source in MDM (on prem)

Again volume is approx. 6M and how to complete the load efficiently.

5) A MDM reference value is split in to two new values --

Example : An Area code 50 is split into two new values 50A and 50B.

How will this be implemented on all existing Data loaded and sent to downstream

6)I have a source with 1 Mn records in our MDM for 10 years now. That data used to be purchased but now

we are out of contract with the source. So the source vendor asking us to remove that data from our MDM as contract is over.

How we go about it.

This is a handson technical position where the candidate will be responsible for overall implementation of MDM solutions

The candidate for this position should have worked on full life cycle of MDM projects in with proven track record of successful implementations

Deliver endtoend master data management projects for our customers that includes but not limited to Designing data model MDM Hub configuration

designing MDM match rules Performance Improvement E360 Configuration

Work closely with customers and architects to understand the project objectivestimelines

Comprehensive knowledge of ETL process in MDM space and associated batch and realtime integration including performance tuning

Work closely with clients as well as other consultants both at customer sites as well as remote

MDM Consultant with 10 years of experience in Information Management Domain and minimum 23 recent full life cycle implementation experience in MDM Solution in various domains Customer Products etc Significant experience of all aspects of the SDLC in the MDM domain is required This is a client facing role

MDM Tool Informatica MDM experience is required

Skills required

Strong business andor technical background in the areas of Master Data Management Data Quality Data Governance Data Integration ETL SoA and Data Security

Provide expertise in architecting designing and implementing MDM solutions

Perform highlevel architectural planning and proofofconcept where necessary

Develop solution outline and support requirements gathering for MDM projects

Interface with business and IT stakeholders to identify issues and develop solutions

Develop MDM ETL solution architecture and technical architecture

Contribute to the analysis of data requirements data integration and perform data mapping

Lead Design of the MDM application using MDM tools

Configurations and Customizations to the MDM tool and web services

Data mapping

Function as the Design Authority in technical design reviews Approve code reviews and technical deliverables

Plan for development project estimates scheduling and development reviews

Assure architectural integrity in MDM solution

Maintain compliance with change control SDLC and development standards

Develop and review implementation plans and contingency plans

Partner with clients to gather necessary understanding of business objectives and processes and provide clients with information about other relevant business factors

Good presentation and communication skills required

Good interpersonal skills and must be a team player