Applied through referral and got call back in 1 or 2 days from HR. Initial round was with HR and it was usual like "What you know about red ventures","why do you want to work here". Next is a 30 minutes technical interview on phone with the hiring manager. It was mostly on intermediate SQL ,basic spark and more in depth on the projects and experience. Then they called for a 4 hours onsite interview at their SC office. The HR took for a campus tour followed by lunch with the team. Then had technical interviews one with SQL and another whiteboard round with logical questions where you want to write pseudo code for the problem. It is tightly tied with your data structure skills and the interviewer expect you to give an optimal solution for the problem.

First talked with the recruiter, then the hiring manager, then CoWorkers and then the director. Hiring manager asked about projects and 3-4 coding questions and Live coding session about SQL, Python, and Java.