Envié una solicitud electrónica. El proceso duró 4 semanas. Acudí a una entrevista en HelloFresh en oct 2018
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 1
What is the difference between Union and Union All in SQL? What is cross join in SQL?
Envié una solicitud electrónica. El proceso duró 3 semanas. Acudí a una entrevista en HelloFresh (Dublín, Dublín) en jul 2019
Entrevista
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.
Preguntas de entrevista [2]
Pregunta 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.