Ho presentato la mia candidatura online. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso HelloFresh (Dublino, Dublino) nel mese di lug 2019
Colloquio
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.
Domande di colloquio [2]
Domanda 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.
Ho presentato la mia candidatura online. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso HelloFresh nel mese di ott 2018
Colloquio
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.
Domande di colloquio [1]
Domanda 1
What is the difference between Union and Union All in SQL? What is cross join in SQL?