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.

Multiple interview rounds: - #1 initial screen by inhouse recruiter - #2 "life story" with inhouse recruiter: Basically they ask you to do a long in-depth walk through your resume - #3 creative problem solving: You are presented with a problem and asked how you would solve it. This was less focused on a technical solution, they were looking for solutions on a data/product/communications level. - #4 pair programming: A one-hour live coding session in Python, mainly wrangling some rather simple data structures - #5 pair programming: Another one-hour live coding session, this time going into details of Python coding - #6 interview with future manager: They ask you to explain one project you worked on in the past. Focus on technical details, the range of tech components you had ownership of, the number of people on the team, the scale of decisions you had to make - they want you display deep technical understanding and the capability to drive large cross-functional projects