I applied online. The process took 3 weeks. I interviewed at HelloFresh (Dublin, Dublin) in Jul 2019
Interview
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.
Interview questions [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.
I applied online. The process took 4 weeks. I interviewed at HelloFresh in Oct 2018
Interview
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.
Interview questions [1]
Question 1
What is the difference between Union and Union All in SQL? What is cross join in SQL?
