I applied online. The process took 2 weeks. I interviewed at Deliveroo (London, England) in Nov 2021
Interview
Initial screening call with a recruiter. He might ask you some high level questions on your experience.
Technical interview with a senior data engineer, no coding, but technical questions asked verbally. 5 SQL questions, 5 Python questions.
Interview questions [1]
Question 1
Q: What is the different between list and tuple in Python
Q: If you are writing a package, would you lock version of its dependencies or would you get the latest versions of the dependencies
Q: Which joins are there in SQL, and explain each
Q: What is "index" in SQL
Thank you for taking the time the share your experience. Sorry we won't be working together but hopefully we'll cross paths again in the future :) - Jamie
Neutral experience
Average interview
Application
I interviewed at Deliveroo (London, England)
Interview
They are several rounds of interviews. First is an experience based prescreening interview, it was a relax chat style interview. The second is a technical interview, in which I was asked question about SQL techniques, the was more formal.
Interview questions [1]
Question 1
Can you explain the difference types of joins in SQL?
I applied online. The process took 1 day. I interviewed at Deliveroo (London, England) in Dec 2024
Interview
Screening call.
Some chit chat about travel.
Questions about data modelling and experience presenting and current work place.
Some chat about technologies used but it seemed like they were open to different tech stack background.
Some questions.
Interview questions [1]
Question 1
Experience with data modelling in an analytics function
I applied online. The process took 7 weeks. I interviewed at Deliveroo
Interview
The interview process lasted seven weeks from application, with an initial call, a technical screen, a coding interview, and then a rejection. Communication between stages was minimal, often requiring prompt emails for updates. The first three stages seemed designed primarily to reduce the number of applicants. The coding interview included two SQL questions, neither particularly complex, so the rejection was unexpected. The feedback suggested the company is focused on candidates with specific experience in PostgreSQL, Snowflake, and DBT, leaving little room for those without this exact background. The role has since been reposted on LinkedIn, suggesting they may be struggling to fill the position due to their narrow hiring approach. LinkedIn also shows that those who previously held similar roles stayed under two years, which could indicate high turnover and limited career prospects.
Interview questions [1]
Question 1
How can you optimise your query, and why would this improve performance?