Monday, October 1, 2012

CIQ

Experience at Capital IQ:

Capital IQ was the 2 company to visit the campus after Commvault which left disappointment for all of us.
          The process started off with a written round consisting of 4 sections each for the posts of SE,DBA,BA and QA.We were asked to give 2 preferences for the above posts.Most of us went with SE/DBA.Looking at the paper  we were tensed initially as it was a very huge one..I somehow recalled my intermediate competitive exams where I had to solve many questions in a time limit..slowly got used to the paper.The questions were really good.SE section had about 3 to 4 codes and the DBA section had about 4 queries based on the tables.(moderate level).
After this,some of us(donn remember the number) were shortlisted for the GD that was scheduled immediately.This happened to be good and most of us cleared this.It was now followed by the interviews.

As per my preference I was interviewed by an SE panel.He spoke a lot and my interview was for about 1 hr 15 min.He asked me almost all concepts coding(with minimum complexity),DB queries and then OS what not he tried covering all the concepts.I somehow felt he was impressed,but to my surprise after an hr when it was about late 9(when I was ready to leave home) they said that I have an other interview for the DBA panel!I almost lost my hopes now.
                The DBA guys were very friendly and asked me some concepts and queries on DBMS.
This interview was just for about 30 min.Even they could understand my situation(as I looked very tired).He then concluded with some OS questions.
             Immediately I was told that I was shortlisted for the DBA post and my further interviews would be at the Capital IQ office.I was very happy(unexpected this time).Almost 11 of us were shortlisted(including the 4 posts) and were asked to come to the company for interviews within a week's time.

At Capital IQ:

The environment there seemed to be very friendly.All 11 of us were asked to wait in a conference room.After some time came my turn.And my interviewer oh my god!!He is so friendly!!
He started off with my achievements and then it went to my internship project.My project involved more of databases and thus he asked me to design the DB schema for my project.He tried changing my schema to the real time situations.He asked me to write some queries(like triggers) based on my schema.He gave me certain cases and asked me how I would solve them for real time applications.He later asked some DB concepts.He seemed very cool,I now somehow felt I impressed him!!!!
And this time I really did!And to my surprise he was the DBA head!!!!
After every one got interviewd they said 3 of us were shortlisted for the next round!!out of the 3,I was the only one for DBA.I had mixed feelings.I finished off my interview(first interview) at about 1(followed by a sumptuous lunch) and then I almost waited till 7,but I was not called for the next interview!!!To my surprise I was informed that I got selected after the 1 interview at Capital IQ itself!!!My joy now had no bounds!!!!!