I applied online. The process took 2 weeks. I interviewed at FARFETCH (Lisboa, Lisboa) in Jun 2019
Interview
Applied online and 2 weeks after received a link to a 2 hours online excercise which covered various aspects of data warehousing and integration. In 2 days received an invite to a Skype interview, but the time offered didn't work for me. I suggested other days/times but they never came back to reschedule.
Interview questions [1]
Question 1
What are the pros and cons of database denormalization?
I applied through an employee referral. The process took 3 weeks. I interviewed at FARFETCH (Portugal) in Oct 2021
Interview
A very well-conducted process by the Talent team, a live coding session with a team lead and a senior Data engineer, with data modeling questions, and also a python challenge.
Interview questions [1]
Question 1
Live Coding Session, including data modeling and also Python questions
I applied through an employee referral. The process took 2 weeks. I interviewed at FARFETCH (Porto, Porto) in Aug 2021
Interview
3 rounds + offer screening call with HR, with questions about experience, discussion in english and 5 basic sql/programming questions Technical round with team lead - hackerrank/leetcode type questions: - 1 or 2 python, 2 or 3 sql and 1 data modelling final round of behavior with team lead and manager
The first interview with the human resources team, I was asked to develop a project and was given 8 days to do it, the second interview was the presentation of this project, finally the result.
