I applied through a staffing agency. The process took 1 week. I interviewed at CGI (Chennai)
Interview
The interviewer was friendly and patient. There were practical questions on the projects I had worked on recently. There were very few textbook questions, which means you would be able to answer only if you had actually worked on that area.
The 1:1 interview was followed up with a HR round both of which I cleared on the same day.
This was followed with a group panel interview which was telephonic. It was relatively on the same lines as that of the 1st round. Practical yet requires experience to answer. Overall a positive experience.
Interview questions [1]
Question 1
Indexes in SQL server, their types and how it works. Where is each type of index used and how do you analyse it.