The interview process varies significantly based on the project you are being recruited for. In my case it was a phone interview followed by an onsite. The phone interview is more of conversation with some technical questions. The onsite one is more hands-on where you have to use the whiteboard.
Interview questions [1]
Question 1
They cover a wide array of questions starting with your knowledge of data architecture (3NF/Star/Snowflake etc.), SQL and ETL. Both interviews will be similar but the Face to Face will go down one level deeper. The questions were pretty generic like what is a star schema, what is a scd 2 dimension. Also the SQL was pretty easy with basic joins and aggregations.