Upload Button Icon Add office photos

Sun Life Financial

Compare button icon Compare button icon Compare

Filter interviews by

Sun Life Financial Data Engineer Interview Questions and Answers

Updated 9 Oct 2024

Sun Life Financial Data Engineer Interview Experiences

1 interview found

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

I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

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

(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 Questionnaire 

2 Questions

  • Q1. Basic javascript.. closures,hoisting, es6 features etc
  • Q2. Prototype in JavaScript
  • Ans. 

    Prototyping in JavaScript allows for quick and easy creation of new objects and functions.

    • Prototyping allows for inheritance and sharing of properties and methods.

    • New objects can be created using the 'new' keyword and the prototype of an existing object.

    • Functions can also be prototyped to add new methods or properties.

    • Example: function Person(name) { this.name = name; } Person.prototype.greet = function() { console.log...

  • Answered by AI

Skills evaluated in this interview

I applied via Referral and was interviewed before Jan 2020. There were 6 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. What is amortization?
  • Ans. 

    Amortization is the process of spreading out a loan into smaller, regular payments over a period of time.

    • It is used to pay off a debt over time with regular payments

    • Each payment includes both principal and interest

    • The amount of interest decreases over time as the principal is paid off

    • Examples include mortgages, car loans, and student loans

  • Answered by AI
  • Q2. What is WASO, TSO and EPS?
  • Ans. 

    WASO is Wake After Sleep Onset, TSO is Total Sleep Time, and EPS is Earnings Per Share.

    • WASO is the amount of time spent awake after initially falling asleep.

    • TSO is the total amount of time spent sleeping, including both REM and non-REM sleep.

    • EPS is a financial metric that represents the portion of a company's profit allocated to each outstanding share of common stock.

    • WASO and TSO are commonly used in sleep studies, whi

  • Answered by AI
  • Q3. What are the elements which are present in all the financial statements like BS,IS and CF.
  • Ans. 

    The financial statements (BS, IS, CF) have common elements such as assets, liabilities, equity, revenue, expenses, and cash flows.

    • Assets: resources owned by the company

    • Liabilities: obligations owed by the company

    • Equity: residual interest in the assets of the company

    • Revenue: income generated by the company

    • Expenses: costs incurred by the company

    • Cash flows: inflows and outflows of cash

  • Answered by AI
  • Q4. What is the effect of stock split on market capitalisation of a company?
  • Ans. 

    A stock split increases the number of shares outstanding and decreases the price per share, but does not affect the market capitalisation.

    • Stock split does not affect the total value of the company

    • Market capitalisation remains the same after a stock split

    • Stock split increases the number of shares outstanding and decreases the price per share

    • For example, if a company has 1 million shares outstanding and the stock splits ...

  • Answered by AI
  • Q5. Components of Cash flow statements?
  • Ans. 

    Cash flow statements have three main components: operating activities, investing activities, and financing activities.

    • Operating activities: cash inflows and outflows from the company's core business operations.

    • Investing activities: cash inflows and outflows from buying or selling long-term assets.

    • Financing activities: cash inflows and outflows from borrowing or repaying debt, issuing or buying back stock, and paying di...

  • Answered by AI
  • Q6. How is EPS caluclated?
  • Ans. 

    EPS is calculated by dividing the company's net income by the number of outstanding shares.

    • EPS = Net Income / Outstanding Shares

    • Net Income is the company's total earnings after expenses and taxes

    • Outstanding Shares are the total number of shares issued by the company

    • EPS is an important metric for investors to evaluate a company's profitability

    • Higher EPS indicates better profitability and potential for higher dividends

  • Answered by AI
  • Q7. About your last company and role? Why you want to leave the company?
  • Q8. Abou the role,. Any info on the role that you are applying?

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through the financial statements. Check all ratios with respect to statements. Be clear about the job profile. Read about the company.

Skills evaluated in this interview

Interview Questionnaire 

8 Questions

  • Q1. Find a number which occurs odd number of times and all number occurs even number of times
  • Ans. 

    Find an odd occurring number among even occurring numbers.

    • Use XOR operation to cancel out even occurring numbers and get the odd occurring number.

    • Iterate through the array and XOR each element with the result variable.

    • The final result will be the odd occurring number.

  • Answered by AI
  • Q2. Some discussion about my minor project
  • Q3. Spiral order of binary tree and mattrix, print it
  • Ans. 

    Print the spiral order of a binary tree and matrix.

    • For binary tree, use level order traversal and alternate direction for each level.

    • For matrix, use four pointers to traverse in spiral order.

    • Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9

    • Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13

  • Answered by AI
  • Q4. Some question about os,dbms
  • Q5. Find pair which have a given sum in a given array
  • Ans. 

    Finding pairs in an array with a given sum.

    • Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.

    • Use a hash table to store the elements of the array and their indices for faster lookup.

    • If there are multiple pairs with the same sum, return any one of them.

    • If no pair is found, return null or an empty array.

  • Answered by AI
  • Q6. Find total number of k element which have a given avg in a given array in minimum time complexity
  • Ans. 

    Find total number of k element with given avg in an array in minimum time complexity.

    • Use sliding window technique to traverse the array in O(n) time complexity.

    • Maintain a sum variable to keep track of the sum of elements in the window.

    • If the sum of elements in the window is equal to k times the given avg, increment the count.

    • Move the window by subtracting the first element and adding the next element in the array.

  • Answered by AI
  • Q7. Print all elements which in not boundary element in a given binary tree
  • Ans. 

    Printing non-boundary elements of a binary tree

    • Traverse the tree in any order (preorder, inorder, postorder)

    • Check if the current node is not a boundary node (not the first or last node in its level)

    • If it is not a boundary node, print its value

    • Recursively traverse its left and right subtrees

  • Answered by AI
  • Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question

Interview Preparation Tips

Round: Test
Experience: practice codes on paper
Tips:

Round: Technical Interview
Experience: very good
Tips: please try to explain each and every question in detail

Round: Technical Interview
Experience: my hr round is not taken by them,and some of face 3rd round ,which is HR
Tips: please prepare all types of problem from geeksforgeeks

Skill Tips: please try to understand every problem from geeksforgeeks
Skills: ds
College Name: NIT Bhopal
Motivation: best work culture,and a lots of learning opportunity in this company,and in every 6 month there is a appraisal

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: There were 15 questions from quant’s, 10 questions from data interpretation with 1 mark each and -.5 for wrong answer also there were 2 case studies with 10 marks each with no –ve marks. Total 45 marks question, I did only 9 from quant and 7 from DI total 16 out of 25 questions and didn’t touch case studies. Quanta and DI were very basics level.

In those 16, 1 question was wrong so basically I did 14.5 out of 45, but with a accuracy of 90%. Didn’t expect to get shortlisted but was very tensed and angry upon myself coz it was my level paper. But around 12 mid night shortlist came and I was at 11th position out of 31 students in the list.

There were total around 90 students who appeared for written test. They allowed Mtech and Mca guys not Btech.
Total Questions: 25

Round: TECHNICAL INTERVIEW
Experience: I went there and greeted him. Firstly he told me to introduce myself, later he asked what I like the most. I told analytical thinking and logical reasoning and yeah I relate it with data base.(since I knew they came for Data analyst profile).

He asked me about join, gave me a table and told me to perform all joins. I did that and he asked me about Order by clause and, having clause then asked me normal forms up to bcnf.

Later asked about pl/sql difference b/w sql and pl/sql, what is trigger explain in detail. Some basics questions of DBMS theory asked me about my 2 projects and at the end he gave me a situation where I have a grocery shop outside nit Surathkal, and from last few days/months I realized a downfall in sales, what possible reasons could I find? I gave him 8 reasons within 2/3 mins. He was impressed…

After 1st round out of 31 only 13 were selected and I was there in d list.

Round: TECHNICAL INTERVIEW
Experience: As soon as I entered the room, mam told me “Ooo tum aao aao ”. I smiled because I was the 1st guy during presentation who asked the first question (she made every1 clap for me there) and she remembered my face. And eventually she did study from IIT Kanpur so yes she was able to speak fluent Hindi (plus point for guys like me :p). with her there was a guy he asked me to write code for taking a no and converting it into binary and 1 question from array- very simple later she gave me a table with employee id, order date and order amount. A customer can place max 1 order in 1 day. I had to find the latest transaction of every customer with amount as well. i did it using max function over date and group by with sub query, she asked me about my resume at the end she gave me 7,9,21,63,100 and told me to find the no of numbers between 1 to 50000 which are exactly divisible by all, i did it in 1 min.

but she was smiling, I thought I made some mistake in hurry, then I asked mam m I doing right or wrong (in curiosity as I find very comfortable there) she smiled and said “Chalo bhago ynha se ye interview h ”.I said sorry but yeah she was impressed with my interview so told ki “you will learn all these things very quickly”.

Round: TECHNICAL INTERVIEW
Experience: After 2nd round 9 were selected and I was one of them. It was basically a Managerial round and it scheduled over Skype. I had to introduce myself as well as my family background. Here comes the harder part when he asked me why you have such a poor academic back ground? I was speechless for a moment but I started telling the truth.

I told despite getting 68% marks in my 10th I was the third topper of my class. I got 60.66 % in 12th but yeah there also out of 700 students only 14 got first division. So basically I concluded that in my state board marking is not that much good. He said ok but what happened in graduation(64%) when you studied in Delhi?(what to say now :p) I said sir I did it from IGNOU and you can Google the fact that even less than 5% of student are able to clear the degree in 3 years. Later I explicitly mentioned that I m not blaming my boards but this is the fact which can’t be change.

Now He asked what happened in PG here also you scored only 7.50 CGPA which is less than even standard score of 8(Meri to jaan hi nikal gayi :p). Then I told him that sir u can see my pointer in first semester is very less close to 6.5 but after that I constantly improved myself. He was smiling …..

He asked me about my family background and then I told him how I struggled, I was giving tuition in my grads to continue my education and after grads took a gap of 1 year and cleared all MCA entrance examination and now sitting in front of him.

Later asked about my best qualities….i told him that I can lead group of people very well. I gave example of me being captain of my department cricket team and I was class monitor through 3rd to 12th std and also some stuff regarding my college events. He noted down something .I don’t know what.

I was not sure that I could clear that interview. When the result came they called all 9 students and said that they find is difficult to eliminate 4 names .i was sure that I m out of picture now but fortunately my name was at 2nd position. Wowwwww

Round: HR Interview
Experience: It was telephonic round and just my hobbies and all, he asked me about my poetry writing hobby as well as Hindi Shayaris. I was told to recite 1 …when he listened, he was very impressed…

College Name: IIT KANPUR

I appeared for an interview in Oct 2016.

Interview Questionnaire 

4 Questions

  • Q1. Select any five companies you would invest in and why given the required metrics.
  • Ans. 

    I cannot provide investment advice, but here are five companies that have shown strong financial performance in recent years.

    • Apple - consistently high revenue and profit margins

    • Amazon - dominant player in e-commerce and cloud computing

    • Microsoft - strong growth in cloud computing and enterprise software

    • Alphabet (Google) - diversified revenue streams and strong advertising business

    • Visa - dominant player in the payments i

  • Answered by AI
  • Q2. Questions based on case study.
  • Q3. Detailed discussions on the indian economy?
  • Q4. Brexit vote and how it would effect the indian economy?
  • Ans. 

    The Brexit vote could have both positive and negative effects on the Indian economy.

    • Positive effects: Increased trade opportunities with the UK, potential for attracting foreign investments from companies relocating from the UK.

    • Negative effects: Uncertainty in global markets leading to volatility in exchange rates, potential decline in exports to the UK.

    • Example: Indian IT companies may face challenges due to stricter i...

  • Answered by AI

Interview Preparation Tips

Round: Case Study Interview
Experience: We were first taught the basics of operations involved in working with an investment bank. Based on the workshop we were given a case study with a list of companies to select the one's which are potencial candidates for investments. We were all divided into groups of 5 students.

Round: Test
Experience: The test was basic. Economical aptitude requires prior knowledge of economics concepts. The review topicwas GST bill.
Duration: 1 hour
Total Questions: 41

Round: Stress Interview
Tips: It is important to be aware about the current events and economies.

Skills: Economic Affairs, Financial Economics, Knowledge On Current Affairs
College Name: Thapar University, Patiala

I applied via Campus Placement

Interview Preparation Tips

Round: Resume Shortlist
Experience: My resume had a couple of projects and a paper publication added to it, which was a part of my second year intern at TCS Innovation Labs.

Tips: I believe that the resume shortlist to appear for the test is just a formality and not a big deal to get through. Most of the students are allowed to appear for the test which is where, the main shortlisting occurs.
Although, the company does cut off people from certain departments. For example, none of the Agriculture and food engineering students were shortlisted for appearing for the test.
Also, from what I have heard, the company runs resumes through a program to take out the shortlist. Hence, certain key words such as "Scholar" or "Conference" may get you a good chance to get through the shortlisting.

Round: Test
Experience: The test is mainly quant based and how fast you can think and rationalize. They expect excellent speed; they ask you 20 questions to be answered in 30 minutes.
Tips: Normally, if a student is asked to appear for this right after his JEE examination, he would be able to get through it easily. But since our analytical thinking goes way down once we actually get in, it has to be worked upon again. I'd suggest you to solve all the quant questions of any CAT preparatory book for the American Express test. The test questions are quite similar to those that the CAT students prepare for.

Round: Technical Interview
Experience: In general, the American Express interviews are considered to be pretty peaceful compared to the interviews of other companies. I was just asked about my work at TCS Innovation Labs and the paper I would be publishing based on that work and the courses I have done in Data Analytics and what all do I know in it. They do not test the knowledge you say you possess.
Tips: While I was preparing for my interview, I was told to read about Amex and its products. Secondly, and most importantly, I was aksed to read a lot about credit card frauds and suggest ways of preventing that. Even during my time, a lot of people were asked about this and judged severely on that. This is a must must if you would be appearing for its interview.

Also, you would do well if you are able to connect with the interviewer. For instance, if both of you have been a part of the same inter IIT or have the same tastes, etc.

Also, the interviews are that peaceful that you are able to direct the interview in your favour. There are certain parts of your CV that you can easily talk about and certain parts that you would want to avoid. If you are able to think on your feet, it is easy to re direct the interview in your favour and the things that you would like to talk about; in my case, it was my work at TCS.

Round: Puzzle Interview
Experience: The main decision whether you have to be taken in or not is decided in your first round of interview after which, the puzzle interview is just a formality and to find out whether you are able to think on your feet or not. Not a big deal, pretty easy.
Tips: Nothing to be worried about, the puzzles asked are pretty easy and most probably, you would have already heard them if you have a nag of solving puzzles.

General Tips: Do not worry or stress yourself much. The interview is pretty easy if you have an edge in the skills that the company wants. I had started studying Data Analytics in my second year summer vacations, just 1 hour a day for hardly about a month. Which gave me enough of an edge. The main hurdle lies in getting through the test round where about 300 people are simply cut off.
Skill Tips: You should be able to code efficiently. Knowledge in Python and SQL is a big plus.
Also, I had done a course on Coursera called "Machine Learning" of Stanford University. Today, the company does not expect a lot of knowledge in Data Analytics from students which is why this course gave me the edge I needed to get through the interview. It's a pretty easy course and not very demanding. I would recommend this if you want to find out even whether you'd be interested in Data Analytics or not.
I was asked about the things I know and whether I have ever implemented them.
Skills: Analytics And Coding
Duration: 2
College Name: IIT Kharagpur
Motivation: American Express is known to have a good working culture and is currently the third best company to work for in India. The internship stipend is largest compared to any other company in India along with accommodation and travel. The company has a well structured internship program and also has good challenging work to offer.
Funny Moments: After the test, I was not shortlisted for the interview round.. Which broke my heart.
Just after the presentation, I walked up to the person presenting and handed him a hard copy of my resume asking him to at least give me a shot at the interview if they think my profile is good enough.
I believe that this was a turning point of this entire experience. I believe, at that moment itself, I gained their favour to take me in. Which is probably why my interview was peaceful, which is probably why I could get through even though my interview was the last among a bunch of 25 students..

Interview Questionnaire 

1 Question

  • Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.

Interview Preparation Tips

Round: Test
Experience: Practice questions on Indiabix.

Round: Technical Interview
Experience: Operating Systems basics, Dbsa basics

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Make sure you do a course on object oriented programming
Skills: C, Sql, Java
College Name: BITS PILANI
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1. Explain SCD Type 2 Implementation in Informatica
  • Ans. 

    SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

    • SCD Type 2 maintains a separate row for each change in data, with a start and end date.

    • It requires a surrogate key to uniquely identify each row.

    • Informatica provides a built-in SCD Type 2 transformation to implement this technique.

    • Example: tracking changes in customer addresses over time.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Kindly focus on basic BI terminologies, common to trivial scenarios and introductory information on latest trending tools and technologies.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Frequency of each word ina sentence
  • Ans. 

    To find the frequency of each word in a sentence.

    • Split the sentence into words

    • Create a dictionary to store word frequency

    • Iterate through the words and update the dictionary

    • Return the dictionary

  • Answered by AI

Skills evaluated in this interview

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.

Sun Life Financial Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
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

5.0

Job security

5.0

Company culture

4.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Process Associate
577 salaries
unlock blur

₹2.2 L/yr - ₹5.2 L/yr

Senior Process Associate
370 salaries
unlock blur

₹3.2 L/yr - ₹6 L/yr

Analyst Developer
120 salaries
unlock blur

₹7.8 L/yr - ₹18.6 L/yr

Specialist Developer
102 salaries
unlock blur

₹11 L/yr - ₹26 L/yr

Development Specialist
86 salaries
unlock blur

₹10 L/yr - ₹24.1 L/yr

Explore more salaries
Compare Sun Life Financial with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

Citicorp

3.7
Compare

American Express

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview