I applied online. The process took 2 weeks.

The process was as follows:

• Recruiter screen
• Personal story - share your journey and what are your motivations and goals
• Pair programming - Super easy SQL based interview. The interviewers were very nice and helpful and it felt like mutual exercise.
• Technical project - walkthrough of one of your technical projects. Again very nice interviewers and asked good questions.
• Technical problem solving - Easy technical problem but the interviewer had set his mind on a particular solution and he wanted exactly that. My solution was pretty close and was solving the problem but he had set his expectations and wouldn't even hint on what he wanted until we ended the interview.

Overall the process was well organized and very nice and I received a call from the recruiter providing me with feedback and encouraging me to apply again. The feedback I received from the last interviewer was that my answer wasn't structured well. Anyway, I am grateful for the feedback and for meeting all the nice people. Spela is an amazing recruiter. I loved the transparency that she provided me.

All interviews were based on SQL.

Prepare for basics, group by, and window functions, and you're good.

Just practice a couple of questions on Data Lemur and go through one funnel analysis. That should be more than enough.