S&P Capital IQ Interview Questions

Updated Oct 20, 2014
Updated Oct 20, 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 Engineer Interview

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

    I applied through a recruiter. The process took 4+ weeksinterviewed at S&P Capital IQ in September 2013.

    Interview Details

    Hiring Process:
    I got a call from Talent Acquisition Team.

    They give me an overview about the company & about my role & responsibilities

    Interview Process:

    It took around 5-6 weeks & I gone through 5 technical interviews , 4 telephonic & 1 was face to face.

    Telephonic round covers your basic Knowledge on your domain.Mine was for a Data Scientist,so they asked about Data Models & Extraction Techniques.Make sure to go through SQL.

    Most questions were from my domain.

    Face to Face was the most interesting & challenging one.They gave me a Complex Problem & asked me to design a Proof of Concept(POC) on it.
    It was a good healthy discussion on various real World Problems of Data Mining.The entire discussion was around an hour.

    Interview Questions
    • How would you implement Business Sense Identification in a Financial Document   View Answer
    Negotiation Details
    S&P is a good brand in terms of pay-scale.Usually you don't have the need to negotiate.They pay you what you ask..but not all in hand...get ready for some bonus stuff too...:)
    Accepted Offer
    Positive Experience
    Difficult Interview
  2.  

    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
  3.  

    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
  4. Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review
  5.  

    Research Associate Interview

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

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

    Interview Details

    Applied through campus hiring process. The first step was the aptitude test which was too easy but they eliminated people on the basis of statement of purpose that was another hidden section in the information about the employee.

    The next step was the hr interview which was nothing but confidence testing round lasting for 3-5 minutes.

    The third stage is the technical test where purely finance and logical questions are asked.

    The fourth one is the final managers interview where the person is just tested on his convincing skill to do a boring job. Prepare for that.

    Interview Questions
    No Offer
    Negative Experience
    Difficult Interview
  6. 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
  7.  

    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
  8.  

    Research Associate Interview

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

    I applied through an employee referral. The process took 2 daysinterviewed at S&P Capital IQ in August 2010.

    Interview Details

    Hiring process is not that easy. It involves 5-6 rounds of interview here a candidate is judged on everything starting from Aptitude to the Attitude towards career progression, and towards the company. Hiring process involves One to One with the HR, followed by two written exams, and then the two rounds of interview with Operations Manager and the Group Director respectively.

    Interview Questions
    • Most difficult would be the aptitude test and one more written exam as it has lot of business awareness questions.   Answer Question
    Negotiation Details
    This was my first job
    Accepted Offer
    Positive Experience
    Difficult Interview
  9.  

    Quantitative Consultant Interview

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

    I applied online. The process took 2+ monthsinterviewed 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 Questions
    • Technical interview followed my small talk and behavioral questions.   Answer Question
    Accepted Offer
    Positive Experience
    Difficult Interview
  10.  

    Research Associate Interview

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

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

    Interview Details

    Their process is well organized and HR is very efficient. Their 1st round is an apti followed by HR round then a subjective written test then a technical or Managers round followed by a directors round.

    Interview Questions
    Accepted Offer
    Positive Experience
    Difficult Interview
  11.  

    Research Associate Interview

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

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

    Interview Details

    i applied through college placement cell. The recruitment process was held at their Gurgaon office. First there was a very easy objective Written test, followed by a very short HR interview. Selected candidates were called for 2 technical interviews.

    Interview Questions
    No Offer
    Neutral Experience
    Difficult Interview

See What S&P Capital IQ Employees Are Saying

 Former Senior Sales Associate in New York, NY

Pros: “Great co-workers and a fun working environment. Products are ones that clients need and see the value in. 401k match is good.” 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.