Spotify

Data Engineer Interview Experience - New York, New York

February 1, 2023

Positive ExperienceNo Response

Process

Phone screen with the hiring manager, followed by a team panel interview.

Mainly focusing on advanced SQL, analysis, and Python.

Based on your resume, you should be prepared for anything.

Questions

How to handle conflict.

Window functions SQL

Interview Statistics

The following metrics were computed from 8 interview experiences for the Spotify Data Engineer role in New York, New York.

Success Rate

Pass Rate

Spotify's interview process for their Data Engineer roles in New York, New York is extremely selective, failing the vast majority of engineers.

Experience Rating

Positive13%

Neutral25%

Negative63%

Candidates reported having very negative feelings for Spotify's Data Engineer interview process in New York, New York.

Spotify Interview Questions

Sliding Window Median

Hard

Find the median of all sliding windows of a given size within an array of numbers. The window slides one position at a time from left to right.

ArraysSliding Windows

Moving Average from Data Stream

Easy

Design a data structure to calculate the moving average of a stream of numbers. The moving average is calculated over a sliding window of a specified size.

ArraysSliding Windows

Analyze User Website Visit Pattern

Medium

You're given user website visit logs. Find the most frequent sequence of three websites visited by any user.

ArraysTwo PointersSliding Windows