Telephonic- Bucketing Partitioning What happens if the file size is more than the memory in driver Spark architecture Basic hive Sql queries Partitioning in spark Coalesce in spark Query execution sequence Second technical- he was very humble to understand my part of work. Mainly about the kind of work i have done in past. SQL scenarios Data warehousing Big data basics Case study on insurance company - how would i store the data what tables should have what columns and how to store them for easy retrieval in big data environment. How to read xml files Diff xml and json files Managerial- it ws a basic QnA HR-normal HR discussion . Nice experience over all

I had applied for big data role so mainly questions were asked on concepts of spark optimization techniques, SQL queries, hive file formats, Spark configuration, Python, Projects you have worked on which includes academic project as well. Be confident with your answers