There were 4 stages: 1. Behavioural and Life story, 2. Pair Programming (combined SQL and Python) - SQL was more of simple queries with some use of advanced window functions. Python was where there were 3 methods in a class and you had to fix a bug and develop more features. There were some unit tests that you had to update along the way. This is where I stopped even though I did well on the pair programming. 3rd and 4th stage would have been technical deep dive and then leadership review. What I dint like was being ghosted even though the interviewer had all positive comments at the end of the interview and was talking about the next steps.
Check out your Company Bowl for anonymous work chats.