I was initially contacted by a recruiter after applying through their platform. The interview process consisted of four rounds:
Recruiter Call
Online SQL Coding Assessment
This round included three challenging SQL queries, which I had to solve within a three-hour time limit.
Hiring Manager Round
This interview focused on my resume skills, with discussions around my experience. The interviewer asked basic questions about ETL services on AWS, data stores like DynamoDB, RDS, and S3, and the fundamentals of data warehousing. We also went through the projects listed on my resume, followed by basic probability questions.
Round with the Chief Engineering Officer
This round was more about understanding use cases and explaining how I would approach designing solutions for them.