I applied online. The process took 2 weeks. I interviewed at Scotiabank (Toronto, ON) in Apr 2023
Interview
Two Rounds 1. Resume Shortlisting 2. HR Screening - Asked general questions, and earliest start date, Salary discussion, Work Locations, etc.., 3. Technical Interview - Python & SQL Problem Solving 4. Final results
Interview questions [1]
Question 1
Python 1. How to remove duplicates 2. Words frequency in a dictionary 3. Multiple Constraints based dictionary questions SQL 1. Find the time between next station for a train
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.
Questions about:
- Data Warehousing & Databases:
- Big Data & Distributed Systems
- Cloud Platforms
- ETL/Orchestration Tools
- Behavioural & Situational Questions
- System Design and Case Study
Interview questions [1]
Question 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
I applied online. The process took 3 months. I interviewed at Scotiabank (Bogota, Cundinamarca) in Nov 2024
Interview
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