There were total 4 rounds of interview. Technical round R1 based on spark, scala ,hive, SQL queries , Technical round almost same as R2 , Managerial with director and HR
I applied through college or university. I interviewed at GEP (Mumbai) in Aug 2020
Interview
There were 2 rounds first round was appititude about java and sql questions and 2 round was related to coding questions and sql questions
And last round was HR round to discuss salary and expectations
Interview questions [1]
Question 1
Sql question to find out second highest salary
And java question to write count of string