Ho presentato la mia candidatura online. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso Deliveroo (Londra, Inghilterra) nel mese di dic 2024
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Experience with data modelling in an analytics function
Ho sostenuto un colloquio presso Deliveroo (Londra, Inghilterra)
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Can you explain the difference types of joins in SQL?
Ho presentato la mia candidatura online. La procedura ha richiesto 7 settimane. Ho sostenuto un colloquio presso Deliveroo
Colloquio
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.
Domande di colloquio [1]
Domanda 1
How can you optimise your query, and why would this improve performance?