Stack 4 - Week 2 - Interview Questions

This assignment is optional! If you choose to complete it, your task is to submit a document (word document, Google doc, markdown file, text file, etc.) with your answers to each of the questions below. 

These questions can typically be answered in a couple of sentences, but I encourage you to think about how you would answer these out loud - or even practice answering them out loud - since that is how you would answer them in an actual interview.

It also might be a good idea to keep these somewhere to review for after graduation when you are job hunting! Creating flashcards with potential technical interview questions is a good strategy.

Data Enrichment Week 2 Questions

  1. What are the key steps of the ETL process?

  2. Why is ETL testing important and how can it be done?

  3. Why is data warehousing important?

  4. How is data analyzed in ETL?

  5. What is data profiling in ETL?

  6. What is the difference between an initial load and an incremental load in ETL?

  7. What is the role of ETL in the data mining process?

  8. What are the Enterprise Software ETL Tools?

  9. What are the Cloud-Based ETL Tools?

  10. What is an API?

  11. What are the Limits of API Usage?

  12. Who can use a Web API?

  13. What is API documentation?

  14. How often are the APIs changed and, more importantly, deprecated?

  15. What is REST?

  16. What is a “Resource” in REST?

  17. What are API calls?

Week 2 Data Enrichment Interview Questions Solutions

Answers