Ho presentato la mia candidatura online. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso Canva (Melbourne) nel mese di mar 2022
Colloquio
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.
Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso Canva (Sydney) nel mese di mar 2022
Colloquio
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?
Domande di colloquio [1]
Domanda 1
Can you write complex SQL?
How to decouple large data storage or warehouse?