I applied via referal.
They had 2 rounds of technical+ 1 managerial + 1 HR discussion
In first round, I was asked basic things like write a python, Pyspark code to read a csv file and apply some basic transformations and then SQL basic questions. Also some discussion around projects.
In second round it was purely based on my past projects and some big data concepts.
In thisrd round it was typical scenario based questions and some background of projects.
After clearing the 3 technical rounds , HR round was worse..they were giving very very less hike....So made no sense to join this organization.
HR people was also very bad and arrogant. When I asked for decent hike..they were trying to make you uncomfortable and laughing at me .
(HR was too toxic)