Two technical rounds and one managerial round. The questions were tricky and involved practical scenarios. The interviewer mostly focused on topics: Spark, Hive, Oracle, Java, Confluent, Spark Streaming, Airflow, YARN, cloud concepts, and Pig.

How to remove header and footer from text files using Spark.

How to handle skewed data in Spark.

Vectorization in Hive and how it enhances performance.

How to perform Change Data Capture using Sqoop incremental imports.

Map-side joins in Spark, and their limitations.

Difference between cache and broadcast in Spark.

Is updating or deleting individual records possible in Hive external tables?

How to create arrays and structs in Hive tables and how to access them.

Spark architecture and Spark job execution phases.

Complex Oracle queries, mainly on window functions.

Questions on object-oriented programming languages like Java and Scala.