The interview process was divided into various levels.
1) The first level was the resume shortlisting, in which, out of 500 eligible candidates, 160 were shortlisted, based on percentage at various educational levels.
2) Following that was an aptitude test, conducted by AMCAT, consisting of aptitude questions of English, maths, logical ability and attention to detail. 59 students were shortlisted out of 160.
3) After that, there was a case study, based on concepts of DBMS, SQL queries, and Data warehousing. More details about it can't be provided.
4) Following the half hour case study was a case interview, which went around for about 45 to 50 minutes, where we had to present our answers, based on the case, and also tackle the additional questions, based on the given case, by the interviewer.
5) Following the case interview was a Behavior cum HR Interview, which tested the person's ability to handle stress, various scenarios, estimation and calculation proficiency, and ability to analyze.
Finally, after 10 hours of the process, the final few were selected and congratulated by the team.