Virtual interview with 3 engineers and only one shared their video. I didn't make it past the first round because they were looking for someone advanced in data engineering with specific skillset.

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.