Altogether 5 rounds. 3 Technical round 1 Hiring manager 1 head of HR. Round 1 : Questions related to Spark. 1. Difference between repartitioning & coalesce 2. Disadvantage of coalesce 3. Default number of partitions when reading from HDFS They asked 2 coding questions. 1. Removing duplicate numbers from an integer without casting to String. Example : 1111222233334 -> 1234 2. Finding median on binary search tree 3. One SQL writing. It was easy SQL Round 2 : Interviewer was very cool person. He asked 3 questions. 1. Python code give showed. What are the optimisation you can do here ? 2. 1 SQL question 3. 1 programming question. Something related to Subarray but it was medium difficulty. Round 3: This is again on Data Engineering round. Problem statement related to FW was given and how you can solve them. In depth discussion on it. Round 4: Hiring manager round was pretty cool and friendly round. Pretty much from your resume. Last 15 min on behaviour questions like why leaving company, why freshwork etc. Round 5: Behaviour and cultural fit Questions. Like give me the reasons for each company you left previously apart from financial excuses.