Role: Informatica MDM Lead
Location: Raritan, NJ Onsite
Type: Contract
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"