ABC interview questions

First of all, the interviewer introduced herself and asked for a quick intro about me , my interest and the projects that I had done. So I answered her accordingly. Then she went through my resume and asked me to explain any one project that I liked the most while doing it. I explained the project in detail and told every single thing used in my project. She was impressed with my explanation. Further she asked me questions on Operating Systems (Synchronization, Semaphore, Various types of job scheduling algorithms and their practical application ), DBMS (All types of Keys and Joins). She also asked me questions from OOPS like data abstraction and encapsulation and it’s real life application and later asked me to code it too. Then she moved to the DSA part and asked me to explain about linked lists and arrays , their advantages, then there were few cross questions (scenario based) on that. Since, it was more than 45 minutes of discussion, so we discussed the implementation approach. At the end, she asked me if I had any questions for her. Then I asked her about the company’s work culture. After that, this round ended. 2nd Technical Round (Tech + Managerial) I got confirmation from the placement cell that I have been moved to R2. The interviewer introduced himself first and asked me to do the same. Then He asked me where I live currently and about my family background. After that he asked me to explain the project and also asked about the challenges that I faced while doing the project. Then he asked me about APIs and how it works and there were few questions on DBMS like 3 layers of architecture, temporary table and fixed table, trigger, truncate etc. Further, he asked me 6–7 managerial type questions like where do you see yourself in the next 5 years. what is your biggest achievement till date etc. At the end, he asked me if I had any questions for him. After that, I asked about his experience at the company. And then this round was over.

A data engineer interview typically includes SQL and data modeling tests, ETL pipeline design, Python proficiency, big-data tools, cloud platforms, system design, debugging tasks, and behavioral rounds evaluating problem-solving and collaboration skills.