Lyft Data Engineer interview questions

Recruiter reached out to me on LinkedIn and after discussions I was setup for a phone interview using coderpad. The phone interview had 1 each of SQL and python questions which I managed to solve with a few hiccups. I was then setup for onsite which had 5 rounds and lunch with a team member. Onsite 1st round - General discussion about my profile and started off with leetcode problem. I partially finished but could complete since ran out of time. Lunch time - Waited for the team member who was supposed to take me for lunch but he never turned up and I missed the lunch. 2nd round - SQL coding on MacBook with MySQL session. The interviewer was busy with Facebook and didn't know or answer any of my clarifications. All 3 queries went unanswered since I didn't get the clarifications and was not sure what to expect. 3rd round - Came in and introduced himself and started with the behavioural round and asked about previous work experience. 4th round - System design round, was asked to design a distributed system with failover considered. 5th round - Lyft use case for designing a dimension model. Overall less than average onsite interview and as expected didn't get the offer.

I was referred through employee friend of mine. The phone interview contained 2 parts of 30 minutes each for Python and SQL. Provided correct answers to both SQL and Python questions alongwith the justification and time complexity. Still NO OFFER for onsite. Reading reviews here it seems they are interviewing a lot and actually not proceeding with hiring which is such a waste of everyone's time. WORST PART is they don't even provide a ready schema in MYSQL on coderpad to test your SQL. They just give you tablename and columns.