1 tech screen with HM (1 hour), and then onsite interview in their Boston office: 3 rounds, 1) SQL, 2) Data Model, 3) Python and DBT / Airflow debugging.
There was 1 hour for the SQL interview. However, due to their laptop setup, I only got 45 mins to finish all four questions. I finished in 40 mins, and after each question I confirmed the correctness before moving on. But the interview feedback is I started to be lost from Q3, and didn't finish Q4.
If you don't want me to hire me, just say no. No need to lie!
And be more organized with your onsite interviews setup, and train your interviewers!