It was a day long process as the candidate were around 400.
ROUNDS: 1.Online Test | 2. GD | 3. Technical | 4. Final Technical + HR
1. Online Test - Logical Ability (Easy and 22 Q's in 30 min) (number series, pattern, very basic aptitude)
- SQL (Easy and Objective with 22 Q's in 35 min ) (View, index, trigger, keys, basic from theory)
2. GD (Topic: Is china's technology or ITs threat to India) 4 of 10 cleared this round!
3. Technical: May be b'cz the tech HR's didn't came to Indore, this became a telephonic technical round. Its was a round full of tech Q's but easy questions.
About yourself, Major/Minor projects, technology known.
SQL - join, view, index, trigger, why to use view when I can get the table by select query, group by, order by, highest salary, 2nd highest salary, keys in RDBMS, integrity constraints.
JAVA/OOPS - encapsulation, data abstraction, concepts of OOPS, object and class.
At last I was asked a puzzle too, was tricky but easy!
4. Final Technical + HR: Introduction, Q's from resume, asked to write a query for getting table conditionally (used where clause), integrity constraints, trigger, advantage of using index, do you hold an offer from somewhere else? If didn't joined? How many interviews given till now? Why bitwise? Do you know anybody at bitwise?