I interviewed at DoorDash (São Paulo, São Paulo) in Feb 2023
Interview
Caos! O processo está rolando há pelo menos 3 meses e contanto, foram 9 entrevistas entre técnicas e não técnicas. Existe uma empresa que está prestando consultoria mas claramente existe muita falha de comunicação e parece que todos estão contratando alguém pela primeira vez na vida.
Interview questions [1]
Question 1
Perguntas gerias sobre pipelines e modelagem de dados. Dentre as nove entrevistas uma delas foi muito proveitosa, supostamente com o country manager e depois disso veio a ofertas mas as entrevistas continuam.
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
Interview questions [1]
Question 1
SQL questions based on DoorDash data schema, python leet code medium
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.
Interview questions [1]
Question 1
Sum(case when attribute is true)
Unions
Hard SQL using window functions
Python leetcode Easy