S&P Capital IQ

  www.spcapitaliq.com
  www.spcapitaliq.com

S&P Capital IQ Interview Questions

Updated Dec 12, 2014
Updated Dec 12, 2014
239 Interview Reviews

Interview Experience

Interview Experience

58%
27%
14%

Getting an Interview

Getting an Interview

55%
28%
8%

Interview Difficulty

3.1
Average

Interview Difficulty

Hard

Average

Easy

Candidate Interview Reviews

Sort: Popular Date Difficulty
  1. 2 people found this helpful  

    Database Engineer Intern Interview

    Anonymous Interview Candidate in New York, NY
    Anonymous Interview Candidate in New York, NY
    Application Details

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

    Interview Details

    I applied through my university's CareerNet website. I was called for an On-Campus Interview. The interview lasted for an hour. First, I had to appear for a 30 minute test, which included 3 questions. First question was to draw an E-R diagram from the given information. Second question was to solve SQL queries. Third question tests your basic programming skills, few basic programs like prime number, palindrome etc.

    A week later, I got an e-mail informing me that I cleared the first round of interview and was invited for the final round of interviews on-site. The final round of interviews lasted for 2 hours and 15 minutes. There were 3 interviews one after the other each of 45 mins.

    The on-site interview started at 12:30. The 1st interviewer gave a data model and asked some basic SQL queries on that. He also asked about indexing. The 2nd interviewer presented me with a scenario and asked to design a data model. The 3rd interview was conducted by 2 people. They gave me a data model and asked some set operation based SQL queries. My interview ended at 2:45. The HR gave us a tour of the office after the interview.

    Along with technical they even asked me about the project work, experience etc. So be ready for resume based questions too.

    I got a call from the HR after 2 weeks to inform me that I was selected.

    Overall, it was a good experience. Concentrate more on data modelling and SQL queries. Try solving as many queries as you can. Practice well.

    The Interviewers are warm and polite. They help you if you are stuck or give you hints so that you get an idea of the question and can think in the right way.

    Even if you go wrong, it is completely fine, what matters is your approach towards the question, your problem solving skills etc.

    All the best!!

    Interview Questions
    • I wasn't asked a difficult question but I wasn't much prepared with set operation based queries. So I had tough time answering them.   View Answer
    Accepted Offer
    Positive Experience
    Easy Interview
  2.  

    Summer Software Developer Intern Interview

    Anonymous Interview Candidate in New York, NY
    Anonymous Interview Candidate in New York, NY
    Application Details

    I applied online. The process took 6+ monthsinterviewed at S&P Capital IQ in March 2014.

    Interview Details

    The application was online and it took about about 6 months before I got an email to schedule a telephonic interview. Because it took so long, I had actually forgotten I had applied to this position. The manager who called me was a great conversationalist and asked great questions but was not knowledgeable about programming subjects.

    Interview Questions
    • What do you know about S&P Capital IQ?
      Explain in detail the process of software development.
       
      Answer Question
    No Offer
    Neutral Experience
    Average Interview
  3.  

    Database Engineer Interview

    Anonymous Interview Candidate in New York, NY
    Anonymous Interview Candidate in New York, NY
    Application Details

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

    Interview Details

    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 Details
    Internship, so no negotiation, but salary was very fair.
    Accepted Offer
    Positive Experience
    Average Interview
  4. Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review


  5.  

    Product Consultant Interview

    Anonymous Interview Candidate in Washington, DC
    Anonymous Interview Candidate in Washington, DC
    Application Details

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

    Interview Details

    I applied through a campus recruiter. The process took three weeks, and I was interviewed by two people, a product consultant and a account manager. The interviewers were very straight forward about the position description, the hiring process, and the company culture. Most of the interview was spent discussing my major and qualifications, and there were very few behavioral questions.

    Interview Questions
    • I do not come from a finance background, so the interviewers really grilled me on how my background fit into the job position.   Answer Question
    No Offer
    Positive Experience
    Difficult Interview
  6.  

    Product Consultant Interview

    Anonymous Interview Candidate in Atlanta, GA
    Anonymous Interview Candidate in Atlanta, GA
    Application Details

    I applied through college or university. The process took 1+ weekinterviewed at S&P Capital IQ in February 2014.

    Interview Details

    First contact was at career fair. That lead to first interview on campus. Second interview was downtown. Third interview is in New York.

    Interview Questions
    No Offer
    Neutral Experience
    Average Interview
  7.  

    Business Analyst Interview

    Anonymous Interview Candidate
    Anonymous Interview Candidate
    Application Details

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

    Interview Details

    Got interview through on-campus recruiting. There was a 30 min pre-interview technology test. Afterwards, a behavioral interview where the recruiter discusses the results from the test and asks questions about your approach. There were plenty of questions about why you chose a certain design and other human-computer interaction questions. Finally, the recruiter gives a general overview of the position and responsibilities. Very informal one-on-one talk.

    Interview Questions
    • Why wouldn't you want to sort queries based on popularity if you worked at S&P?   Answer Question
    No Offer
    Positive Experience
    Average Interview
  8.  

    Software Engineer Interview

    Anonymous Interview Candidate in New York, NY
    Anonymous Interview Candidate in New York, NY
    Application Details

    I applied through college or university. The process took 4+ weeksinterviewed at S&P Capital IQ.

    Interview Details

    On-Campus: Written test followed by a follow-up in person interview.
    On-site:
    3 back to back technical interviews, 40-45 minutes each.
    Questions:
    1. Design "Undo" and "Redo" feature for a text editor.
    2. Given an integer array, return "1" if sum of any two numbers is zero.
    3. Use two dice to create a random number generator (0-15).
    4. What is a Race Condition?
    5. Given a continuous stream of characters, find the first non-repeating character.

    Interview Questions
    No Offer
    Positive Experience
    Difficult Interview
  9.  

    Product Consultant Interview

    Anonymous Interview Candidate
    Anonymous Interview Candidate
    Interview Details

    Applied through on-campus recruiting. Standard interview questions.

    Interview Questions
    • Describe a time where you had to use your persuasion skills to change someone's mind.   Answer Question
    No Offer
  10.  

    Software Engineer Interview

    Anonymous Interview Candidate in New York, NY
    Anonymous Interview Candidate in New York, NY
    Application Details

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

    Interview Details

    Had an on campus interview. Took 30 minutes paper test and then went through all the questions with the interviewer. Some follow-up questions from the interviewers are not easy compare to the written test.

    Interview Questions
    • Binary tree path sum
      find a linkedlist's nth to last node
      Cache design
      DB design
      count the number of bits in a char
       
      Answer Question
    No Offer
    Positive Experience
    Easy Interview
  11.  

    Software Engineer Interview

    Anonymous Interview Candidate in New York, NY
    Anonymous Interview Candidate in New York, NY
    Application Details

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

    Interview Details

    I applied through my university's career web site before 2009, and was contacted for the first round interview.

    First round - Two technical interviews with software engineers. We were given a paper test with 5 questions that have been stated close to verbatim in previous reviews (find closest common parent of two nodes, reverse a linked list, count # of bits in a byte, db schema, cache design). The interviews are essentially a review of that paper test, and you may be asked to answer a slightly-modified version on one of the questions.

    Final round - Two technical interviews and one HR interview. Both of the interviewers were senior engineers, and they asked different types of programming questions that are more or less on par with the paper test in the first round. The HR interview was very relaxed.

    During the process, you eat lunch with other employees (with no connection to the interviewers) and may ask questions. My process was quick; I was contacted the day of the first round interview for the final round invite, and I was contacted a week after the final round with an offer and accepted.

    Interview Questions
    • -Finding the lowest common parent of two nodes can be tricky
      -Detecting a palindrome (this was asked to nearly every candidate when I was applying)
       
      Answer Question
    Negotiation Details
    Was able to push back start-time, and slightly change the compensation.
    Accepted Offer
    Easy Interview

See What S&P Capital IQ Employees Are Saying

 Current Client Development Associate in Chicago, IL

Pros: “The people in the office are excited to come to work. We are having a record year in 2014, and us younger team members feel we have great leaders and mentors.” Full Review

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 that said their interview experience was positive, neutral, or negative.

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