I was contacted by their recruiter which followed by a phone call with the hiring manager. Phone interviews went really well, everyone was professional and provided all necessary details. They reached out after about 2 or 3 days to schedule technical phone interview which consisted of basic SQL and algorithm questions. I noticed throughout the interview process that they tend to put some extra attention to their corporate culture, so be aware of that and make sure you reviewed their corporate slides (available on their website). Then I flew to their HQ in Los Gatos, CA. They divide interview process in two parts: 3 interviews in between lunch. If they feel like you're not the best candidate, you will not proceed with the 2nd part and they will tell you right after lunch. That's what happened to me even though I think I answered all questions. Be prepared to answer questions about optimization of code/SQL that you wrote on white board, it seemed that they expect answers in a certain way.

design star schema and some easy leetcode type problem. fairly easy stuff to code some sql and python. sql had some window functions and pythong with dictionaries . design and query this star schema for subscriptions