I was given situations (technical questions) and would be asked how I would solve it using logic (SQL logic, or whatever programming logic is related) and About Yourself/Experience type of questions.
Interview questions [1]
Question 1
*provided with a situation wherein you would have to retrieve data from tables provided to you* explain how you would get the requested data using SQL logic
3 rounds
First one is basic HR questions with a recruiter
Second one is with a Director of Reporting Team - Spark Shuffling, Databricks related questions.
Third round is with 3 team members, deep dive into technical projects, Delta table optimizations and sql query optimization
Interview questions [1]
Question 1
Tell me about a time where you had to optimize a sql query and how did you do it