Shopify Interview Question

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.