I applied online. The process took 4 weeks. I interviewed at Homa in Nov 2023
Interview
Candidature en ligne, avec un retour rapide de la recruteuse
1: Entretien RH en anglais
2: Test technique (à faire à la maison, environ 3h. SQL et Python, questions claires et pertinentes)
3: Call technique avec data engineers (lead et senior)
4: Rencontre avec le Head Of Data
Process transparent et efficace, disponibilité et réactivité des interlocuteurs
Interview questions [1]
Question 1
À partir d’une base de données de test, expliquer des requêtes ou en proposer (jointures, agrégations…)
- hiring manager screen
- take home
- take home debrief + live coding
You get a take home where you can use AI. Lots of SQL, their data engineers are more analytics engineers in that sense. Expect deep dives into your SQL queries and detailed questions. Then, coding question in Python that is straightforward if you have experience with backend/API, but there's a bunch of bonus questions that are more difficult after and more 'Leetcode' algorithms you wouldn't necessarily use on the job.
Interview questions [1]
Question 1
- Why did you write the SQL query like this
- Explain why you used this type of data structure/data format, go into details into what that format is
