I applied for the position through LinkedIn, and the recruiter reached out to me the very next day. Even though they took a very long time to schedule my first interview, my recruiter was pretty prompt throughout the time and had the virtual on-site scheduled at the earliest.

As for the interview process, the interviewers and the hiring manager were pretty friendly and made me feel comfortable throughout the process. Overall, the interview process was very well-structured and great!

Basic SQL using aggregations, window functions like LEAD, LAG, ROW_NUMBER, etc.

Problem-solving using Python arrays and dictionaries.

Open-ended questions about process improvement, error handling, robust designs, etc.