Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Spotify nel mese di ago 2024
Colloquio
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.
Domande di colloquio [1]
Domanda 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
Ho presentato la mia candidatura online. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Spotify (Londra, Inghilterra) nel mese di nov 2024
Colloquio
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.
Domande di colloquio [1]
Domanda 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?
Ho presentato la mia candidatura online. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Spotify (Stoccolma, ) nel mese di ott 2022
Colloquio
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.
Domande di colloquio [1]
Domanda 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.
