Overall process took 2months and I was reason for 2 weeks delay, but overall process was little slow.
1st Round(Tech): Architect took this interview.
He was assessing the feasibility of my tech background, etc.
After this interview, I got interview invites for R2, R3 and HM
2nd Round(slightly tech): HM: He asked couple of technical questions. He asked why I want to join. He asked mostly on my resume and my previous role and responsibilities etc.
3rd round(Tech): Architect: Asked many questions around Data warehouse, Databases basics. and along with some performance tuning techniques and some core SQL questions like SCD etc. These questions weren't asked directly. for example: instead of asking what is SCD, he asked "was there any situation in which there are changes coming to dimensions and if yes, how did you do that?"
4rth Round(Tech): Architect: He asked mostly on Data warehouses, and databases. He also touched a little on ETL, and tools. He asked 2 coding questions from Leet code.
5th Round(BT round): Senior Leader: He is from US and I had the call in the late night India time. This is same as behavioural round in Amazon. He asked 7-8 situations such as did you ever had a conflict with your peer? if yes, how did you manage that... etc.
