I applied through a recruiter. I interviewed at Genpact
Interview
Very quick interview process in the same day. 1st is technical round of 1hr 15 min which went well sql,pyspark,databricks. 2nd is managerial round where he basically asks questions and wants the listen to the answers he expects, this didn't go well and i didn't like the attitude he carried in the whole interview
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.
