S&P Capital IQ
S&P Capital IQ Interview Questions & Reviews
Getting an Interview
- Popular Job Titles:
- Research Associate (48)
- Software Engineer (25)
- Business Analyst (20)
- Product Consultant (13)
- Client Development Analyst (13)
- Technology Quality Analyst (7)
- Tech QA (6)
- Junior Research Associate (6)
- Analyst (5)
- Intern (5)
- Database Developer (4)
- Database Engineer (4)
- JRA (3)
- Software Developer (3)
- Senior Research Associate (2)
- Quality Analyst (2)
- Database Administrator (2)
- Database Engineer Intern (2)
- TQA (2)
- Client Development (2)
- Global Product Development (Client Services/Account Manager) (1)
- Database Analyst (1)
- Consultant (1)
- Reaseach Associate (1)
- Software Deceloper (1)
- Contract/Freelance Designer (1)
- Associate Financial Modeling Group (1)
- Software Engineer Summer Intern (1)
- Summer Software Developer Intern (1)
- Financial Research Analyst - China (1)
Quantitative Consultant Interview (Positive Experience; Difficult Interview)
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
Industry Analyst Interview (Positive Experience; Average Interview)
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
Very Easy Interview
Database Engineer Intern Interview (Positive Experience; Very Easy Interview)
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
Client Development Interview (Positive Experience; Easy Interview)
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
Software Engineer Interview (Neutral Experience; Easy Interview)
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.
Software Engineer Interview (Positive Experience; Average Interview)
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
Product Consultant Interview (Neutral Experience)
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.
Software Engineer Intern Interview (Positive Experience; Average Interview)
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.
Intern Interview (Neutral Experience; Average Interview)
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
- 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
Database Engineer Interview (Positive Experience; Average Interview)
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
Interviews for Top Jobs at S&P Capital IQ