Questions on SQL were sent through google forms in the first round.
Round 1 - SQL coding questions.
- subqueries, aggregation, date functions, etc
Round 2 - Technical interview
Datawarehousing questions - Star schema, Snowflaking, Dimensional modeling, etc.
and sql questions, Questions on ETL
were asked.
They also expected experience on big data tools.