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.
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)
Preguntas de entrevista [1]
Pregunta 1
why Canva, window functions, ask complexity about joins and functions
Me postulé en línea. El proceso tomó 2 semanas. Acudí a una entrevista en Canva (Sídney) en jun 2024
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 1
SQL Windows functions, data transformation (dates, etc).
