I applied online. I interviewed at Amazon (Canada) in June 2021. I had 1 phone screening interview with basic SQL questions (avg, group by, having) and few questions about my experience. Then after few days I was invited to the virtual loop which consists of 5 rounds of interview. First interview was pure behaviour related questions. all the questions are online or on youtube. Second one was centered around SQL and data modeling, star schema vs snow flake, SCD types and leetcode medium/easy level. After lunch I had an interview with the hiring manager, very general questions about my experience and behavioural questions. Fourth interview was more around how you design a data pipeline, how you scale, monitor etc... Finally the fifth interview was about pure coding, leetcode easy level with few questions about databases, nosql vs sql, relational vs columnar etc... After few days I got an answer.