Applied through a referral, Had 4 rounds - recruiter, HM, SQL round, 4 onsite
After HM manager's interview onsite interview he thanked me and gave a vibe that it is a NO which was very strange.
I applied online. I interviewed at Lyft (New York, NY)
Interview
HM asked multiple questions randomly, Questions focus more on business view. This company culture sounds like stressful and not hearing hte employee voices. feel like they work overtime and stressful working environment.
I applied online. The process took 4 weeks. I interviewed at Lyft (San Francisco, CA)
Interview
Take home assignment which includes SQL coding and case study question, technical with Hiring Manager, final round consisted of 5 rounds, 1 techical-coding, 2 stakeholder management, 3- process improvement, 4- technical round based on experience.
Interview questions [1]
Question 1
Assume that we have the following tables, with columns as indicated:
Rides
ride_id
start_time
end_time
passenger_id
driver_id
ride_region
is_completed (Y/N)
Drivers
driver_id
onboarding_time
home_region
1) Write a query that we could use to create a plot of the total count of rides completed in
our San Francisco region, in each week over the last 12 weeks.
2) For each week over the last 12 weeks, write a query that will return a count of the total
drivers who gave at least one ride. And only for driver’s based in San Francisco.
