Straight forward process that took about 2 weeks. 1st screening with internal recruiter, then brief chat with hiring manager. After that there was a coding interview that lasted 1 hour with both SQL and Python coding questions. Next interview was not with hiring team, but sister team to determine fit. Along with follow up interview from someone on the team being hired for. Final interview was with two people from the hiring team. There were two case studies presented and I was asked to analyze and give my thoughts on different approaches to solve them. While it seemed like a lot of interviews, most of them were straight forward. If you have been working in data warehouse for a few years then there shouldn't be a lot of surprises.