Course 01 Self-paced
Informatica MDM
Informatica MDM improves data integration solutions’ learning and output capabilities across business processes, leading to a single trusted source for Data-Driven Digital Transformation.
Tool access: 3 months.
1. Introduction to MDM
- What is MDM?
- Google trend report on MDM
- What is the scope of this MDM course?
- Why do we need MDM?
- Will MDM cut jobs?
- Is MDM a Hype or is it Real?
- Where does MDM stand (compared to other competitors)?
- Google trend report on Competitors and comparison
- Naukri and Monster job openings
- Salary report from Indeed & Payscale
- A walkthrough on the course content
2. What is Informatica MDM
- Short Informatica MDM demo with a real-time project
- Navigation
- What is the scope of Informatica MDM Training
- Important options and shortcuts in the tool
- Types of tools in Informatica MDM (walkthrough)
- Architecture - SOA, Client server or Cloud
- Informatica MDM Cloud?
3. Installation of Informatica MDM
- Supported systems (Is Windows, Linux, Mac supported)
- What is the alternative if it’s not supported (Virtualbox)
- Supported databases
- Integration with other tools
- Limitations
4. Informatica MDM Version 10.1 Overview and Architecture
- Master Data Management
- A Reliable Foundation of Master Reference Data
- Components of MDM Hub
- Application Server Tier
- Database Server Tier
- Batch Data Process Flow
- Trust Framework
- Consolidation Flag
5. Data Models and Lookups
- Data Model Elements
- Data Model
- Relationships
- Relationship Types
- Lookups
- Global Business Identifier (GBID)
6. Configuring Stage Process
- Basic Mappings
- Complex Mappings
- Cleansing and Transforming Data
- Execution Component
- Testing Mappings
- Reusable Cleanse Components
- External Data Cleansing
- Delta Detection & Audit Trail
- Rejects
- Cleanse Match Servers
- High-Level Stage Process Flow
- Detailed Stage Process Flow
7. Configuring Load Process
- Trust
- Validation Rule
- Trust & Validation Rules - things to note
- Cell Level Update
- Allow NULL Update
- Allow NULL Foreign Key
- How the Load works
8. Configuring Match & Merge Process
- Match & Merge Overview
- Key Activities for Configuring Rules
- Match/Search Strategy for Base Object
- Population
- Match Path, Columns and Match Key
- Match Rules and Rule Sets
- Primary Key Match Rules
- Match Rules using Primary Key Match
- Match Keys Distribution
- Merge Settings
- Match/Merge Properties - Merge Style Base Object
- External Match
- Match Server Architecture
9. Configuring Data Access
- Queries & Packages Overview
- Query
- Package
10. Batch Processes
- Batch Viewer
- Batch Group
- Executing Stored Procedures
- Scheduling Considerations
- Job Status & Job Statistics
11. Data Management Tools
- Data Stewardship
- Recap: Consolidation Flags
- Merge Manager
- Data Manager
- Unmerge and Tree Unmerge
12. User Exits
- User Objects
- User Object Registry Tool
- User Exits in Java
- User Exits in the STAGE Process
- User Exits in the LOAD Process
- User Exits in the MATCH Process
- User Exits in the MERGE Process
- User Exits in the UNMERGE Process
13. Log Files
- Enterprise Manager
- Hub Server Tab
- Cleanse Servers Tab
- Environment Report Tab
- ORS Databases Tab
- Database Log File
- Application Server Log
- Cleanse/Match Server Logs
- Console Log
14. Hierarchy Management
- Entities & Entity Type
- HM Relationships
- HM Hierarchies
- Hierarchy Management
- HM Profiles
- HM Packages
15. Security Access Manager (SAM)
- Users, Resources, Privileges & Roles
- Resources
- Resource Groups
- Privileges
- Roles
16. Services Integration Framework (SIF)
- Introduction to Siperian SIF
- SIF Framework
- SIF Features & Benefits
- SIF & Integration
- Interacting with SIF
- SIF Architecture & Protocols
- SIF Request Object with Examples
- Processing Responses
- About Record
- SIF APIs with Examples
- ORS Specific APIs
- Introduction to SIF Manager
- Logging
- Auditing
17. Informatica Data Director (IDD)
- IDD Configuration
- Business Data Director - User Interface
- Create, Manage, Consume and Monitor
- Data Model Elements
- Configuration File
- Subject Area
- Subject Area Groups
- BDD Data Display
- Relationships
- Application Validation
- Importing an Application
- Match Paths
- Lookup
- Cleansing
- Resources and Privileges
18. Message Queue
- What are Message Queues
- Create a Message Queue in Application Server
- Configure the ORS Specific Schema
- Test the Queue
- Configure the MRM to the Queue
- Checking Message Queue count in App server
- Publish Message to the Queues
19. Advanced Topics
- Job Scheduling
- Creation of ORS
- Installation
- Load by Rowid Object
- External Matching
20. CanopY Project in MDM
- Project Overview
- How to configure an end to end real-time project
- Project Guidance
- Project Submission and Verification
21. Mock Interviews with Questions and Answers Discussion
- Functional Q&A
- Technical Q&A
- Project Q&A (for multiple domains like Banking, Retail, Insurance, Ecommerce etc)
- Questions for Freshers and Experienced (how do they differ?)
- How to justify if the resource is not certified
22. Certification Preparation Session
- How difficult is it to clear the certifications
- Levels of certification
- How to register for them (technical details)
- Can I apply for certification if my company is not a partner
- If not, what is the alternative
- Certification mock Q&A discussion
23. Resume Preparation Help
- What’s a best resume
- What if my resume is worst
- How to prepare a great resume
- Should I be on LinkedIn - of course yes
- Providing photo, Facebook, LinkedIn, Twitter links in a resume
- Create blog, Quora, Stackexchange etc and provide the links in resume
- SEO in Naukri (how to be on the top)
- Creating multiple profiles in case you need a job urgently
- Floating your resume in Monster, Indeed, Shine etc
- How to search for job providers and jobs in LinkedIn
- Aggressive follow - that’s what counts
24. Post Job Support
- How can we support you if you are in a project
- Can we help you in a disaster recovery process
- How to be in touch with my colleagues and experts
