Getting an Interview
Getting an Interview
Interviews for Top Jobs at S&P Capital IQ
- Research Associate (65)
- Software Engineer (31)
- Business Analyst (23)
- Product Consultant (14)
- Client Development Analyst (13)
- Database Engineer (9)
- Junior Research Associate (8)
- Intern (7)
- Technology Quality Analyst (7)
- Tech QA (6)
- Analyst (6)
- Quality Analyst (5)
- Database Developer (4)
- Software Developer (4)
- TQA (3)
- JRA (3)
- Database Engineer Intern (2)
- Senior Research Associate (2)
- Client Development (2)
- Database Administrator (2)
- Database Analyst (1)
- Consultant (1)
- Quality Assurance Engineer (1)
- Reaseach Associate (1)
- Senior Database Engineer (1)
- Financial Sales (1)
- Sales Representative (1)
- Data Analyst (1)
- Customer Support (1)
- Engineering (1)
Helpful (4)Accepted OfferAccepted Offer
I applied through college or university. The process took 3 weeks – interviewed at S&P Capital IQ.
Step 1:General Aptitude Test where we had to write an SOP
Step 2:An HR/Technical Based interview, which lasted for hardly 5 minutes
Step 3:A Content test containing questions based on logic, analysis and Finance
Step 4: Managerial Interview
- HR based interview had technical questions Answer Question
Helpful (3)No OfferNegative ExperienceDifficult InterviewNo OfferNegative ExperienceDifficult Interview
I applied through college or university – interviewed at S&P Capital IQ (Noida).
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.
- Nothing out of the blue. Answer Question
- No OfferNegative ExperienceDifficult InterviewNo OfferNegative ExperienceDifficult Interview
I applied through college or university. The process took 2 days – interviewed at S&P Capital IQ (Hyderābād).
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.
- 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 OfferPositive ExperienceAverage InterviewNo OfferPositive ExperienceAverage Interview
I applied through college or university – interviewed at S&P Capital IQ.
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.
- nothing as such Answer Question
Helpful (1)No OfferNegative ExperienceAverage InterviewNo OfferNegative ExperienceAverage Interview
I applied through college or university. The process took 4+ weeks – interviewed at S&P Capital IQ (Gurgaon, Maharashtra).
1st round-general aptitude round
2nd round-HR interview
3rd round-technical written test
4th round-technical interview
5th round-director interview
- questions relating to mergers and acquisitions, economics, ratios, projects which i had done in college Answer Question
Helpful (1)No OfferPositive ExperienceDifficult InterviewNo OfferPositive ExperienceDifficult Interview
I applied through a recruiter – interviewed at S&P Capital IQ (Delhi) in January 2014.
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.
- Last round --Video conferencing.
They will test your knowledge on every question. Answer Question
- Last round --Video conferencing.
- Declined OfferNegative ExperienceEasy InterviewDeclined OfferNegative ExperienceEasy Interview
I applied through college or university. The process took a week – interviewed at S&P Capital IQ (Hyderābād) in January 2014.
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.
- Easy Answer Question
Helpful (2)Accepted OfferPositive ExperienceDifficult InterviewAccepted OfferPositive ExperienceDifficult Interview
I applied online. The process took 2+ weeks – interviewed at S&P Capital IQ (Gurgaon, Haryana) in December 2013.
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.
- tell me about yourself in one minute Answer Question
Helpful (1)Accepted OfferPositive ExperienceAverage InterviewAccepted OfferPositive ExperienceAverage Interview
I applied through college or university. The process took a day – interviewed at S&P Capital IQ (Hyderābād).
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
- How your term project will help in our business 1 Answer
Through campus. No negotiation
- No OfferPositive ExperienceDifficult InterviewNo OfferPositive ExperienceDifficult Interview
I applied through college or university. The process took 4+ weeks – interviewed at S&P Capital IQ (Hyderābād).
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.
- Explain CAPM in detail.This is followed by some related questions Answer Question
Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review