I applied online. The process took 2 months. I interviewed at Shopify (Ottawa, ON) in Mar 2019
Interview
very personality oriented, they want to make sure you are a cultural fit. Not too focused on data structure and algorithm as amazon or the other big Ns. It was overall a good experience and be extremely comfortable with whichever language that you will be using in the interview, make sure you know how to use the native data structures provided or know how to implement them.
Interview questions [1]
Question 1
1 technical skype interview,
1 life story skype interview,
2 pair programming interview (use tdd)
1 lunch interview
1 technical deep dive (go over your previous and current job technical detail)
1 system design (read and practice cracking the coding interview system design section)
First step was recruiter screen. After that it's a 1 hour SQL pairing exercise. For the SQL Screen, you are encouraged to use AI and it is done through Coderpad
Interview questions [1]
Question 1
First two questions are relatively straightforward with aggregations. The third question involves a cross join with a date spine. Basically you have some activities on certain dates, and need to fill in the activity count on missing dates with 0. I did not get a chance to look at the fourth question.
first round is recruiter, followed by a senior engineer, and then data engineer (pair programming round). after this is the classic shopify 'about you' round which is 1 hour long
I applied through a recruiter. The process took 3 weeks. I interviewed at Shopify (Toronto, ON) in Oct 2025
Interview
The interview process was collaborative, well structured, and engaging throughout. The interviewers encouraged open discussion, asked thoughtful and practical questions, and fostered a supportive environment. They focused on real-world scenarios, problem-solving skills, and past experiences, making the conversation feel natural, professional, and insightful rather than purely evaluative.
Interview questions [1]
Question 1
Can you explain how you would design and optimize a SQL-based data pipeline to handle large-scale data processing and ensure data quality?