I applied through university. The process took 3 weeks. I interviewed at S&P Global in Nov 2011
Interview
CIQ came to campus for a career fair and that's where I met the employees and really liked what they had to say. I made sure I talked to them enough so they would remember me. I sent my resume and got notified for a campus interview. The day before, they hosted an information session and I attended that as well, just to speak to the person who would interview me in a more informal setting. When it was time for the interview, I first took a written skills test with some basic questions on database design, a small coding question (they didn't care which language), and some sql queries. Next, I had a 1:1 interview with one of the employees. We went through the test and discussed my answers. The thought process was more emphasized than having the right answers. They don't expect all candidates to be completely versed in db's. I was then asked why I wanted the position etc.
A few days later, I was told that I had made it to the next round - the super day interview. It was scheduled for 2 weeks later and I was flown to NYC. The S&P building is very impressive. The candidates all gathered in a room and had pizza with the employees - just an informal session to ask any questions. I liked that touch because it was welcoming. The atmosphere seems relaxed and facilitates a collaborative environment. Also, most of the employees are young which probably means there are some great ideas flowing through the office. Next, I had three 1:1 interviews with members of the DB team. I had to show how I would design a certain database on the whiteboard. Each time a new interviewer came in and the other left. a new component was added and I was asked to figure out how to implement it. It was fairly straight forward and I learned a lot of design concepts just during the interviews when the employees corrected my logic or showed me something when I was uncertain. All of them seemed to look for my interest in databases, and an interest in learning more. Each asked if I had questions, so come with questions.
About two and a half weeks later, I received an email with an offer letter attached!
Interview questions [1]
Question 1
Why do you want this position? Why do you want to work for CIQ?
I applied through 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 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.