It was an Average level interview, some basic questions related to Spark and Python were asked and couple of questions were on SQL side,
Performance tuning techniques of spark jobs
Data structure questions in Python
2nd highest employee salary using sql query
Interview questions [1]
Question 1
Optimisation and performance tuning techniques for spark jobs
I applied online. The process took 1 week. I interviewed at Hitachi Digital Services in Jan 2024
Interview
Interview process was smooth, there were 3 rounds in total , first two are technical and third is client round , interview questions were of average complexity , overall process was good and took a week to generate offer letter post negotiations
