I first had an interview with a recruiter to just briefly talk about my career goals. Next was technical interview which was a live coding session with a team member. It was snowflake based and questions on SCDs and other advanced SQL problems emerged.