Candidatei-me online. O processo levou 3 semanas. Fui entrevistado pela HelloFresh (Dublin, Dublin) em jul. de 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.
Perguntas de entrevista [2]
Pergunta 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.
Candidatei-me online. O processo levou 4 semanas. Fui entrevistado pela HelloFresh em out. de 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.
Perguntas de entrevista [1]
Pergunta 1
What is the difference between Union and Union All in SQL? What is cross join in SQL?