There were 6 rounds of interview. 1st round is 20 mins aptitude and 25 minutes sql+algorithms 2nd and 3rd are pure techinical rounds where you will be asked to write some queries from the dataset which they already have. Mainly analytical functions like lead, rank etc. 4th will be like a manager round / behaviour round. 5th will be a case round and 6th will be a case round again. I was told i El be having only case analysis round but they took one more case round and i did not get through in the 2nd case round.