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.

Technical phone screen, virtual interview including 4 rounds - system design, coding, SQL, experience interview. There's hiring review after that where a separate team evaluates the scorecards and makes a decision whether to offer a job to the candidate or not.