Ho sostenuto un colloquio presso Scotiabank (Toronto, ON)
Colloquio
First round with 3 interviewers: they asked about behaviour question, simple SQL queries, and translate the sql to pyspark. Second round with 3 interviewers as well: behaviour questions and medium sql questions.
Domande di colloquio [1]
Domanda 1
how to find the second highest salary given the table structure
Ho sostenuto un colloquio presso Scotiabank (Toronto, ON)
Colloquio
It was quite straightforward. Didn't receive any technical questions--mostly behavioural related to my past experiences. They wanted proficiency in SQL, Python, and PowerBI. I hadn't done much PowerBI before, but it was chill.
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Scotiabank
Colloquio
Questions about:
- Data Warehousing & Databases:
- Big Data & Distributed Systems
- Cloud Platforms
- ETL/Orchestration Tools
- Behavioural & Situational Questions
- System Design and Case Study
Domande di colloquio [1]
Domanda 1
Tell me about yourself.
Why are you interested in this Data Engineer role?
Describe a challenging data engineering project you worked on. What were the obstacles, and how did you overcome them?
and Technical questions
Ho presentato la mia candidatura online. La procedura ha richiesto 3 mesi. Ho sostenuto un colloquio presso Scotiabank (Bogotá, ) nel mese di nov 2024
Colloquio
La persona a cargo fue muy amable fue una entrevista con la reclutadora, otra entrevista con el que seria mi jefe directo y alguien del área de datos, aunque los tiempos de espera entre entrevista y resultados eran muy largos
