1. Recruiter screening call: basic info, salary expectation
2. 1st Tech round: 1hr round covering resume, introduction, sql- group by, joins, ctes, window functions
3. Tech + Behavioral round with team lead: 1 hr of basic sql + case study + project related questions. Case study as well for the most part to understand problem solving
3. Final round with VP: 1 hr of case study round , no tech questions were asked
Total time taken: 2 weeks
Outcome: They went with another candidate since budget was cut by client