If someone wants to become a DW Architect, there is a lot of knowledge required. Some of the different perspectives (one from MS not specifically for DW, rather enterprise) and another on DW specifically..
Although I think its strange already that someone has to think about the kind of questions being asked in such interview, there are things posted on these lines. i believe its more of a discussion on thought process and approach rather than question-answer session in such an interview. Still, presenting an excerpt, outlining some of the interesting topics that might turn up in a discussion for this kind of position.
- Describe advantages of the CIF architecture versus the bus architecture with conformed dimensions. Which would fit best in our environment given [some parameters they give you] and why
- Describe snow-flaking
- Describe fact-less fact tables.
- Draw a star schema of our business
- Describe common optimization techniques applied at the data model level
- How do you handle data rejects in a warehouse architecture?
- Describe common techniques for loading from the staging area to the warehouse when you only have a small window.
- How do you load type 1 dimensions
- How do you load type 2 dimensions, and how would you load it given our [insert business particularity]
- How would you model unbalanced hierarchies
- How would you model cyclic relations
- What major elements would you include in an audit model?
- How would you implement trace-ability ?
Questions picked up from http://arstechnica.com/civis/viewtopic.php?f=20&t=320772
One of the Microsoft guys wrote about possible feathers in the cap of an Enterprise Architect - http://blogs.msdn.com/b/nickmalik/archive/2006/09/09/ea-interviews.aspx
No comments:
Post a Comment