HR call, tech screen using SQL moderate, Final loop has 5 rounds, one sql easy, one python moderate, one design moderate, 2 behavioural round.
It is quite smooth and have ample time to prepare between rounds.
Interview questions [1]
Question 1
Data modeling questions, sql joins and aggregations
Python coding using loops, dictionaries
General concepts of Big data