I recently interviewed at Snap for its Business Intelligence Engineer role with the People Analytics team. In a nutshell, this has been by far been the best interviewing experience I have had amongst many reputed organizations.
I connected and reached out to the hiring manager's LinkedIn post in mid September and at the same time applied on their portal. After a couple of days, I received a 15 min call from their Technical recruiter who was crisp, clear and very spontaneous through out my process, be it scheduling the interviews, answering my queries, and knowing what to expect for specific interview rounds. After which I interviewed with the hiring manager and got to know about team's vision, its roadmap and what exactly is expected from the role that I applied for. There were a mix of behavioral questions and my current experience in BI.
The virtual onsite rounds were divided into a mix of behavioral, medium level difficulty SQL, Data Visualization, and Python questions, that actually test you on real world like Snap's problems on calculating metrics, reporting and visualization best practices, and utilizing Python within the context of BI. I did get stuck for my SQL and Python rounds, but the interviewers do help you with hints or point a few syntactical errors.
Although, I got rejected after the final set of rounds but there isn't any regret. It was a great learning experience for me and knowing about Snap's strong culture on being Kind, Creative and Smart.