SQL questions: I think 3 per interview, 2 simple and 1 hard. Group bys, order bys, for time periods. Growth questions and time comparisons. (have those down), generally joining two or three tables, but the join ids are simple, nothing crazy. Chart question: Look at this axis less chart and tell me what it means in relation to the postmates business.
1 hour 15 min talking about background and things you've done, why postmates. 30 minutes for SQL. last 10 minutes for questions. talk about a drag supposed to be 1 hour interview.
How would you set up a process to eliminate webspam in search results?
1 car is traveling for 1.5 hours at 50 miles per hour. A 2nd car is traveling for 75 minutes at 60 miles per hour. Which car has traveled a longer distance
What differentiates you from other candidates
1) What would be your goal in helping new hosts be successful and what conversations would you have in determining this goal? 2) How would you go about analyzing the first 30 days of new host bookings.
What skills would I bring to help continuous improvement working Pacson’s
Tell me about yourself
The interview contained competence-based questions.
1. Some basic SQL query 2. Guess Three fastest car among 25 car, groups only 5 cars 3.How did you manage waiting time for elevator of 50 story building 4.How did you calculate left finger from over 5 billions people, it should be 5*5*..... 5. There are 5 rows , how did you plant only 10 tree but for each row tree should be 4 6. Candy mislabelled question 7. How can you find out ATM transaction from XYX station(Guesstimate question) 8.One quarter your e-commerce website revenue is good, another quarter its average and third quarter its drastically down. What is the factor of down. 9. A won 3 match and B have 5$, how many bets they fight for every match when they won 1$ for each win. 10. 3 10 101 ?, find the fourth number
Viewing 31 - 40 interview questions