The interview panel was pretty chill and they really asked very good questions. A single coding question and most of the questions were on my previous work experience. It started with submitting my application, and after about a week, a recruiter reached out to schedule a quick introductory call. That first call was mostly non-technical — the recruiter asked me about my current role, experience with data pipelines and cloud tools, why I was interested in the position, and what my notice period and salary expectations were. It was fairly straightforward and relaxed.
After that, I was invited to take a technical screening. This was a live coding session over a shared editor and lasted about an hour. I had to solve a couple of SQL problems, including writing queries with joins and window functions, and then there was a Python task where I had to parse and clean a JSON dataset. They were looking for how well I handled edge cases and how readable and efficient my code was.
Once I passed the screening, I moved on to the technical interview rounds. The first one focused on SQL and data modeling. I was given a scenario about an e-commerce system and asked to design the schema for tracking orders, customers, and products. Then I had to write some queries to answer business questions based on that schema. It was challenging but manageable.
