Applied online. The recruiter emailed back asking for availability for a screening interview.

The screening interview included a LeetCode medium question and an SQL medium question. The interviewer was nice.

Then, I was invited for a virtual onsite. The virtual onsite had four rounds:

• Two rounds with engineers on the team
• One round with the hiring manager
• One round with a business partner

The first technical round included a data modeling case study where I had to design a data model for a use case and generate some metrics. The second technical round involved designing an ETL pipeline for a use case. The manager round consisted mostly of behavioral questions, and the business partner round focused on product sense questions. All the interviewers appeared tired and were not very engaging.

LeetCode anagram question.

Design data model for a fitness app.

Design ETL pipeline for user behavior analytics.

How would you analyze a sudden drop in certain metrics?