There were 3 rounds:
a: HR, b: 1 hour Technical c: 4 hour final loop
a. HR: It was a brief one hour call with recruiter to go over resume and basic things like visa status, salary, role expectations etc.
b. Technical: This was a one hour technical round with SQL and basic python along with a couple of behavioral questions
c: Final Round: 4 round of 1 hour each with 1 Behavioural Round, 2 Bar Raiser Round, 3. Technical Round(SQL,Python),4. Applied Scientist Round