The position was for a data warehouse project management job with Microsoft. It was contract to hire. The technical portion was mostly involved with the data warehouse process for a migration of data from a huge source system into a star schema with multiple fact tables. I received points for speaking about the problems in performance when using a snow flaked model and how to partition using mini-dimensions. Dr. Kimball's methodology was discussed at length. We spent time on data quality issues and data profiling in particular. Reporting was glanced over as this was mostly to produce the data and data structure to pull reports. The project management portion was almost exclusively concerned with the use of MS Project. I got the question of "What are the best practices when using MS Project?" I had not reviewed anything on MS Project and did not do well. The best practices were all so obvious that I wouldn't have thought they were anything other than standard. All other project questions were not difficult. I would have thought they used an Agile methodology but they didn't.