I applied through college or university. The process took 4 weeks. I interviewed at S&P Global (New York, NY) in Mar 2015
Interview
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.
Interview questions [1]
Question 1
1. Design a scenario and normalize. (Realize anomalies and redundancies)
2. SQL queries (Aggregation, rank, etc.)
3. Database knowledge (Keys, Indexes, all questions included a "when do you do it or not do it")
I applied through college or university. The process took 4 weeks. I interviewed at S&P Global (New York, NY) in Oct 2015
Interview
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.
Interview questions [1]
Question 1
Basic Database Question. Indexing, primary key, difference between all the keys, optimization
I applied online. The process took 3 weeks. I interviewed at S&P Global in Nov 2014
Interview
Basic question about yourself and past experience. Very detail questions about your project in the resume and also the skills you mentioned in the resume. A phone interview is last for 20 mins.