Applied through Career's page. Took a long time to schedule an interview.
There were 3 rounds of interview.
Technical Round:-
1 hour interview on Teradata and Snowflake concepts.
Scenario based questions were asked
Queries were asked
DWH concepts
Next round Managerial round:
An hour devoted to entire business outlook.
How business wants the data and how you are entitled to deliver it.
What's needed to set and shut a working warehouse
Entire flow explanation
Modelling concepts
HR round:-
Common questions
All the best if you get chance to showcase your skills.