1 round telephonic and total 4 rounds at onsite. each onsite interview will have 2 or 3 ppl. total 4 hr it will take. During this time, you will be only offered free water.. no lunch. you need to bring from home or buy there. :)
telephonic interview was easy and more of sql , data modeling, role based, why this company etc...
onsite interview.. be ready and refresh your 10 years old projects and work. 1 round with director , 1 with product owners and it will be allmost role based question.
1 round for sql and 1 round for data modeling and MPP architecture and performance, partition etc..
Honestly, all these questions were 10 years old interview fashion. On top of it, lady was not at all interested to listen my answers. i feel they are just wasting time.