Getting an Interview
Getting an Interview
Interviews for Top Jobs at S&P Capital IQ
- Research Associate (69)
- Software Engineer (33)
- Business Analyst (23)
- Product Consultant (14)
- Client Development Analyst (13)
- Junior Research Associate (10)
- Database Engineer (10)
- Technology Quality Analyst (8)
- Intern (8)
- Analyst (6)
- Quality Analyst (6)
- Tech QA (6)
- JRA (4)
- Database Developer (4)
- Software Developer (4)
- TQA (3)
- Database Engineer Intern (2)
- Management Trainee (2)
- Senior Manager (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)
Database Engineer Intern Interview
I applied through college or university. The process took 6 weeks – interviewed at S&P Capital IQ (New York, NY) in March 2014.
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!!
- 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. 1 Answer