I applied through university. The process took 5 days. I interviewed at Genpact (Bengaluru) in May 2021
Interview
The interview process was smooth. There were multiple rounds. All questions are from the academic. I have experience on AWS cloud, that was add-on in the process. The interview process for a data engineering position can vary from one company to another, but it typically consists of several stages designed to evaluate your technical skills, problem-solving abilities, and cultural fit within the organization.
Interview questions [1]
Question 1
Explain the ETL (Extract, Transform, Load) process and its importance in data engineering. What are the key differences between batch and streaming data processing? When would you use each approach? How do you ensure data quality and consistency in a data pipeline? What is the purpose of data warehousing, and how does it differ from a data lake? Can you describe the components of a typical data pipeline architecture? What is the role of Apache Hadoop in data engineering, and how does it work? Explain the concept of data partitioning in distributed databases. Why is it important? What is schema-on-read and schema-on-write, and when would you use each approach in data storage?
it was on-campus
Online assessment + group discussion + technical interview.
I was asked computer science fundamentals, easy dsa questions and sql at the end. Then we had a discussion regarding my projects
DBMS Questions with SQL queries mid level
Python coding questions
Asked about my projects in my previous organization.
HR : Where I will see my in 5 Years. Salary discussion.
Interview questions [1]
Question 1
about Joins, window functions, Rank, Date Time extraction using SQL
At my last job, our company suddenly switched to a new software system, and many of my coworkers were struggling with it. I took the time to learn it quickly and then helped train others.
