The interview process was smooth. There were two technical rounds, taken by a lead and an architect respectively. Both were approximately an hour long and focused mostly on data warehousing concepts and advanced SQL queries based on the given data. The third round was managerial cum technical. The whole process took a month from the first round to the offer letter.

1. What questions will you ask the customer about the data?

2. Star and snowflake schema

3. Designing a pipeline where data is continuously changing