I applied online. The process took 2 weeks. I interviewed at MADE.COM (London, England)
Interview
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.
Interview questions [1]
Question 1
Motivation, data engineer technical questions and SQL questions.
I applied online. The process took 3 days. I interviewed at MADE.COM (London, England) in May 2018
Interview
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.
Interview questions [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)