Applied online. Recruiter emailed back asking for availability for screening interview.
Screening interview had leetcode medium question and SQL medium question. Interviewer was nice.
Then I was invited for virtual onsite. Virtual onsite has 4 rounds, 2 with the engineers in your team 1 with hiring manager and 1 with business partner.
1st Technical round included data modeling case study where you have to design a data model for a use case and to generate some metrics. 2nd technical round was to design an ETL pipeline for a use case. Manager round was mostly behavioral questions and business partner was product sense questions. All the interviews looked really tired and not really engaging.