Me postulé a través de una facultad o universidad. Acudí a una entrevista en S&P Global en dic 2011
Entrevista
My first interview consisted of a 30 minute written test which included queries to answer.
There was a C program to write to check if a string is palindrome or not. Be well prepared with joins in case of queries. They also asked to create an ER diagram of a database schema.
Me postulé a través de una facultad o universidad. El proceso tomó 4 semanas. Acudí a una entrevista en S&P Global (New York, NY) en oct 2015
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 1
Basic Database Question. Indexing, primary key, difference between all the keys, optimization
Me postulé a través de una facultad o universidad. El proceso tomó 4 semanas. Acudí a una entrevista en S&P Global (New York, NY) en mar 2015
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 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")
Me postulé en línea. El proceso tomó 3 semanas. Acudí a una entrevista en S&P Global en nov 2014
Entrevista
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.