The process began with a quick recruiter chat to go over my background and what to expect.

Then, there were two technical phone screens. During these, I had to write SQL and Python on the spot and explain my logic as I went.

After that, I was invited to a virtual onsite with four interviews. These interviews covered everything from data modeling to system design, as well as some behavioral aspects.

The questions were tough but interesting, and the interviewers were super sharp yet friendly. Honestly, it was intense, but overall, a great learning experience.

Design a data pipeline to process and aggregate user clickstream data in near real-time.