I had applied through campus process. It was a pool around 1000-1500 students had given the aptitude test.
1. Aptitude test : 20 ques. from quant, 20 ques. of C and 20-25 questions of SQL.
2. After clearing aptitude, they called me for GD. It was only an intro. They were checking that can you speak english or not with fluency. Cleared it.
3. Next day they called me for a technical test. Firstly they had given us two questions
---> Reverse the string
---> Sort the number array.
These codes need to be written on paper with a time limit of 15-20 minutes.
After this, they called me for face to face technical test. Asked me two explain the codes that i had written. After that, they fired a series of question of SQL (Joins, aggregate functions, Nested Queries, etc). When they were don with SQL part, it was time for C. Asked me to write code for a pattern and it's explaination. More focus was on SQL part.
Cleared this round. They called me for the last round of interview after a week.
4. In the 2nd Interview, It was again SQL and C. It was shorter as compared to the 1st interview.
They asked some SQl question, and 2-3 C questions like swapping of values without using 3rd variable, sum of digits of a number.
Finally, they announced the result after a week. I was a BitWiser :)