S&P Capital IQ

  www.spcapitaliq.com
Work in HR? Unlock Free Profile

S&P Capital IQ Interview Questions & Reviews

Updated Jul 19, 2014
All Interviews Received Offers

Getting an Interview  

48%
31%
10%

Interview Experience  

78%
10%
10%

Interview Difficulty  

Average Difficulty
88 candidate interviews Back to all interview questions
Relevance Date Difficulty
in

Accepted Offer

Positive Experience

Difficult Interview

Quantitative Consultant Interview

Quantitative Consultant
New York, NY

I applied online and the process took 2 months - interviewed at S&P Capital IQ in May 2014.

Interview Details – Was contacted by recruiter, had a phone interview with hiring manager. Was called for an onsite interview in New York with four team members. good experience overall, everyone was really nice. Recruiter was very helpful throughout and got feedback.

Interview Question – Technical interview followed my small talk and behavioral questions.   Answer Question


Accepted Offer

Positive Experience

Average Interview

Industry Analyst Interview

Industry Analyst
New York, NY

I applied online and the process took 3 weeks - interviewed at S&P Capital IQ in July 2010.

Interview Details – A 1-day written exam, doing analysis on a company and writing a short stock report. They provide an industry survey, economic data, and most recent 10-Ks and 10-Qs. After passing the exam, the candidate goes through a series of interviews, usually 4 or 5 interviewers. The offer is usually given in 2 weeks.

Interview Question – Can you cover 30 companies?   Answer Question


Accepted Offer

Positive Experience

Very Easy Interview

Database Engineer Intern Interview

Database Engineer Intern
New York, NY

I applied through college or university and the process took 6 weeks - interviewed 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 Question – 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


Declined Offer

Positive Experience

Easy Interview

Client Development Interview

Client Development

I applied through a recruiter and the process took 1+ week - interviewed at S&P Capital IQ in November 2009.

Interview Details – Went in for a client development associate position in los angeles, met with senior associate and director separately who interviewed me pretty casually. wanted to know about my background as an analyst for a private equity fund, and then we discussed the role, the hours, the composition of the team.

Interview Question – There really wasn't one. Just was more of a conversation about my skillset and what clients were looking for in an associate.   Answer Question


Accepted Offer

Neutral Experience

Easy Interview

Software Engineer Interview

Software Engineer
New York, NY

I applied through college or university and 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 Question – -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.


1 person found this helpful

Accepted Offer

Positive Experience

Average Interview

Software Engineer Interview

Software Engineer
New York, NY

I applied in-person and the process took 1 week - interviewed at S&P Capital IQ.

Interview Details – This varies depending on the level - be prepared to answer core questions about Microsoft tools like C# and SQL Server

Solid knowledge of OO design principles is important and try to be concise as some interviewers will write you off if you keep jabbering.

I did not come across any general knowledge or other non technical questions but it is recommended that you brush up on what's happening in the industry to show that you are motivated.

Interview Question – None   Answer Question

Negotiation Details – Not much. I liked their offer


Accepted Offer

Neutral Experience

Product Consultant Interview

Product Consultant

I applied through college or university and the process took 3 weeks - interviewed at S&P Capital IQ.

Interview Details – The first round interview was on campus following a school career fair and resume drop. Next was a super day at the company's New York Ciy headquarters. All of the questions were very easy. They were mostly about your background and experience. Nothing to worry about at all. Emphasize a passion for finance and helping others, and you'll be fine.

Interview Question – Walk me through your resume. Tell me about a time you exhibited _____?   Answer Question

Negotiation Details – No negotiation.


Accepted Offer

Positive Experience

Average Interview

Software Engineer Intern Interview

Software Engineer Intern
New York, NY

I applied online and the process took 2 weeks - interviewed at S&P Capital IQ in April 2013.

Interview Details – I was called for a screening interview first which just asked about me and my resume. If they like you, you will to the next round with more phone interviews. Had three interviews for three separate teams engineer teams all working on different projects. I got the offer the same day as i interviewed for all three teams. Offer was for my choice of any of the teams so i chose the best one for me.

Interview Question – Honestly, weren't too technical. No specific coding questions as i guess they trust that you can do what they want.   Answer Question

Negotiation Details – No negotiation. Just take it. 28$ an hour.


Accepted Offer

Neutral Experience

Average Interview

Intern Interview

Intern
New York, NY

I applied online and the process took 4+ weeks - interviewed at S&P Capital IQ in April 2013.

Interview Details – Applied online, had two phone screens and an onsite interview

Interview Questions

  • There was one question on designing a class/set of classes which help to find the stock quote for a particular company. A method was provided which takes a sticker(String) as an input and gives the stock value(double). But this method was too expensive to call, so how would you optimize your solution(make the minimal number of calls to this method). Also the stock value returned should not be more than an hour old. There were subparts to this question, on caching the values and multithreading.   Answer Question
  • Given a tree and a value n, check if the sum of values on any path of the tree from root to a leaf equals to that value.   Answer Question


3 people found this helpful

Accepted Offer

Positive Experience

Average Interview

Database Engineer Interview

Database Engineer

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

Interview Details – 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 Question – Be prepared with sql queries.   View Answer

Worked for S&P Capital IQ? Contribute to the Community!

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.