Upload Button Icon Add office photos

Filter interviews by

Loblaw Senior Data Engineer Interview Questions and Answers

Updated 15 Oct 2023

1 interview found

Sort by: Popular

Senior Data Engineer Interview Questions

user image Anonymous

posted on 15 Oct 2023

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via LinkedIn and was interviewed in Sep 2023.

3 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2

HR Round (1 Question)

  • Q1. Usual HR round with getting to know expereinces and explain the role and next steps
3

Technical Round (2 Questions)

  • Q1. 4-5 SQL Questions
  • Q2. Python Alogirithm Leetcode style

Interview questions from similar companies

Interview experience
4
 Good
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
 No response

I applied via Naukri.com and was interviewed in Nov 2024.

1 Interview Round

1

Technical Round (6 Questions)

  • Q1. Can you introduce yourself and describe your current project experience?
  • Q2. Decorators in python
  • Q3. What is the SQL query to group by employee ID in order to combine the first name and last name with a space?
  • Q4. What are constructors in Python?
  • Q5. Indexing in sql
  • Q6. Why spark works well with parquet files?

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Nov 2024.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. All questions based on databricks and some pyspark , python , SQL only.
  • Q2. Learn windows function implementation in databricks note book.
2

HR Round (1 Question)

  • Q1. This round about your salary discussion around.

Interview Preparation Tips

Topics to prepare for Accenture Senior Data Engineer interview:
  • Python
  • Pyspark
  • SQL
  • Databricks
Interview preparation tips for other job seekers - Please prepare for pyspark, python , SQL , databricks for practice to switch your job to big data engineer
Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Sql query to write max salary
  • Q2. What is dense rank in sql
2

Technical Round (2 Questions)

  • Q1. What is spark cluster
  • Q2. How hive works in hdfs

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I was interviewed in Aug 2024.

3 Interview Rounds

1

Coding Test Round

Python and sql tasks

2

Technical Round (2 Questions)

  • Q1. Project related questions
  • Q2. Coding questions on pyspark windows
3

One-on-one Round (1 Question)

  • Q1. Managerial discussions, mostly in and around the previous projects
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I was interviewed in Sep 2024.

1 Interview Round

1

Technical Round (3 Questions)

  • Q1. Coding in pyspark
  • Q2. Databricks optimisation technique
  • Q3. Aqe details in databricks

Skills evaluated in this interview

Senior Data Engineer Interview Questions

Cognizant user image Manoj Karan Singh

posted on 26 Oct 2024

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed in Sep 2024.

1 Interview Round

1

Coding Test Round

Spark Optimization, Transformation, DLT, DL, Data Governance
Python
SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Ingestion, Integration, Spark, Optimization, Python, SQL, Data Warehouse
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in May 2024.

2 Interview Rounds

1

Technical Round (1 Question)

  • Q1. All medium level theory and SQL, python/pyspark code.
2

Technical Round (1 Question)

  • Q1. More in detail about tools and technologies, project handling, agile, CICD, scenario based.
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 -

I applied via LinkedIn and was interviewed in Feb 2024.

3 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. How to work with nested json using pyspark
  • Q2. How to implement scd2 step by step
2

Technical Round (2 Questions)

  • Q1. Write a SQL query to select data from table 2 where data exists in table 1
  • Q2. After performing joins how many records would be retrieved for inner, left, right and outer joins
3

HR Round (1 Question)

  • Q1. About previous company and reason for leaving

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't be afraid of giving interviews. Prepare well attend confidently if you clear it's an opportunity if you don't it's an experience!!

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Recruitment Consulltant and was interviewed in Mar 2024.

2 Interview Rounds

1

One-on-one Round (1 Question)

  • Q1. How the files will be read in AWS GLUE
2

Technical Round (2 Questions)

  • Q1. How to get duplicate records
  • Q2. How to get the second highest salary

Skills evaluated in this interview

Loblaw Interview FAQs

How many rounds are there in Loblaw Senior Data Engineer interview?
Loblaw interview process usually has 3 rounds. The most common rounds in the Loblaw interview process are Resume Shortlist, HR and Technical.
What are the top questions asked in Loblaw Senior Data Engineer interview?

Some of the top questions asked at the Loblaw Senior Data Engineer interview -

  1. Usual HR round with getting to know expereinces and explain the role and next s...read more
  2. Python Alogirithm Leetcode st...read more
  3. 4-5 SQL Questi...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Loblaw interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Compliance Manager
3 salaries
unlock blur

₹12 L/yr - ₹22 L/yr

Explore more salaries
Compare Loblaw with

TCS

3.7
Compare

Accenture

3.9
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview