Friday, 26 December 2014

General and Advanced ETL Testing Interview Questions

ETL Testing Interview Questions

General Questions

• What is a three tier data warehouse?
• What are OLTP and OLAP?
• Who are the participants of data warehouse testing?
• What is Master data management?
• Mention what are the types of data warehouse applications and what is the difference between data mining and data warehousing?
• Explain what is tracing level and what are the types?
• Explain what is Grain of Fact?
• What is MDM (Master data management) ?
• What is Full load & Incremental or Refresh load?

General ETL Interview Questions

• What is ETL?
• What is ETL process? How many steps ETL contains?
• Why ETL testing is required?
• What are ETL tester responsibilities?
• Explain ETL testing life cycle?
• Explain ETL Mapping Sheets?
• How many types of ETL Testing?
• Mention few Test cases and explain them
• How to prepare test cases for ETL / Data Warehousing testing?
• How many types of Bugs in ETL?
• Explain what are the ETL testing operations includes?
• What are the various tools used in ETL?
• How to fine tune mappings?
• What are the differences between SQL Override and Update Override?
• Data Warehouse Testing vs Database Testing
• Who are the participants of data warehouse testing

Advanced ETL interview Questions

• In your project you are using which type of data base and how much space ?
• What is tracing level? How many types of transformations supported by sorted input?
• If there are ten thousand records in a source system, how do we ensure that all ten thousand are loaded to the target without any dysfunctional values?
• I have ten records in my source system but I need to load only 2 records to the target for each run. How do I do this?
• Give some examples of real time data warehousing


  1. brillant piece of information,this blog is fantastic...for more details

  2. Appreciation for nice Updates,nice blog article.for more details

  3. Very nice and informative blog.Nice piece of knowledge!For more details

  4. To get more information about the best transformation tools, you may visit our youtube channel. To transform any data into any database fast and easily ETL tools are required. There are so many useful tools. People from all over the word can use whenever they need to transform any data into any database faster.

  5. Thanks for giving Good Example. Very well written. We are Providing Online training classes<a href=">ETLTestingonlinetraining</a>

  6. Thanks for providing information. It was very nice topic and it is very useful to Testing tools learners. We also provide online training classes.
    ETL Testing Online Training

  7. Very good and unique collection of questions and answers thank you for sharing this information. Know more about ETL Testing Online Training