Status: 2Y 7M experience, Tier 2 College
Position: Software Engineer at a product based MNC
Date: Feb 2021

Round 1 - Technical

• SQL Queries (Joins, Group by, Window functions based)
• Query optimization
• Spark and Hive internals
• Project related

Round 2 - Technical

• SQL Queries (Joins, Group by, Window functions based) again yes.
• Spark code of the above queries
• Spark performance improvement and related

Round 3 - Hiring Manager

• Behavioral questions
• Big Data concepts and frequently faced issues
• Use case handling & conflict management

Round 4 - Culture Fit

Total process took two weeks and I got the offer and accepted.