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.

Two rounds of interview. One technical round with their Data architect and data engineer. Second round will be with the director if you clear technical round. In technical round, it will be mostly SQL and Python based questions. You have to be strong SQL (DML statements, DDL statements, joins, window functions, etc) and basic libraries in python. If you are continuosly spending time in leetcode and hackerrank, this will be straight forward.