I applied through an employee referral. The process took 2 weeks. I interviewed at Spotify in Aug 2024
Interview
Phone screen w/ recruiter and then tech screen. The tech screen was very silly, it didn't test actual coding ability at all. I was told it would test sql and python but instead of actual python, it had a question on pandas which they should have specified. It seems like they don't know how to test for this role and the recruiter isn't familiar with tech roles. I asked the interviewer if they use python/pandas on the job and he said no... I was sent a rejection email a few days later.
Interview questions [1]
Question 1
3 main questions - 2 sql and one "python". First sql was to reformat the query for better readability. Second sql was to name the columns of a query based on what the logic was doing. Python question was really a pandas question that was something about updating a column in the dataframe based on a specific condition. Super dumb, I expected better from Spotify
I applied online. The process took 4 weeks. I interviewed at Spotify (London, England) in Nov 2024
Interview
HR call -> chat with the manager -> technical screening -> product manager interview -> take home presentation -> general analytics engineering interview -> interview check in.
The overall interview process is quite long, but quite efficient in my case. Most interviewers were very easy to speak to. Technical tests were about leet code easy level. The take home test was not too difficult, but mainly focus on the general solution design and how to make your presentation understandable for non-technical audiences.
Interview questions [1]
Question 1
How to work with product manager? How to deal with data when you scale up your data volume? What kind of data tests should be used for data models?
I applied online. The process took 4 weeks. I interviewed at Spotify (Stockholm, Stockholm) in Oct 2022
Interview
Overall process was good, it was 4 interviews but 5 overall if passed the system and dataset analysis interviews. Met with HR first, then the manager of the team for a general view of the role. Then the tech interviews started. It was clear up until the system design interview which would be preferable to be used to the kind of miro like interface. I was not and wasted a lot of time knowing how to use it with only my laptop and no mouse.
Interview questions [1]
Question 1
1. Coding assesment Solved a leetcode type problem with a streaming median. 2. Domain Interview Quiz about memory management, garbage collection, time to delete items from an array and TCP vs UDP. 3. System design interview Design a playlist photo upload service. This was harder than the others. 4. Dataset analysis Live coding some SQL and thinking about how to optimize for parallelization of queries using BigQuery.
