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
