I applied online. The process took 3 weeks. I interviewed at Avanade (Toronto, ON) in Aug 2024
Interview
The interview process consisted of a behavioral round and technical discussions. It included questions on Spark, Databricks, and Azure, with a focus on data engineering fundamentals and practical scenarios.
I explained the importance of caching intermediate results, using built-in functions, optimizing shuffle operations, and utilizing Databricks' cluster management features such as autoscaling. I also highlighted the use of Delta Lake for improved storage performance.
Interview questions [1]
Question 1
How would you optimize a large dataset transformation pipeline in Databricks for performance?
Python Leet code
SQL query
1 call with HR about my personality and 1 call more technical about my previous experience and tools I know, how I solve certain problems what is the thought process
I applied online. The process took 4 weeks. I interviewed at Avanade (Calgary, AB) in Nov 2025
Interview
It was good and much easy in the 1st round. 2nd round is little bit hard. Sql and python is must for data engineer interview. Most of the questions are practical based and have 30 minutes coding round.
I applied through an employee referral. The process took 3 weeks. I interviewed at Avanade
Interview
Total Interviews: 4
Timeline: Approximately 3 weeks from start to finish
Interview Format: Behavioral/Experience-based (no technical interviews)
Process Details
The interview process consisted of 4 rounds with no technical assessments or coding challenges. All interviews focused primarily on discussing my previous work experience, past projects, and relevant background.
Interview questions [1]
Question 1
They asked about projects I work on in the past and some behavioural questions.
