Candidatei-me online. O processo levou 2 semanas. Fiz uma entrevista na empresa 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.
Perguntas de entrevista [1]
Pergunta 1
Motivation, data engineer technical questions and SQL questions.
Candidatei-me online. O processo levou 3 dias. Fui entrevistado pela MADE.COM (Londres, Inglaterra) em mai. de 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.
Perguntas de entrevista [1]
Pergunta 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)