3 rounds of interview. 1st round was interviewer asking all theoretical data concepts. 2nd was resume based questions. 3rd was with the director which was simple as if I’m comfortable traveling to office, schedule and such

There were two interview rounds, both conducted virtually. Round 1 – Technical Interview (45 minutes): This round was led by two technical panelists. The conversation started with a short discussion about my resume, and the projects I listed related to data engineering and analytics. The technical part focused mostly on SQL and Python: SQL questions: Topics included JOINS, GROUP BY, aggregate functions, RANK functions, and DDL, DML operations (INSERT, UPDATE, DELETE). Python questions: General Python coding and logic-based problems. One of the tasks tested basic understanding of iteration and data manipulation. Round 2 – Final Interview with Director: This round included similar technical questions on SQL and Python, along with some behavioral questions related to teamwork, problem-solving, and my interest in data engineering. Overall, the interview was structured, friendly, and technical. It focused on fundamentals of data engineering and coding, with a clear expectation that candidates have solid SQL and Python skills and can explain their project work confidently.