Me postulé en línea. El proceso tomó 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.
Me postulé en línea. El proceso tomó 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?