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.

Technical round and about the software cycle, data engineer Software cycle and having devops experience with the integration Having report experience Debugging and scalability of the AWS services Having the network knowledge on the various source data