The first interview was a phone interview with HR. She asked some very general questions and had a list of technical questions as well.
Some of them were:
clustered vs non-clustered indexes
the meaning of @@ERROR in T-SQL
The second technical phone screen was more in-depth. There are questions regarding sorting, ADO.NET, Web Services, .NET Collections, the .NET framework, and SQL. The interviewer makes you draw out tables and has you join three tables so going over how to do that is a good prep for this interview.
The third interview was a formal in person interview. There were a few technical questions such as:
the role of triggers
what is a strong named assembly
There's also some whiteboard questions on how to normalize a database as well as writing a function to reverse a string without using any built in reverse functions .NET provides.
The final interview is with a project management type who asks you about previous projects you've worked on in the past. The woman looked at me with sort of this condescending gaze, as if I wasn't really qualified to do the work. I got really nervous and think I blew the interview here.
