S&P Capital IQ Interview Questions

Updated 20 Oct 2014
Updated 20 Oct 2014
235 Interview Reviews

Interview Experience

Interview Experience

57%
27%
14%

Getting an Interview

Getting an Interview

54%
28%
8%

Interview Difficulty

3.1
Average

Interview Difficulty

Hard

Average

Easy

Candidate Interview Reviews

Sort: Popular Date Difficulty
  1.  

    Software Developer Interview

    Anonymous Interview Candidate in Hyderābād (India)
    Anonymous Interview Candidate in Hyderābād (India)
    Application Details

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

    Interview Details

    i applied through recruitment process.they mentioned 4 profiles SE,DBA, quality analyst, business analyst. i applied for SE n DBA. first we had ap replacement talk, whch was worst, they dint even make a presentation.
    we had written test for each profile, followed by a GD, followed by three interviews, 2 tech n 1 HR. i cud mak till 1st interview round.
    writtten test was easy. it contained aptitude qsns, c, c++ questions, DBA part had some easy queries n query on date manipulation were bit hard.
    interview wasn't that gud.
    question were very random.
    how does google search engine work? imean when u type the search string what actually happens. i tried to explain him but in vain.
    about TCP IP from networks
    he asked me simple query whch i cud answer, but one of the interviewer (who cudn't even speak english properly) was constantly interupting me.
    mirrror image of binary tree, i answered it
    count no of leaf nodes in binary tree.
    a complex program was asked inn written test he asked me if i hav discussed it with my friends n asked me to re write the program. i cudnt write it, but cud explain my approach, but he inststed to write the code.

    Interview Questions
    • how does google search engine work? imean when u type the search string what actually happens. i tried to explain him but in vain.   Answer Question
    No Offer
    Negative Experience
    Difficult Interview
  2.  

    Junior Research Associate Interview

    Anonymous Interview Candidate
    Anonymous Interview Candidate
    Application Details

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

    Interview Details

    Started with a basic aptitude test, a small personal interview one on one..basic questions.Next round was another test with questions on financial knowledge, gk , case studies.
    then few more rounds of interviews.

    Interview Questions
    No Offer
    Positive Experience
    Average Interview
  3. 1 person found this helpful  

    Research Associate Interview

    Anonymous Interview Candidate in Gurgaon, Maharashtra (India)
    Anonymous Interview Candidate in Gurgaon, Maharashtra (India)
    Application Details

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

    Interview Details

    1st round-general aptitude round
    2nd round-HR interview
    3rd round-technical written test
    4th round-technical interview
    5th round-director interview

    Interview Questions
    • questions relating to mergers and acquisitions, economics, ratios, projects which i had done in college   Answer Question
    No Offer
    Negative Experience
    Average Interview
  4. Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review
  5.  

    Junior Research Associate Interview

    Anonymous Interview Candidate in Hyderābād (India)
    Anonymous Interview Candidate in Hyderābād (India)
    Application Details

    I applied through college or university. The process took a weekinterviewed at S&P Capital IQ in January 2014.

    Interview Details

    I gone through the written test and written test was as easy as simple test with forty questions in finance and ten questions in aptitude and ten questions in English and time given for me is one hour and i finished the test within half an hour.

    Interview Questions
    Declined Offer
    Negative Experience
    Easy Interview
  6.  

    Database Administrator (Release Manager) Interview

    Anonymous Interview Candidate in Delhi (India)
    Anonymous Interview Candidate in Delhi (India)
    Application Details

    I applied through a recruiter – interviewed at S&P Capital IQ in January 2014.

    Interview Details

    Interview Process for experienced-
    Step 1- Got call for interview and gone through 2 telephonic technical interview .After clearing two rounds i got call for In-Person interview.

    Step-2 Gone to Gurgaon.
    1) Written Test--For DBA there are four sections was mandatory.

    Section 1(SQL Query)-
    Based on Sql queries. There was 4 tables related with primary and foreign key. Based on that 3 questions ,you have to solve. It was of moderate level.

    Section 2(Data Modeling)--Total three questions
      Que 1- To Create index to fasten the search process based on 1st section tables.
      Que 2- Null values allowed for Primary and unique key.
      Que 3- Based on ER diagram.(Simple if you have revised)

    Section 3- General knowledge about system(Description Type --8 questions)
    Que 1- What is eventlog
    Que 2- What is Registry
    Que 3- Difference between Firewall and Antivirus
    Que 4- What is utf-8
    Que 5- What is difference between 32bit and 64 bit computer
    Que 6-Hot to install software on Linux
    Que 7- Based on Excel Sheet- 2 Snapshots. 1st snapshot -data was unorganized format ans 2nd snapshot was organised using Excel sheet. They asked for Excel property.
    Que 8- When do use virtual machines

    Section 4- DBA question(8-10 questions)
    Some based on RAID(1) , clustered index(2 que), underlying database processes(1), database backup(1).How to increase database agent memory(sp_reconfig)(1)

    others i don't remember.

    Then in last round Director level interview.
    2 Expert persons will ask question on your DBA level and release management.
    Some questions was like--tell me about yourself,daily challenges faced, what do you daily do, performance tuning ,high availability etc.

    This was the end of the process.
    They will call you in one or two weeks if selected.

    It was totally very pleasant experience and HR was very supporting in each phase.

    Interview Questions
    • Last round --Video conferencing.
      They will test your knowledge on every question.
        Answer Question
    No Offer
    Positive Experience
    Difficult Interview
  7. 2 people found this helpful  

    Research Associate Interview

    Anonymous Interview Candidate in Gurgaon, Haryana (India)
    Anonymous Interview Candidate in Gurgaon, Haryana (India)
    Application Details

    I applied online. The process took 2+ weeksinterviewed at S&P Capital IQ in December 2013.

    Interview Details

    The Capital IQ interview process has 5 steps – Every round is elimination round.

    1st step is an IQ test - written test (Math and Vocab – aptitude exam)

    2nd step is HR interview. Questions may include definitions of mergers and acquisitions and more finance/investment questions.

    3rd step: Technical exam written for 60 mins /90 mins (finance basics and merger and acquisitions)

    The above 3 rounds can happen on the same day. Atleast 2 rounds will happen in same day.

    If you clear the first 3 rounds. You would get call for the next round in 7-8 working days (max)

    4-5 rounds would be personal interview – Director Rounds.

    Interview Questions
    Accepted Offer
    Positive Experience
    Difficult Interview
  8. 1 person found this helpful  

    Software Engineer Interview

    Anonymous Interview Candidate in Hyderābād (India)
    Anonymous Interview Candidate in Hyderābād (India)
    Application Details

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

    Interview Details

    S&P Capital IQ typically hires from campuses.

    First round consists of a written test that test analytical, programming abilities and database knowledge. Database is the heart of the work here and hands-on knowledge is highly valued. Questions will be asked on Relevant work from the resume

    Interview Questions
    • How your term project will help in our business   View Answer
    Negotiation Details
    Through campus. No negotiation
    Accepted Offer
    Positive Experience
    Average Interview
  9.  

    Business Analyst Interview

    Anonymous Interview Candidate in Hyderābād (India)
    Anonymous Interview Candidate in Hyderābād (India)
    Application Details

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

    Interview Details

    Hiring and interview process was held for so many candidates at a time and the first round was an written test which are on the basics of finance and second round was personal interview round in which they mainly asked about detail explanation of financial ratios.

    Interview Questions
    • Explain CAPM in detail.This is followed by some related questions   Answer Question
    No Offer
    Positive Experience
    Difficult Interview
  10.  

    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
  11. 2 people found this helpful  

    Technology Quality Analyst Interview

    Anonymous Interview Candidate
    Anonymous Interview Candidate
    Interview Details

    I applied through their website and got a call for interviews at the Ggn office within a week. The first round was a simple written assessment of grammar, case studies and simple logic. The 2nd round was the HR round which was again very basic. The third round was a subjective written test on software testing. By the thord round 80% of the interviewees were eliminated. They got back to me within a week with the result of the 3rd round. I was called for the 4th round which was a technical round. Nothing too complicated but there were elements of stress testing. I think they're looking for you to be honest and up front. Final round was with the director which was just a general run through of my background and the prior stages of interviews.

    Interview Questions
    Accepted Offer

See What S&P Capital IQ Employees Are Saying

1 person found this helpful

 Current Senior Associate in Gurgaon, Haryana (India)

Pros: “You can work here at easy pace. Good Male-Female Ratio. Healthy Work Environment. It is a safe place to work for long years without many worries.” 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 who said that their interview experience was positive, neutral or negative.

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