Data Warehouse Analyst Interview Questions
36
Data Warehouse Analyst interview questions shared by candidates
- on the challenge of mixing both the consultancy approach and the tech-IT ones
1 Answers↳
- offered my view on it, discussed about my openness to it
Are you familiar with the Kimball methodology for data warehousing?
1 Answers↳
I have worked with several methodologies and (at the time) was only vaguely aware of Kimball. That was not a good answer as Kimball is considered by many to be the "father of Data Warehousing". That was pretty much end of story, other than I went home and began reading a Kimball book; later took a 10 week data warehousing course. The course only mentioned Kimball's name once, but covered all of the Microsoft SQL Data Warehousing tools in great detail. Disappointing interview experience led to a career refresh. :) Less
What kind of a sense of humor I had
1 Answers↳
I demonstrated it throughout the interview by joking (appropriately).
Questions about tableau, business objects and SQL Null is null
1 Answers↳
Would you be able to provide more detail regarding the technical test? Thanks!
How do you gather requirements and document them?
1 Answers↳
I went through the process and gave examples, as it's fairly standard.
Unexpected: How do you recover from a database failure?
Most questions were related to my current work experience and some of the tools i have experience with. There were also some situation based questions.
tell me about yourself
