30 minute initial phone interview, high level and to get an idea of your background. Then 2 hour panel interview, 1 hour for technical questions and 1 hour for behavioral questions. The give you a company motive one pager to help you get an idea of the behavior questions they will ask. Technical questions were, what are the different types of slowly changing dimensions. How would improve performance for a SQL query etc.