Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Canva nel mese di mar 2022
Colloquio
1. Initial phone screening with HR
2. SQL pair programming interview
3. Final interview consisting of three 45 minute technical interviews (Python, SQL, System Design) and one 45 minute behavioural interview
The whole process (from the initial call to receiving the offer) took 4 weeks in total.
Domande di colloquio [1]
Domanda 1
How could you re-write this SQL statement to make it more efficient?
How would you scale this system to handle a large number of users and TBs of data?
Round 1: phone screen, (if your experience matches their needs + value)
Round 2: Advanced SQL (1 hour)
Round3: python with AI + system design + behavior + modelling (3.5h - 4h, can be divided into 2 different days)
Domande di colloquio [1]
Domanda 1
why Canva, window functions, ask complexity about joins and functions
Recruiter screening followed by 1st tech interview (SQL) and then 2nd round of 4 interviews (Data modeling, system design, Python, and behavioral). Overall very positive experience and good communication throughout.
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Canva (Sydney) nel mese di giu 2024
Colloquio
First phase is the Recruiter chat, the second phase is a SQL test, and the final step is a 4-hour interview (sql, python, design, and culture).
I had a working break, so it was hard to get my brain back to the quick problem solving, but everyone was extremelly patient and HR provided an extensive feedback after the final interview.
Domande di colloquio [1]
Domanda 1
SQL Windows functions, data transformation (dates, etc).
