Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso MADE.COM (Londra, Inghilterra)
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Motivation, data engineer technical questions and SQL questions.
Ho presentato la mia candidatura online. La procedura ha richiesto 3 giorni. Ho sostenuto un colloquio presso MADE.COM (Londra, Inghilterra) nel mese di mag 2018
Colloquio
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.
Domande di colloquio [1]
Domanda 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)