Me postulé en línea. El proceso tomó 2 semanas. Acudí a una entrevista en MADE.COM (Londres, Inglaterra)
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 1
Motivation, data engineer technical questions and SQL questions.
Me postulé en línea. El proceso tomó 3 días. Acudí a una entrevista en MADE.COM (Londres, Inglaterra) en may 2018
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 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)