I applied online. The process took 2 months. I interviewed at Genpact (Richardson, TX) in Dec 2021
Interview
Applied online and was called for the first round of the interview, it was more of technical questions about Data Engineering and Cloud. Second round was with the hiring manager and was again asked to design end to end data engineering infra on cloud. I was told by the recruiter that I got the role, but they took forever to give me an offer.
Interview questions [1]
Question 1
Design end to end data engineering infra on cloud, specifically for a simple ETL task.
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.