I applied online. The process took 2 weeks. I interviewed at Shopify (Toronto, ON) in Feb 2024
Interview
Second Interview- Pair Programming
45 Mins of SQL followed by 45 Mins of Python OOP. You need to look at the tables carefully. Even with a strong SQL background, they are looking to see if by viewing the tables and understanding the ask, if you know when to use every kind of join. It was very tricky and in the real world , you would notice this only once you review your results. But in an interview it is tough to do this on the spot.
Interview questions [1]
Question 1
Write a query to calculate how many shops are active at the beginning of each month.
Interviewed with the hiring manager, really weird experience because it felt like an info session for me to ask questions. Whole thing was done in about 20 minutes with the guy being distracted by Slack messages.
It came off like they already filled the role before this interview
Interview questions [1]
Question 1
Tell me about yourself and why do you want this job
I applied through a recruiter. I interviewed at Shopify (New York, NY)
Interview
An unnecessarily long pre-interview process that requires an assessment test, a ridiculous survey with 100 questions, and 1 hour pointless life story, although easy, was annoyingly long and took away from the interview experience.
I applied, got the assessment the next day, and passed the assessment 100%. The HR contacted me roughly two weeks later for pair coding. first round assessment: the question varies --> second round pair coding: system design
Interview questions [1]
Question 1
no behavioral questions. just typical system design questions