1st round was a written test that comprises with a very difficult SQL test. They give you tables with the data on a paper and asks you questions. Either you crack the test or no, they will call you for the 1st 1:1 round.
Questions from the written test.
1. How to generate data from two or more table without using sub-queries?
2. Cross Join, Left Join and Right Join?
3. How to get rank/position of John? etc..
2nd round with the panel 1:1 on the same day:
Asked about my background, my past work culture and responsibilities that I had, I cleared this round and was asked to wait for 3rd round.
3rd round 1:1 with a senior manager it seems and this will be the deciding round
a) General walk-through on my profile
b) Gave me a business scenario/case, where I should start questioning the interviewer to collect information/requirements
c) Asked about BRD/FSD/SRS, what is not covered on BRD/FSD/SRS?
e) How do you initially gather the requirements?
f) What are the techniques that you use personally to gather requirements?
g) How well are you with data/SQL?
h) Rate yourself between 1 to 10 on sql?