Started with a phone interview with the recruiter.
Then had a coding technical screen which involved one coding interview and a few SQL questions.
The onsite involved the following rounds:
1. OOD interview
2. Advanced SQL interview
3. Culture interview with the Director
4. 2 ETL design interviews