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?
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