The interview was help in campus. Interviewer was good and friendly. Questions were pretty basic. My experience was negative as they selected me for the final interview round to be held at S&P office but after months of follow up, they said I have been rejected (without even going through an interview). They never provided any reason explaining it.

I met a recruiter at the school Career Fair and handed him my resume. Then applied online. Day 3, I got a call that my resume is picked for first rounds of interview on School campus. Day 9, First rounds: There was a written test, and discussion with two recruiters following it. The exam tests on database design, sql queries and basic algorithm skill. I couldn't complete the test on time (we were given only 20 minutes). The interviewers discussed the exam content and helped solving the queries that I did not. They were looking for approach. Day 16, I got a call for final rounds at office, NY Day 22: There was a reception with "one employee per every intern candidate" and had very good opportunity to network with all. There were details given and ice-breaker events Day 23: There were three rounds of interview(1, 2 and 1 interviewers in each round). All four of them were super cool and helpful. I was even provided manuals for a function I was supposed to use in solving a query. Again, they tested skills on design, knowledge of databases, and Querying Day 26: I got a call from HR that I got selected. Friday was interview and they updated selection on Monday. It was amazingly quick.