J'ai postulé en ligne. Le processus a pris 4 semaines. J'ai passé un entretien chez HelloFresh en oct. 2018
Entretien
I applied online. I got an test invitation email to negotiated the test time 3 days later. Then, on the day of the test, the hiring manager sent me a test document( SQL questions + business case). The SQL questions are based on a database consisting of 5 tables. The business case is about audience targeting, cost and revenue calculation. After the test, I got a video interview invitation after one week and then I had a video interview with the hiring manager. He asked me some questions about the SQL, product analysis metrics. After one week, I got an onsite inverview. Three team members from the product team had 1v1 discussion with me. One is about the A/B testing, one is about my past data analysis experience and one is about SQL & Python questions.
Questions d'entretien [1]
Question 1
What is the difference between Union and Union All in SQL? What is cross join in SQL?
J'ai postulé en ligne. Le processus a pris 3 semaines. J'ai passé un entretien chez HelloFresh (Dublin, Dublin) en juil. 2019
Entretien
Online Technical, Business and Insights test that you have 3 hours to complete and submit by email, followed by a 30 minutes skype call with career and technical questions, plus job role overview.
Questions d'entretien [2]
Question 1
The business test was for you to explain marketing related decision for a product like Hello Fresh, then you had an ERD with some table and 8 SQL questions to answer with the code, and finally some questions related to AB testing decisions.
After the technical test they schedule a 30 minutes call. The interviewer was nice and polite. Questions about my career, asked to explain AB test and the difference between inner join and left join.
