The interviews process was long with around 1-2 week gap between each round, the question were mainly based on data warehouse principle I preped from data warehouse toolkit, designing data intensive application and AWS white papers for their data products (Redshift).