There were total 4 rounds of interview:
1 round was aptitude round in that basic maths, english and graph based questions asked.
2 round was technical round in that they will ask you about yourself, about your academic project, basic BI & DW rekated and SQL based questions. This round was conducted by 2-3 people and it took almost 30-40 minutes.
3 round was manager round in that round they will ask you few questions about yourself, basic BI related and sql based questions.
4th round was senior manager round in that they will ask you few questions about yourself, sql based questions, basic BI and DW related question, and some graph based questions.
Last round was HR round its very simple. HR will explain you their terms and condititons that's all.