Asana Data Science interview questions

One of the most disappointing and frustrating interview processes I have experienced. Applied online, contacted by a recruiter to set up a screen. Recruiter missed the initial phone screen and we rescheduled to another day that week (first red flag for this recruiter). After recruiter screen, set up technical screen - part SQL, part Case Study. Reasonable questions. Again, recruiter took a full week to get back to me after the screen, with positive news. I asked to accelerate the process as I had other offers/was further along with other companies then. Followed up several times to be ghosted for 2 weeks. 2 weeks later, recruiter emails asking if I can do the final round the following day. I couldn't - had other commitments and need time to prep, etc. so asked for a couple more days. I sent it my availability and while waiting for the final round to be scheduled, I get an email that they filled the role. I understand when companies want to move fast and fill the role, but this was a colossal waste of my time and the recruiter was honestly terrible. All the interviewers I did get to meet seemed nice and reasonable.

I applied online, and the recruiter reached out one week later to schedule a 30-min video chat with HR. One round of 1hr technical phone screening and then one day of onsite.