Envié una solicitud electrónica. El proceso duró 4 semanas. Acudí a una entrevista en DoorDash (São Paulo, )
Entrevista
Primeiro fiz um live coding com 3 desafios sql e um python, nao é tao dificil mas tem pouco tempo. Para se preparar faça desafio fácil do leetcode até compreender 100% as melhores soluções.
Depois fiz 3 etapas de uma vez só: um case de modelagem de dados (app de fitness), um case de dashboard, e uma entrevista comportamental padrao (me conte seu maior desafio técnico, me conte quando teve um conflito com um colega, etc)
Preguntas de entrevista [1]
Pregunta 1
Faça a modelagem de dados de um app de videos fitness
First it was a simple RH call to discuss how the process would be and then there was a live coding interview with 4 SQL and 1 Python question, which was a very negative experience. The time was very tight to solve all the SQL questions specially because the last ones were very complex, the Python one was fine but test cases included some very specific edge cases which were not clear in the problem statement. The interviewer was not helpful at all, actually quite the contrary, usually while explaining my thoughts he would break my line of thought which caused me to lose a lot of time. Would not participate in the process again
Preguntas de entrevista [1]
Pregunta 1
SQL questions based on DoorDash data schema, python leet code medium
Envié una solicitud electrónica. Acudí a una entrevista en DoorDash
Entrevista
1 tech screening + 4 rounds, technical + business metric questions, like product analytics, SQL, Python, System Design, Business questions, like developing a fitness application, neeed to do dimensional modelling for it, iwth facts and dimensions
I gave a technical screening interview. It had 4 SQL and 1 python. I was able to complete 3 SQL and 1 python(o(n)) solution , explained my thoughts throughout the interview. However I was rejected, company didn’t provide any feedback. They use hackkerank and my 3 SQL query was right in postgresql but Hackkerrank only supports mysql, I got stuck finding a different approach to solve this problem to compile in MYSQL and lost time. The interviewer was not helpful at all, he saw my approach and syntax was correct in postgresql, yet waited for me to find a mysql solution that passed all test cases. Despite of solving 3 questions in SQl and 1 in python with all test cases , they rejected. They are looking for robots not humans.
Preguntas de entrevista [1]
Pregunta 1
Sum(case when attribute is true)
Unions
Hard SQL using window functions
Python leetcode Easy