phData Associate Data Engineer interview questions

There were two rounds of interview, technical and managerial rounds. They checked our skills in programming, basics in Data engineering, Operating systems, etc. Then they checked how well we communicate with people, handling situations, etc.

1st Round: 1st round was a pen-and-paper written test that included writing SQL queries and correcting the given SQL queries (if any) and a basic programming question for which you could only use Python or Java. This round also had a Google form with MCQs of computer fundamentals. 2nd Round: This was a face-to-face interview which was majorly based on my Resume. I was asked 1 DSA question (Given the value of a node in the linked list delete that node). Was asked about the working of Kafka and the spark architecture. Basic OOPs (4 pillars of OOP). Real-life applications of stacks and queues. Was also asked to design the backend of Zomato. 3rd Round: This round was more of a managerial round and we discussed my skills some basic managerial questions and how I would fit in the organization.