My interview (3 rounds) went well, but I got rejected after the onsite round. The recruiter didn't give any reason for the rejection. I was expecting a positive result.
1st round was more on my resume.
2nd was more technical - leetcode hard sql, data modelling, data warehousing concepts
3rd round (onsite) - 4hours LP, 1 hour for sql (leetcode medium), data warehousing concepts, performance tuning, strategies on how to select a design for data modelling