J'ai postulé en ligne. Le processus a pris 2 semaines. J'ai passé un entretien chez MADE.COM (Londres, Angleterre)
Entretien
2 stage interviews.
1st round phone interview.
Offline python test to submit within 48 hours.
2nd round 2 hours online interview.
The first hour is live SQL exercises.
The 2nd hour is technical questions.
Questions d'entretien [1]
Question 1
Motivation, data engineer technical questions and SQL questions.
J'ai postulé en ligne. Le processus a pris 3 jours. J'ai passé un entretien chez MADE.COM (Londres, Angleterre) en mai 2018
Entretien
A phone interview that involves relatively generic questions. If you pass that stage then you have a face to face meeting that involves 3 main exercises: an SQL exercise on the whiteboard with basic SQL syntax and windowing, an exercise with regular expressions in Python and finally an exercise to write in Python where you have to read mappings from a file and update them dynamically using dictionaries.
Questions d'entretien [1]
Question 1
How would you select only the first row for each customer from this orders table using SQL? ( multiple customers and multiple orders per customer)