Master Data Management Interview Questions

6854

Master Data Management a Buzzword in Business Intelligence area. Here we are compiling some of the core MDM Interview Questions, with supporting Domain and technology specific questions.

see Master Data Management Interview Questions

Master Data Management consists of a stack of technologies, Ranging from Database – Application to UI Level.

Core MDM Interview Questions

  1. What is Master Data Management?
  2. What is Reference Data?
  3. What do you mean by Master Data?
  4. What do you mean by Data Quality?
  5. What doesData Enrichment mean?
  6. What do you mean byData Centralization?
  7. What is Data Acquisition and Integration?
  8. What do you mean by
    • Data Standardization
    • Data Distribution
    • Data Redundancy
    • Controllership
    • Full Data Life Cycle
    • Data Governance
  9. What was there a need to implement MDM?
  10. What is the significance of MDM for you’re client/in your project?
  11. Explain some problems faced before Master Data management?
  12. Which Master Data management Tool you are using? Explain the functionality of
    1. Mapping Designer
    2. Workflow Management
    3. Patch Installation
    4. Resource management
    5. Business Rule management
  13. For which Domain you are using MDM?
  14. What other technologies come under the umbrella of Master Data management?
  15. What are the benefits of the Master Data Management (MDM) solution?
  16. What are the different types of MDM System available?

Other than that, according to your MDM Tool, you will be asked for Databases Questions, Business Rule Language Questions like (Java, C, SAS etc.) and User Interface Related Questions.

You should be aware of entire MDM Architecture Implemented in your Project. IF you are using UNIX Server than below are some basic questions that can be asked as part to check you comfort level towards UNIX .

Basic UNIX Question asked during MDM Interview

  1. What is UNIX?
  2. What is a typical syntax being followed when issuing commands in shell?
  3. Is there a way to erase all files in the current directory, including all its sub-directories, using only one command?
  4. What is Shell?
  5. What are some common shells and what are their indicators?
  6. What is command substitution?
  7. Describe file systems in UNIX
  8. Differentiate relative path from absolute path.
  9. Explain the importance of directories in a UNIX system
  10. What are shell variables?
  11. What is Bash Shell?
  12. What is the use of -l when listing a directory?
  13. What is pid?
  14. What is wild-card interpretation?
  15. Ls, GREP, Copy, Move and Rename commands?

Basic Data Warehousing Interview Question asked during MDM Interview

  1. What is Data Warehousing?
  2. What are fundamental stages of Data Warehousing?
  3. What is Dimensional Modelling?
  4. What is Fact table?
  5. What is Dimension table?
  6. What is OLTP?
  7. What is OLAP?
  8. What is data mart?
  9. What is the difference between OLTP and OLAP?
  10. Describes the foreign key columns in fact table and dimension table?
  11. What is Data Mining?
  12. What is the difference between view and materialized view?
  13. What is ER Diagram?
  14. What is ODS?
  15. What is ETL?
  16. What is VLDB?
  17. If de-normalized is improves data warehouse processes, why fact table is in normal form?
  18. What is real time data-warehousing?
  19. What are Aggregate tables?
  20. What are conformed dimensions?
  21. How do you load the time dimension?
  22. What is a level of Granularity of a fact table?
  23. What are non-additive facts?
  24. What is factless facts table?
  25. What are slowly changing dimensions (SCD)?
  26. What is hybrid slowly changing dimension?
  27. What is a Star Schema?
  28. What is Difference between ER Modelling and Dimensional Modelling?
  29. Why is Data Modelling Important?
  30. What is surrogate key?
  31. What is Data Mart?
  32. What is the difference between OLAP and data warehouse?
  33. What is a Cube and Linked Cube with reference to data warehouse?
  34. What is active data warehousing?
  35. What is the difference between data warehousing and business intelligence?

Miscellaneous Questions on MDM

  1. What is Winscp?
  2. How would you use Winscp?
  3. What is Putty?
  4. How would you use Putty?
  5. What is subversions?
  6. How would you manage versions of your code?
  7. What is Tortoise SVN?
  8. Which tool you have used for maintaining subversions of your code?

Above are some of the Core MDM and Supporting Technologies Interview Questions. Other than that you should be aware of latest trends in your domain and Business intelligence area. Also you should know the latest tools to implement MDM and domain specific MDM tools.