S&P Capital IQ Database Engineer Interview Questions

Updated 5 Apr, 2015
9 Interview Reviews

Interview Experience

Interview Experience

88%
0%
11%

Getting an Interview

Getting an Interview

89%
10%

Interview Difficulty

3.2
Average

Interview Difficulty

Hard

Average

Easy

9 Candidate Interview Reviews Back to all Interviews

Sort: Popular Date Difficulty

 

Database Engineer Interview

Anonymous Interview Candidate in New York, NY (US)
Accepted Offer
Positive Experience
Average Interview
Accepted Offer
Positive Experience
Average Interview

Application

I applied through college or university. The process took 4+ weeksinterviewed at S&P Capital IQ (New York, NY (US)) in March 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. 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")
     
    Answer Question

Other Interview Reviews for S&P Capital IQ

  1.  

    Database Engineer Interview

    Anonymous Employee
    No Offer
    Positive Experience
    Average Interview
    No Offer
    Positive Experience
    Average Interview

    Application

    I applied through college or university. The process took 2 weeksinterviewed at S&P Capital IQ in October 2014.

    Interview

    The interview process was quite simple. I applied through my university''s job portal. My resume got shortlisted and I was asked to schedule an interview appointment.
    On the day of the interview, there were two tasks, one was a written test and second was the interview.

    Both the tasks were given a time on 30 minutes.

    The test was easy but lengthy. So make sure you manage the time well.
    The interview was mostly based on your SQL skillset. The interviewer gave a scenario and asked to design a database for it. And then the whole interview went around the same database design.

    Interview Questions

    • The questions were quite simple. But they expect you to provide with an optimal solution for the problem.   Answer Question
  2.  

    Database Engineer Interview

    Anonymous Employee in New York, NY (US)
    No Offer
    Negative Experience
    Average Interview
    No Offer
    Negative Experience
    Average Interview

    Application

    I applied through college or university. The process took 2+ monthsinterviewed at S&P Capital IQ (New York, NY (US)) in October 2014.

    Interview

    Horrible, Perplexing Interview Process...Not worth it !

    Met these people at the career fair and got a call for 1:1 on-campus interview. They also asked me to schedule a 30-min time-slot for my interview via. the college job board. A day before the interview, I got an email saying that the interview will instead be a 1 hour interview, consisting of a 30 min Test followed by a 30 min (discussion + behavioral) interview. Since I had classes all day long, I was the first person to interview at 9:00 a.m (my originally selected time slot).

    On the day of the interview, I arrived around 8:50 AM so that I could settle-in quick. But to my horror, I found the guy waiting outside for me. He told that I was actually supposed to come in at 8:30 a.m, contrary to what their email stated.

    I showed him the email chain but they told me that they can't do anything about it since they had their tickets booked at 5:30 p.m and would end up missing the train if they rescheduled me. So, basically I was given 5 mins to complete the test and discuss it with the interviewer.

    S&P Capital IQ has the same set of questions each year (for Interns as well as full-time). They are a mix of Database and Algorithm questions but they really don't care about the Algorithm ones.

    1) Draw an ER diagram for: People, Professionals and Companies ( Look up cracking the Code)

    2) Three SQL subqueries on a DB diagram about airports, passengers and flights.
        - Not Exists/ Exists, Group by, Having, Count(*) functional type of queries

    3) Function to check if a number is prime or composite

    4) Function that prints out all the prime numbers from 2 - 100.

    In reality, they only care about Q2. So, spend all your time on that before doing the rest.

    Coming back to my interview, I somehow managed to successfully complete the questions in 5 minutes and then I was asked questions about JOINS, Indexes in the 1:1 interview. Overall, I thought the interview went well and got a positive vibe from it.

    Two days later, I got an ambiguous email from the Campus recruiting team saying that they would like to continue the conversation on their Super Day and would get back to me in a few days with the final dates. Since this email didn't look right, I emailed them back asking if it was an invitation for their Super Day to which I got an affirmative reply.

    After torturing all the candidates from my college, who got an invite, for more than 6 weeks, I emailed them back asking for confirmation of the Super Day dates, since I had to schedule other interviews, which were going to probably conflict with S&P's self-assumed tentative dates. After a series of ignored emails, I had to seek out an acquaintance within S&P to get the HR to reply to my emails.

    AND to my inexplicable surprise, instead of a date, I ended up getting a reject along with everyone from my college, for all the positions. Upon sending her the earlier email chain to the HR, I was ignored and then told that they are pretty busy to handle my case because of their meetings.

    At the end of the day, they hesitantly called me and told that they do not have any more openings and the usual HR routine. Total waste of time as they're MS-SQL specific and I ended up wasting a month learning the subtle differences in the DBMS.

    Hope this helps !

    Interview Questions

    • 2) Three SQL subqueries on a DB diagram about airports, passengers and flights.   1 Answer
  3.  

    Database Engineer Interview

    Anonymous Interview Candidate in New York, NY (US)
    Accepted Offer
    Positive Experience
    Average Interview
    Accepted Offer
    Positive Experience
    Average Interview

    Application

    I applied through college or university. The process took 3 weeksinterviewed at S&P Capital IQ (New York, NY (US)) in March 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

    • 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)
       
      Answer Question

    Negotiation

    Internship, so no negotiation, but salary was very fair.

  4. Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review


  5.  

    Database Engineer Interview

    Anonymous Employee in New York, NY (US)
    No Offer
    Positive Experience
    Average Interview
    No Offer
    Positive Experience
    Average Interview

    Application

    I applied through college or university. The process took a dayinterviewed at S&P Capital IQ (New York, NY (US)) in February 2014.

    Interview

    I applied through our college website and got a call. First round was written test and then the personal interview. Written test was pretty much easy. First question was to design a schema. second was to write few queries for the given data. Third question was to write an algorithm to print the number of prime numbers between a given range

    Interview Questions

    • First question was to design a schema. second was to write few queries for the given data. Third question was to write an algorithm to print the number of prime numbers between a given range   Answer Question
  6. Helpful (3)  

    Database Engineer Interview

    Anonymous Interview Candidate
    Accepted Offer
    Positive Experience
    Average Interview
    Accepted Offer
    Positive Experience
    Average Interview

    Application

    I applied through college or university – interviewed at S&P Capital IQ in December 2011.

    Interview

    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.

    Interview Questions

    • Be prepared with sql queries.   1 Answer
  7. Helpful (3)  

    Database Engineer Interview

    Anonymous Interview Candidate
    Accepted Offer
    Positive Experience
    Average Interview
    Accepted Offer
    Positive Experience
    Average Interview

    Application

    I applied through college or university. The process took 3 weeksinterviewed at S&P Capital IQ in November 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

    • Why do you want this position? Why do you want to work for CIQ?   1 Answer
  8.  

    Database Engineer Interview

    Anonymous Interview Candidate in New York, NY (US)
    Accepted Offer
    Positive Experience
    Difficult Interview
    Accepted Offer
    Positive Experience
    Difficult Interview

    Application

    I applied online. The process took a dayinterviewed at S&P Capital IQ (New York, NY (US)) in November 2011.

    Interview

    There was a half hour phone interview which was technical. After being cleared in it, I was invited to the location for a personal interview which consisted of a technical written test which was moderately difficult after which I met with three super smart people who grilled me on the test answers and my technical know how.

    Interview Questions

    • Why did I choose certain index design for the tables in the test.   1 Answer
  9.  

    Database Engineer Interview

    Anonymous Employee
    No Offer
    Positive Experience
    Difficult Interview
    No Offer
    Positive Experience
    Difficult Interview

    Application

    I applied through college or university. The process took a dayinterviewed at S&P Capital IQ in February 2011.

    Interview

    Presented with a 30-page skills assessment. First exercise was on database design. Second exercise was an algorithm problem using your language of choice. Third exercise was writing out complicated SQL queries.

    Interview Questions

Work at S&P Capital IQ? Share Your Experiences

S&P Capital IQ

 
Click to Rate
or

The difficulty rating is the average interview difficulty rating across all interview candidates.

The interview experience is the percentage of all interview candidates who said that their interview experience was positive, neutral or negative.

Your response will be removed from the review – this cannot be undone.