Avanade interview questions

The interview process consisted of an info session, a phone interview, a group interview with whiteboard and one on one. This company is looking for people who are eager to learn and will very willing to travel. The interview had no “trick” questions and the overall process was very fair.

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.