Upload Button Icon Add office photos

Filter interviews by

Sun Life Financial Data Engineer Interview Questions and Answers

Updated 9 Oct 2024

1 interview found

Sort by: Popular

Data Engineer Interview Questions

user image Anonymous

posted on 9 Oct 2024

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

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

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. SQL and Python and Spark related questions
  • Q2. Project-oriented questions
2

Technical Round (2 Questions)

  • Q1. Coding and AWS cloud-related questions like GLUE, LAMBDA, Redshift etc
  • Q2. Project and managerial-related questions

Interview questions from similar companies

Interview experience
3
 Average
Difficulty level
 Easy
Duration
 2-4 weeks
Result
Selected  Selected

I applied via LinkedIn and was interviewed in Aug 2024.

2 Interview Rounds

1

Coding Test Round

One sql and one basic python dict question

2

One-on-one Round (2 Questions)

  • Q1. Questions on big data mostly spark
  • Q2. Project based questions
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

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

4 Interview Rounds

1

Aptitude Test Round

Basic aptitude questions

2

Coding Test Round

Data structure and algorithms

3

Technical Round (1 Question)

  • Q1. Java, SQL questions
4

HR Round (1 Question)

  • Q1. Casual talk about roles

Data Engineer Interview Questions

FactSet user image Saurabh Gupta

posted on 28 Aug 2024

Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

One-on-one Round (1 Question)

  • Q1. PartitionBy vs bucketBy in spark
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

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

3 Interview Rounds

1

Technical Round (1 Question)

  • Q1. Python data types, SQL medium to complex, Spark medium question
2

One-on-one Round (1 Question)

  • Q1. SQL complex, Spark theory
3

HR Round (1 Question)

  • Q1. Basic HR questions

Interview Preparation Tips

Topics to prepare for MassMutual Data Engineer interview:
  • Python
  • SQL
  • Spark
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

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

3 Interview Rounds

1

Case Study Round

They gave a regular problem like using sqllite in the code and using it to get data from a csv file and parse it. I was allowed to use google. They wanted to see how I approach a problem.

2

Technical Round (1 Question)

  • Q1. General questions on work experience, some technical basic questions
3

Be Round (2 Questions)

  • Q1. Asked a lot of situational questions, seemed satisfied with the answers
  • Q2. Why should we hire you? what was the one time you felt like a failure?

Interview Preparation Tips

Interview preparation tips for other job seekers - They dint get back immediately, but the consultancy informed me that they were looking at other candidates and it was a 50-50 situation with my profile.
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Oct 2023.

2 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

Technical Round (6 Questions)

  • Q1. Data Engineering Concepts
  • Q2. Build ETL pipeline on cloud
  • Q3. Writing sql queries to solve the logic
  • Q4. Data Modelling techniques
  • Q5. Performance Optimisation
  • Q6. Data Warehouse implementation

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Current job roles
  • Q2. Data engineering concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Be good prepared with basics
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via LinkedIn and was interviewed in Sep 2023.

4 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

Aptitude Test Round

General Aptitude and behaviour test

3

Coding Test Round

Data wrangling and processing using python data structures

4

Group Discussion Round

Presentation test, describe previous work and motivation

I applied via Campus Placement and was interviewed in Sep 2022.

3 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2

Coding Test Round

2 questions on hackerrank, easy to medium

3

HR Round (2 Questions)

  • Q1. Mostly behavioral , as I was a fresher And applied through college
  • Q2. Few sql question for this role

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice code on leetcode or hackerrank if you are applying through college

Sun Life Financial Interview FAQs

How many rounds are there in Sun Life Financial Data Engineer interview?
Sun Life Financial interview process usually has 2 rounds. The most common rounds in the Sun Life Financial interview process are Technical.
How to prepare for Sun Life Financial Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Sun Life Financial. The most common topics and skills that interviewers at Sun Life Financial expect are ETL, Hadoop, Python, AWS and Github.
What are the top questions asked in Sun Life Financial Data Engineer interview?

Some of the top questions asked at the Sun Life Financial Data Engineer interview -

  1. coding and AWS cloud-related questions like GLUE, LAMBDA, Redshift ...read more
  2. SQL and Python and Spark related questi...read more
  3. Project-oriented questi...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Sun Life Financial interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Sun Life Financial Data Engineer Salary
based on 11 salaries
₹5.5 L/yr - ₹12.6 L/yr
25% less than the average Data Engineer Salary in India
View more details

Sun Life Financial Data Engineer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-Life balance

4.0

Salary & Benefits

5.0

Job Security

5.0

Company culture

4.0

Promotions/Appraisal

5.0

Work Satisfaction

Explore 1 Review and Rating
Process Associate
586 salaries
unlock blur

₹2.3 L/yr - ₹5.2 L/yr

Senior Process Associate
369 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

Analyst Developer
114 salaries
unlock blur

₹7.3 L/yr - ₹19 L/yr

Specialist Developer
101 salaries
unlock blur

₹10.8 L/yr - ₹25.5 L/yr

Development Specialist
87 salaries
unlock blur

₹10 L/yr - ₹24.1 L/yr

Explore more salaries
Compare Sun Life Financial with

HDFC Life

4.0
Compare

ICICI Prudential Life Insurance

4.1
Compare

SBI Life Insurance Company

3.8
Compare

Max Life Insurance

4.1
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