Data Engineer · Phone Screen · Coding

Lyft — Data Engineer ❌ Failed

Level: Mid-Level

Round: Phone Screen · Type: Coding · Difficulty: 6/10 · Duration: 60 min · Interviewer: Neutral

Topics: SQL, Python, Data Structures, Algorithms

Location: San Francisco Bay Area

Interview date: 2025-05-15

Got offer: False

Summary

In a one-hour phone screen, I was given two SQL questions and one Python question.

Details

I had one hour to complete three questions: two SQL questions and one Python question. The Python question was to invert a list of characters, keeping spaces in their original positions. For example, ['x', ' ', ' ', 'y'] should be inverted to ['y', ' ', ' ', 'x']. The two SQL questions required writing multiple CTEs. I found the time constraint tight.