I applied online. The process took 1 week. I interviewed at Canva (Melbourne) in Mar 2022
Interview
After the initial interview with the HR, this is the first technical phase of the interview. With the email, it said there would be data modelling questions but none was asked. Just a hypothetical table and they want you to write some queries over that table using a shared word document. They are lenient on the syntax, rather they want to see you how you are writing sql logically.
The questions were relatively easy but understanding the question is the key.
I applied through a recruiter. The process took 1 day. I interviewed at Canva (Sydney) in Mar 2022
Interview
The First Round -- HR Interview
Not a good experience.
HR didn't ask me for any work experience with data pipelines, like ETL or ELT.
The JD highlights some points about the event-based experience and developing experience for dashboard, but HR didn't talk about it. HR only cares about if I can write SQL.
Very interesting -- HR didn't really look through my work experience with data engineering but just said I sounds like a software developer, not a data engineer. REALLY?!
I failed because I don't have enough knowledge about data warehouse experience. That is something I need to improve, but it is very confusing because Canva provides both roles for data warehouse engineers and data engineers. If they are the same requirements, why don't you just provide one role and name it as warehouse engineer?
Interview questions [1]
Question 1
Can you write complex SQL?
How to decouple large data storage or warehouse?