I applied in-person. I interviewed at HCLTech (Coimbatore) in Aug 2021
Interview
2 rounds of Techincal Interview and the complexity is easy to moderate. Both rounds happenend on same day and each of 30mins. After technical discussion it took a month to release the offer letter
Interview questions [1]
Question 1
Repartition and Colleasce in spark
Hive tables
SQL window functions
Spark Architecture
I applied through a recruiter. The process took 5 days. I interviewed at HCLTech
Interview
The interview terrible. The interviewer was not prepared and started reading CV in front of me. The vibe was very "I know it all and I can prove that you don't".
Attended Hackathon. given batch, stream pipeline scenario to develop in GCP platform and should find out metrics out of data within 5-6 hours. later based on the results. on the same day, client interview happens.
Interview questions [1]
Question 1
previous year project architecture?
about WIF credentials creation
it was very nice experience. Mosty architectural questions and scenario based coding Sql and pyspark. Spark architecture and conceptual questions. It was not that easy but a nice interview.
2nd round also focus on Project related stuffs along with data modelling and cicd
Interview questions [1]
Question 1
Azure Databricks architectural questions along with coding assessment