Comprises of three rounds- 1. Tech discussion 1 - Go through a live coding interview of SQL and basic python scripts. Relatively simple and DB independent SQL questions to critical thinking scenario questions Python scripts from basic to intermediate level code snippets or logic explanation behind the code Concepts related to DB architecture, ETL architecture and Data warehouse architecture asked. 2. Tech 2- Mostly Scenario related DWH and data modelling asked. Scenario could be more related to usage of various types of dimensional modelling. MPP db architecture related questions and there advantages 3.Managerial - Behavioural questions to see how much you fit to the role and some technical overview of work history. Overall it was a very good experience, panels are very patient and would encourage you time to time to keep on thinking of solutions to open ended questions.