I had three interviews: a phone interview, a Skype interview, and an on-site interview.

The phone interview lasted for an hour and included questions on topics such as indexes, stored procedure performance, SQL injection, and one SQL query using GROUP BY. I was also asked to write a program to reverse a string.

The second interview, conducted via Skype, was also an hour long and was completely based on my resume. Questions covered technologies I had worked on, including Entity Framework, WCF (differences between SOAP and REST, and bindings), and the difference between PHP and C#. I also had to code a very simple program.

The third interview was on-site and lasted for three hours. The first two hours involved coding on a whiteboard. The questions were:

1. Given the array {-5, 6, 7, 8, -6, -4}, arrange it so that negative numbers are on the left and positive numbers are on the right, without sorting. The expected output is {-5, -6, -4, 6, 7, 8}.
2. Given a vector of vectors {{'one', 'two', 'three'}, {'four', 'five'}, {'six', 'seven'}}, print all Cartesian products, such as {'one', 'four', 'six'} and {'one', 'five', 'seven'}, and so on.
3. Given an input like [ ]{( )}, check if the parentheses are balanced.

The last hour was an interview with the director, who asked some math/computer questions, such as finding a missing number, and other high-level design questions. These did not have right or wrong answers but were intended to assess my knowledge.

Overall, it was a good experience. I did not get the job, but all the interviewers were nice.

I had been expecting a lot of SQL questions and query writing, as the position was SQL-based, but they did not ask even one SQL question.

No SQL questions.