prepare sql subqueries and percentage questions and python medium level questions leetcode, I was given only the screening. was able to solve sql but python it was time up. prepare sql and python well. and also manage time properly.
Me postulé en línea. 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
Tem 3 entrevistas técnicas, entrevistadores vem preparados e compensa se preparar com antecedência. Não necessariamente tem uma resposta certa a depender da entrevista, mas dado o caminho que vc escolher o quão completo você conhece desenhar e questionar a solução.
Preguntas de entrevista [1]
Pregunta 1
Perguntas objetivas de programão, pyhton e sql e perguntas de design thinking
