The process took 1+ week. I interviewed at S&P Global (New York, NY) in May 2012
Interview
I submitted my resume on our University job Postings and received a call for a telephonic interview after 2 weeks. Telephonic interview was for about 30 to 40 minutes. He asked me about myself, my past experience and some Database questions (about Indexes). Then within a week I was called onsite for 1:1 interviews. There where 3, 1 hour technical interviews. They told me to design some databases on white board and write some queries. All the 3 interviews went well. I got a call from HR next day morning, that I was offered the position.
Interview questions [1]
Question 1
Design a database...Will you use index, on what columns, why? Write queries ()complex queries with 'exists' and 'non exists' clause.
I applied through university. The process took 2 weeks. I interviewed at S&P Global (New York, NY) in Feb 2012
Interview
Finish paper test first. Then talk with the interviewee about the questions on the paper.
There are five questions:
invert a linked list
Database Design
find a common parent of two nodes in the tree
The process took 1 day. I interviewed at S&P Global (New York, NY) in Nov 2010
Interview
The process was fine, seems like a great company. 3 interviews back to back with lunch in between. Young people, asked reasonable questions, and were nice about it.
Interview questions [1]
Question 1
Create a sample database (table structure) of a basic version of imdb.com. Find the total sum of money that movies made with Mel Gibson as an actor that were released during the third week of February.