HR interview: motivations, leave & join reasons; collaboration with business people; salary expectation Manager interview: conflict and disagreement management; project and time management skills (synergy); salary expectation Technical exercises: Data modelling on Carpool, python coding of an ELT pipeline to load data from API to DB. Technical interviews: Presentation of your work. your modelling logic, pros and cons of different data modelling methods (Kimball, OBT, data vault, according to your choice); Special focus on analysing leg of journeys and trip stops ; difference of append/truncate data & dbt incremental models, when to use different methods; how to handle slowly changing dimensions; your pipeline alerting methods; Schema changes handling (order of columns; new columns etc.); SQL questions based on your answer (window functions etc.) VP data interview: your understanding of the position; disagreement and conflict management; your career planning
