The interview consists of 3-4 rounds after the recruiter call:
1. SQL Test: Usually 6 questions in 60 minutes. Emphasis on aggregation functions, joins, subqueries, window functions, date-time functions. Medium difficulty
2. Hiring manager: Consists of technical questions, questions on resume, behavioral, etc.
3. Case round: Optional
4. Client round: Depends on client requirement. Recruiter/Hiring manager will usually inform you about it