Great Spotify Data Engineer Interview Experience

I just went through 2 rounds of the data engineering position and want to share some tips for those who are planning to go through it. PS: I wasn't selected unfortunately but it was still a good learning experience. Shoutout to the Recruiters, it was actually very good contrary to what I've been seeing online. Interview stages: (1) Phone screen: - Basic tell me about yourself and why you applied. - What is the difference between a set and a list - Different types of SQL JOINs - Read up on the role and department you applied for This round was pretty easy After 5 days, I got a mail for the next stage (2) Technical Screening: - A LOT of computer science trivia questions. - Talk about projects you have worked on. - Know everything you can about distributed computing concepts (and everything lol). They want to know how much you know and how well you understand computing concepts. - Understand the Hadoop ecosystem - Read up on their Engineering blog, a lot of good information is on there - Few tech areas that were covered: -- different types of SQL JOINs -- Understand the complexity of different search and sort algorithms with explanations as to why they are good or bad. (binary search) -- Questions on CI/CD and how they are useful -- Map Reduce concepts and example of how to implement it (verbally)!! -- Hadoop framework -- Understand the CAP theorem -- Understand probabilistic data structures -- A bit on statistics -- Understand unit testing and why they are important -- Asynchronous -- Hashing algorithms Coding Part: - String Manipulation questions in the language of your choice (do a lot of Leetcode and Hackerrank) - A lot of simple SQL questions to find the top songs in a table etc. - Read ALL the questions on Glassdoor! Almost all the areas listed on Glassdoor were asked. (3) Interview with 3 others (but I never made it this far) After 2 days, I heard back from them. SUMMARY: Honestly, if you work on really big data everyday, this should be a reasonable interview. Best of luck. #spotify #dataEngineer #dataEngineering