I applied in-person. I interviewed at Tavant in Jul 2025
Interview
L1 - video conference
1 hour interview - technical interview questions
1. overall architecture of the project
2. Difference between views and materialized view
3. Describe snowflake schema - I made a mistake about referential integrity. He corrected me
4. 5th highest salary without window function
Interview questions [1]
Question 1
Apart from answering the question they also check your cognitive skills