Focus: Background, role fit, career goals.
Expect: Questions about your experience with SQL, Python, ETL tools, Hive, Spark.
Goal: Ensure you meet baseline requirements before technical rounds.
Hive internals: Execution engines (Tez, Spark), ORC vs Parquet, ACID transactions.
SQL Server/Databricks: Partitioning, indexing, performance tuning.
ETL workflows: Incremental loads, error handling, scheduling.
Data modeling: Star schema, SCD implementation in Hive.