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.