I had 3 interviews. phone, skype, and on-site.
Phone interview was for an hour, questions like index,
stored procedure on performance, sql injection, and one sql query using group by
and write a program to reverse a string.
second interview on skype was for an hour,
was completely based on my resume. Technologies I have worked on
like entity framework, wcf, difference between soap and rest. Binding on wcf.
difference between php and c#. And a very simple program to code.
Third interview was on-site which was for 3 hours.
First two hour was all coding on white board. Questions are
1. Given array {-5, 6, 7, 8, -6, -4} arrange the array so that negative number on left side
and positive number on right side, but do not sort. So, output is {-5, -6, -4, 6, 7, 8}
2. Given a vector {{'one', 'two', 'three'}, {'four', 'five'}, {'six', 'seven'}
print: {'one', 'four', 'six'}, {'one', 'five', 'seven'}..so on...basically all cartesian products.
3. Given the input like [ ]{( )}, check if the parenthese is balanced or no.
Last one hour interview was with director he asked some maths/computer question like
finding a missing number.
And other high level design questions, which did not have any right/wrong answers. Just to
understand my knowledge.
Overall it was a good experience. I did not get the job but the all the interviewers were nice.
I was expecting a lot of sql questions and writing queries, since the position was based on sql.
But they did not ask even one sql question.