I applied through college or university. The process took 3 weeks. I interviewed at S&P Global (New York, NY) in Mar 2014
Interview
Two rounds of interviews. The first was a 1:1 on campus and involved a written test prior to speaking with the interviewer. The test was 3 questions, two involving database design and a third relating to algorithms. With some basic SQL knowledge, the first two were fairly straightforward. The third was a little more challenging because it was a very specific question and involved some Computer Science knowledge. The interviewer was extremely friendly and very helpful when I didn't know something. I didn't even finish the test, which wasn't a problem.
The second round was on site and had three different groups (2 were 1:1 and the other had 2 interviewers). Same level of difficulty with questions, just more intense. Everyone was very professional and helpful, not as intimidating as I'd expected. Overall, good experience.
Interview questions [1]
Question 1
How would you find all prime numbers less than or equal to some number n?
Design a database for a set of airlines, airports, and passengers. (And a few subsequent questions relating to your design)
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 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 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.