AmbitionBox
Search
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Sun Life Financial Data Analytics Lead Interview Questions and Answers
Updated
30 Sep 2023
Sun Life Financial Data Analytics Lead Interview Experiences
1 interview found
Anonymous
Interview experience
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-
I applied via Approached by Company and was interviewed in Aug 2023. There was 1 interview round.
Round 1 - Technical
(2 Questions)
- Q1. How would you gather requirements from a client?
- Ans.
I would gather requirements from a client through interviews, surveys, and workshops.
Schedule interviews with key stakeholders to understand their needs and expectations.
Distribute surveys to gather feedback from a wider audience.
Conduct workshops to brainstorm ideas and clarify requirements.
Document all gathered requirements in a clear and organized manner.
Regularly communicate with the client to ensure alignment thro
- Q2. Tableau Dashboard performance issues solving.
Answered by
AI
Add your answer
Add your answer
Interview Preparation Tips
Topics to prepare for Sun Life Financial Data Analytics Lead interview:
- Consulting
- Tableau
- SQL
- Excel
Interview questions from similar companies
Interview Questionnaire
2 Questions
- Q1. Questions about career goals, interests and future prospects
- Q2. Firm-related questions
Add your answer
Add your answer
Interview Preparation Tips
Round: HR Interview
Experience: 1. At First, I missed the Credit Suisse GD since I hadn’t brought along a portfolio manager (one who handles your interview schedule and attends to the ever-ringing mobile phone).
2. I proceeded to Credit Suisse, and requested their HR contact to give me a chance since I could not turn up for the GDs.
3. It was here that I handed over my mobile phone to my friend Apratim Tiwari, who was managing the Credit Suisse procedures, and requested him to pursue the HR guy to schedule an interview, and also handle my phone when I was interviewing and he had successfully managed to get me an interview with Credit Suisse.
4. The interview went well. They were apparently quite impressed.
5. Two more rounds of interviews, and the HR guy made me an offer.
6. But, since Deutsche Bank was my dream company, I was also interviewing with them and got selected.
Tips: You would need to focus on three broad areas for a comprehensive preparation:
(a) HR questions: This is the most important part for any interview. In companies like DB, your communication skills coupled with your preparation of such questions account for more than 70% of a candidate’s selection. Answering questions about your career goals, interests, and your career thus far should become second nature by the end of November. You must also know the firms and job profiles inside out. I worked on this specific area, and by the end of the placement session, I had gained a reputation among my wingies for my expertise at answering HR questions.
(b) Puzzles: Since this is a non-core sector, puzzles are the only way to objectively test the ability of candidates with diverse backgrounds. Look up braingle.com and techinterview.org. These two should suffice. Also, whenever you come across a puzzle that you’ve already encountered, pretend as if you’re going through it for the first time. Don’t rush through. This is your opportunity to impress them. Do not squander it away!
(c) Finance and economic affairs: If you have a comprehensive knowledge of the financial markets, national economy, and international affairs, in addition to the above two, it is highly improbable that you won’t be selected. For brushing up these, read the Economist (print or online), and read through the opinion pages of Economic Times or the Business Standard for 2-3 months leading to the Placement season. You must also regularly read a newspaper like the Hindu or Indian Express to keep yourself abreast of the latest events which frequently become a focal point of group discussions (for Credit Suisse). You CANNOT afford to walk into the interview ignorant of terms like European debt crisis, global financial crisis, fiscal cliff, QE, and basic finance like options, hedging etc. Wikipedia, Investopedia and J.C.Hull (first few chapters) are great sources to pick up these.
General Tips: 1. If you are a B.Tech. student, do not be under the wrong impression that you can target all sectors- core as well as non-core. It is really difficult to prepare comprehensively for all companies, especially if you are in the B.Tech. program owing to time constraints.
2. The Dual degree students have an edge over you for precisely two reasons. Firstly, they get more time to prepare for the placements, and have learnt vicariously from their B.Tech. batchmates' experiences. Secondly, they tend to have higher retention rates (good for the companies).
3. Work on your English communication skills which are crucial for performing well in interviews and GDs.
Let neither of these become an obstacle by leaving no stone unturned in the course of your preparations.
4. You can’t appear for more than 4 companies in the first slot. It is not realistic. Hence, decide beforehand. I knew I hadn’t prepared enough for consulting or core, hence I opted out of ITC and Opera.
5. If you are shortlisted in multiple companies, ask a reliable friend to accompany you to the interviews, and handle your mobile phone (“managing one’s portfolio”). You’ll thank me someday for this advice.
6. I was happy that I prepared as much as I did, neglecting my college academics in the process. It is a decision I am proud of.
7. My Morgan Stanley internship distinguished me from scores of other candidates. I had never truly appreciated its importance till then. That also goes to show how important it is to get a good internship.
Skill Tips: 1. I scored a 100 percentile in CAT and the preparation made a huge impact on preparing for any of the interviews.
2. I also interned at Morgan Stanley which was further a plus for me.
3. I had received Honda YES Award, University of Tokyo-IIT Scholarship and my academic background was quite good.
Skills: Problem solving skills, Finance Basics, Basic HR questions, Economic affairs
College Name: IIT KANPUR
Experience: 1. At First, I missed the Credit Suisse GD since I hadn’t brought along a portfolio manager (one who handles your interview schedule and attends to the ever-ringing mobile phone).
2. I proceeded to Credit Suisse, and requested their HR contact to give me a chance since I could not turn up for the GDs.
3. It was here that I handed over my mobile phone to my friend Apratim Tiwari, who was managing the Credit Suisse procedures, and requested him to pursue the HR guy to schedule an interview, and also handle my phone when I was interviewing and he had successfully managed to get me an interview with Credit Suisse.
4. The interview went well. They were apparently quite impressed.
5. Two more rounds of interviews, and the HR guy made me an offer.
6. But, since Deutsche Bank was my dream company, I was also interviewing with them and got selected.
Tips: You would need to focus on three broad areas for a comprehensive preparation:
(a) HR questions: This is the most important part for any interview. In companies like DB, your communication skills coupled with your preparation of such questions account for more than 70% of a candidate’s selection. Answering questions about your career goals, interests, and your career thus far should become second nature by the end of November. You must also know the firms and job profiles inside out. I worked on this specific area, and by the end of the placement session, I had gained a reputation among my wingies for my expertise at answering HR questions.
(b) Puzzles: Since this is a non-core sector, puzzles are the only way to objectively test the ability of candidates with diverse backgrounds. Look up braingle.com and techinterview.org. These two should suffice. Also, whenever you come across a puzzle that you’ve already encountered, pretend as if you’re going through it for the first time. Don’t rush through. This is your opportunity to impress them. Do not squander it away!
(c) Finance and economic affairs: If you have a comprehensive knowledge of the financial markets, national economy, and international affairs, in addition to the above two, it is highly improbable that you won’t be selected. For brushing up these, read the Economist (print or online), and read through the opinion pages of Economic Times or the Business Standard for 2-3 months leading to the Placement season. You must also regularly read a newspaper like the Hindu or Indian Express to keep yourself abreast of the latest events which frequently become a focal point of group discussions (for Credit Suisse). You CANNOT afford to walk into the interview ignorant of terms like European debt crisis, global financial crisis, fiscal cliff, QE, and basic finance like options, hedging etc. Wikipedia, Investopedia and J.C.Hull (first few chapters) are great sources to pick up these.
General Tips: 1. If you are a B.Tech. student, do not be under the wrong impression that you can target all sectors- core as well as non-core. It is really difficult to prepare comprehensively for all companies, especially if you are in the B.Tech. program owing to time constraints.
2. The Dual degree students have an edge over you for precisely two reasons. Firstly, they get more time to prepare for the placements, and have learnt vicariously from their B.Tech. batchmates' experiences. Secondly, they tend to have higher retention rates (good for the companies).
3. Work on your English communication skills which are crucial for performing well in interviews and GDs.
Let neither of these become an obstacle by leaving no stone unturned in the course of your preparations.
4. You can’t appear for more than 4 companies in the first slot. It is not realistic. Hence, decide beforehand. I knew I hadn’t prepared enough for consulting or core, hence I opted out of ITC and Opera.
5. If you are shortlisted in multiple companies, ask a reliable friend to accompany you to the interviews, and handle your mobile phone (“managing one’s portfolio”). You’ll thank me someday for this advice.
6. I was happy that I prepared as much as I did, neglecting my college academics in the process. It is a decision I am proud of.
7. My Morgan Stanley internship distinguished me from scores of other candidates. I had never truly appreciated its importance till then. That also goes to show how important it is to get a good internship.
Skill Tips: 1. I scored a 100 percentile in CAT and the preparation made a huge impact on preparing for any of the interviews.
2. I also interned at Morgan Stanley which was further a plus for me.
3. I had received Honda YES Award, University of Tokyo-IIT Scholarship and my academic background was quite good.
Skills: Problem solving skills, Finance Basics, Basic HR questions, Economic affairs
College Name: IIT KANPUR
Deepak Kumar Thakur
I applied via Walk-in
Interview Questionnaire
1 Question
- Q1. Finance related questions
Add your answer
Interview Preparation Tips
Round: Technical Interview
Experience: I think they were looking for Basic understanding of financial accounting, confidence.
My experience of working on valuation of Oil & Gas projects, financial modelling helped a lot
Tips: My confidence in answering questions related to finance and Read thoroughly two chapters 11 & 12 of “Financial Accounting” book by RNS
Skill Tips: They will give you required training
Skills: Finance
College Name: IIM Bangalore
Experience: I think they were looking for Basic understanding of financial accounting, confidence.
My experience of working on valuation of Oil & Gas projects, financial modelling helped a lot
Tips: My confidence in answering questions related to finance and Read thoroughly two chapters 11 & 12 of “Financial Accounting” book by RNS
Skill Tips: They will give you required training
Skills: Finance
College Name: IIM Bangalore
Interview Questionnaire
4 Questions
- Q1. Asked about my projects – the technical aspects, scope, etc
- Q2. Databases and Mysql – queries, types of keys, joins, etc
- Q3. Fundamentals of Operating Systems – threads/processes, scheduling algorithms, memory/storage, etc
- Q4. Data Structures and Files, so – sorting/searching algorithms, their complexities, files, other data structures, etc
Add your answer
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Round: Test
Experience: The first round, quite naturally, was the aptitude round. We had to answer questions that were designed to test our quantitative and technical abilities. But this was only the first part. The second part involved finding computational solutions to simulated situations. These questions needed to be solved in a programming language we were asked to choose earlier, during the aforementioned first part. I chose to do it in Java as that is one language I am really thorough with. I understand that C/C++ are more important and versatile, but what matters here is your inherent understanding of the concepts involved
Round: Group Activity
Experience: We had to build model buildings, using LEGO blocks. Other than the fact that I love building things from other smaller things, the supplied material took me back to my childhood days. We were divided into four groups. Two in each room, and each group consisted of 8-10 candidates. We were given a time limit within which we had to design and construct a building. As a surprise, after half time, they asked the two groups in each room to merge their projects. This probably was to see if the candidates were pro-active team players, and could handle unexpected situations like professionals.
Round: Technical Interview
Experience: There was another technical interview after the group activity. I was interviewed by two of their officers, who again asked questions similar to those from the first technical round. It went quite well, since I was quite confident about the way I was solving the problems they gave me. Thinking out loud is key, as that lets them in your problem-solving abilities. That way, they let you know if you are headed in the right direction. My interviewers were quite pleasant, as they liked discussing possible scenarios to the problems they gave me.
Round: HR Interview
Experience: there was an HR round, where the woman interviewed me about my projects. She needed to know if I had the guts to finish whatever it is that I started. So she asked more on the lines on my role in the projects I had undertaken in the previous years. She also asked me about my working experience from before. That too went well. It was pretty much a standard HR interview – projects, hobbies, traits, etc.
Round: fitness roound
Experience: There was another round in the end, which was to test the candidate’s professional fitness – if they indeed are the right people for the job. I found it to be a blend of technical and HR interviews, more on the lines of HR though. All in all, it was a brilliant experience
General Tips: To my juniors, study hard, be sincere, be yourself, be smart (preferably in that order, but you are free to improvise!)
College Name: IIT MADRAS
Experience: The first round, quite naturally, was the aptitude round. We had to answer questions that were designed to test our quantitative and technical abilities. But this was only the first part. The second part involved finding computational solutions to simulated situations. These questions needed to be solved in a programming language we were asked to choose earlier, during the aforementioned first part. I chose to do it in Java as that is one language I am really thorough with. I understand that C/C++ are more important and versatile, but what matters here is your inherent understanding of the concepts involved
Round: Group Activity
Experience: We had to build model buildings, using LEGO blocks. Other than the fact that I love building things from other smaller things, the supplied material took me back to my childhood days. We were divided into four groups. Two in each room, and each group consisted of 8-10 candidates. We were given a time limit within which we had to design and construct a building. As a surprise, after half time, they asked the two groups in each room to merge their projects. This probably was to see if the candidates were pro-active team players, and could handle unexpected situations like professionals.
Round: Technical Interview
Experience: There was another technical interview after the group activity. I was interviewed by two of their officers, who again asked questions similar to those from the first technical round. It went quite well, since I was quite confident about the way I was solving the problems they gave me. Thinking out loud is key, as that lets them in your problem-solving abilities. That way, they let you know if you are headed in the right direction. My interviewers were quite pleasant, as they liked discussing possible scenarios to the problems they gave me.
Round: HR Interview
Experience: there was an HR round, where the woman interviewed me about my projects. She needed to know if I had the guts to finish whatever it is that I started. So she asked more on the lines on my role in the projects I had undertaken in the previous years. She also asked me about my working experience from before. That too went well. It was pretty much a standard HR interview – projects, hobbies, traits, etc.
Round: fitness roound
Experience: There was another round in the end, which was to test the candidate’s professional fitness – if they indeed are the right people for the job. I found it to be a blend of technical and HR interviews, more on the lines of HR though. All in all, it was a brilliant experience
General Tips: To my juniors, study hard, be sincere, be yourself, be smart (preferably in that order, but you are free to improvise!)
College Name: IIT MADRAS
Interview Questionnaire
15 Questions
- Q1. Why finance? Why not core? (they grilled me for 20 minutes)
- Q2. There is a closed room with 3 bulbs and there are three switches outside. You can toggle any two switches once without looking inside the room and map the bulbs to their corresponding switches. (Since I ha...
- Q3. What is the crappiest thing on your resume?
- Ans.
I listed a job that I was fired from after only a few weeks.
Listed a job where I was fired after a few weeks
Didn't provide a clear explanation for why I was let go
Didn't highlight any skills or accomplishments from that job
- Q4. Entertain us for two minutes without asking any questions. (I told them about some funny incidents on the campus)
- Q5. Which IITian do you admire the most and why?
- Ans.
I admire Dr. Raghunath Anant Mashelkar, an IIT Bombay alumnus, for his contributions to science and technology.
Dr. Mashelkar is a chemical engineer and has made significant contributions to the field of polymer science.
He has also served as the Director General of the Council of Scientific and Industrial Research (CSIR) and has been awarded numerous honors, including the Padma Shri and Padma Bhushan.
Dr. Mashelkar has a...
- Q6. They then crushed an A4 sheet and asked me to sell it to them?
- Q7. Tell me about the eurozone crisis?
- Ans.
The eurozone crisis refers to the economic and financial difficulties faced by some countries in the European Union.
The crisis began in 2009 with the Greek debt crisis and spread to other countries in the eurozone.
It was caused by a combination of factors including high levels of debt, low economic growth, and structural problems within the eurozone.
The crisis led to bailouts of several countries by the European Centra...
- Q8. What do you know about the Libor Scam?
- Ans.
The Libor Scam was a manipulation of the London Interbank Offered Rate (Libor) by banks to benefit their own trading positions.
Libor is a benchmark interest rate used globally for financial products
Banks were found to have manipulated the rate to benefit their own trading positions
The scandal resulted in billions of dollars in fines for banks involved
Several high-profile bankers were also convicted for their involvemen...
- Q9. What are derivatives?
- Ans.
Derivatives are financial instruments that derive their value from an underlying asset or security.
Derivatives can be used for hedging or speculation.
Examples of derivatives include futures, options, and swaps.
Derivatives can be traded on exchanges or over-the-counter.
Derivatives can be complex and involve significant risk.
Derivatives played a role in the 2008 financial crisis.
- Q10. Some simple questions on options
- Q11. Why Finance? Why not join a casino? (I had mentioned that I find it challenging and stimulating)
- Q12. Lots of questions on the fiscal cliff
- Q13. What in your opinion would be the repercussions if the fiscal cliff was not avoided, both in US and in the global economy. Will India be affected and why?
- Ans.
Failure to avoid fiscal cliff could lead to severe economic repercussions globally and in the US, with India also being affected.
The US economy could experience a recession, with a potential decrease in GDP and increase in unemployment rates
Global financial markets could experience volatility and uncertainty
India could be affected due to its close economic ties with the US, with potential impacts on trade and investmen...
- Q14. What is Prime Services?
- Ans.
Prime Services is a suite of financial services offered by investment banks to hedge funds and other institutional clients.
Prime brokerage
Securities lending
Cash management
Risk management
Trade execution
Reporting and analytics
Examples: Goldman Sachs Prime Services, J.P. Morgan Prime Services
- Q15. What is QE? Why is it used?
- Ans.
QE stands for Quantitative Easing. It is a monetary policy used by central banks to stimulate the economy.
QE involves the central bank buying government bonds or other securities from the market to increase the money supply.
The increased money supply is intended to lower interest rates, encourage borrowing and spending, and boost economic activity.
QE is typically used when interest rates are already low and traditional...
Add your answer
Add your answer
Answered by
AI
Add your answer
Add your answer
Answered by
AI
Add your answer
Add your answer
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Add your answer
Add your answer
Add your answer
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Interview Preparation Tips
Round: Resume Shortlist
Experience: They didn't had any aptitude test, only resume based short-listing.
Round: Group Discussion
Experience: There were 10-15 students. There was 3 mins thinking time and 10 minutes discussion time. After the discussion each student was asked to conclude the GD and express his/her viewpoint.
Tips: 1. Jot down your point during the three minutes.
2. During the GD make sure that you express your opinion coherently.
3. Also make short notes during the GD which will be helpful in concluding it.
4. While concluding the GD, ensure that you cover all the points discussed during the GD (notes will be helpful here) and in the end express your own stand.
Duration: 10-15 minutes
Round: HR Interview
Experience: It was a HR + Puzzle round. Panel was of Some junior management and the duration was of 30-40 minutes. By the end of this round, they were quite impressed and sent me for the second interview immediately.
Round: Technical Interview
Experience: This round was based on Current Affairs and Finance and lasted for 20 minutes. And, I asked them a few questions about CS and job cutting etc. After this interview they had mentioned that they were quite positive on me and that I had to just interview with one more senior manager. This really boosted my confidence.
Round: Other Interview
Experience: It was also based on finance and current affairs. Panel consisted of the Senior most employee who had come for recruitment. After this round I was informally offered the job.
General Tips: 1. Even when you are unable to answer questions, don’t get bogged down or disheartened remain calm. DB quite often takes stress interview. Just keep your cool and smile while answering questions.
2. If you do not know any answer, there is no harm is admitting that.
3. Be confident. Know your resume inside out.
4. Practice a few HR interviews before the actual one.
5. Also, communication skills in English are very important.
Skills: Probability and Statistics, Basic Finance, Puzzles, Newspaper and current affairs, Major events in the financial world over the past 5-6 years
College Name: IIT KANPUR
Experience: They didn't had any aptitude test, only resume based short-listing.
Round: Group Discussion
Experience: There were 10-15 students. There was 3 mins thinking time and 10 minutes discussion time. After the discussion each student was asked to conclude the GD and express his/her viewpoint.
Tips: 1. Jot down your point during the three minutes.
2. During the GD make sure that you express your opinion coherently.
3. Also make short notes during the GD which will be helpful in concluding it.
4. While concluding the GD, ensure that you cover all the points discussed during the GD (notes will be helpful here) and in the end express your own stand.
Duration: 10-15 minutes
Round: HR Interview
Experience: It was a HR + Puzzle round. Panel was of Some junior management and the duration was of 30-40 minutes. By the end of this round, they were quite impressed and sent me for the second interview immediately.
Round: Technical Interview
Experience: This round was based on Current Affairs and Finance and lasted for 20 minutes. And, I asked them a few questions about CS and job cutting etc. After this interview they had mentioned that they were quite positive on me and that I had to just interview with one more senior manager. This really boosted my confidence.
Round: Other Interview
Experience: It was also based on finance and current affairs. Panel consisted of the Senior most employee who had come for recruitment. After this round I was informally offered the job.
General Tips: 1. Even when you are unable to answer questions, don’t get bogged down or disheartened remain calm. DB quite often takes stress interview. Just keep your cool and smile while answering questions.
2. If you do not know any answer, there is no harm is admitting that.
3. Be confident. Know your resume inside out.
4. Practice a few HR interviews before the actual one.
5. Also, communication skills in English are very important.
Skills: Probability and Statistics, Basic Finance, Puzzles, Newspaper and current affairs, Major events in the financial world over the past 5-6 years
College Name: IIT KANPUR
Skills evaluated in this interview
Interview Preparation Tips
Round: Resume Shortlist
Experience: My strong resume aided in getting shortlisted for Credit Suisse.
Round: Group Discussion
Experience: The GD went well as I did not haste into my chance and was calm throughout.
Round: Other Interview
Experience: The interview was with an alumni who told me that my GD performance was good, and asked me a puzzle. It was followed by some questions on my resume, mainly my internship.
Another puzzle followed, which I took some time to solve. I was able to solve the next one instantly,
Then I was asked to sell a crumbled piece of paper innovatively.
Round: Other Interview
Experience: This round was with a senior member in the company who asked about my resume, stay in campus, post of election officer and some tricky questions, which I answered well. A question on probability was asked. A few more puzzles followed, along with some questions on finance. He also mentioned that he did not expect me to answer these as I had no background in finance. But i was able to answer them.
I was then asked to leave and HR was called inside. I also had an interview with Diamond. The HR came to me and told me that they were interested in and asked me to stall my interview with diamond for a while.
Round: HR Interview
Experience: It was with VP and continued for 45 minutes with no puzzles, finances or cases. It was more of a discussion on all fields ranging from campus life to UP politics to Sachin's retirement, etc.
I was asked about my internship experience and the reason i wanted to join their company .
Round: HR Interview
Experience: It was with the Director, who said that he had a sore throat and hence would not say much. he said that they wanted to hire me and that I do not interview with any other firm. I was more than glad! I was the first person to bag an offer in the placement season.
College Name: IIT KANPUR
Experience: My strong resume aided in getting shortlisted for Credit Suisse.
Round: Group Discussion
Experience: The GD went well as I did not haste into my chance and was calm throughout.
Round: Other Interview
Experience: The interview was with an alumni who told me that my GD performance was good, and asked me a puzzle. It was followed by some questions on my resume, mainly my internship.
Another puzzle followed, which I took some time to solve. I was able to solve the next one instantly,
Then I was asked to sell a crumbled piece of paper innovatively.
Round: Other Interview
Experience: This round was with a senior member in the company who asked about my resume, stay in campus, post of election officer and some tricky questions, which I answered well. A question on probability was asked. A few more puzzles followed, along with some questions on finance. He also mentioned that he did not expect me to answer these as I had no background in finance. But i was able to answer them.
I was then asked to leave and HR was called inside. I also had an interview with Diamond. The HR came to me and told me that they were interested in and asked me to stall my interview with diamond for a while.
Round: HR Interview
Experience: It was with VP and continued for 45 minutes with no puzzles, finances or cases. It was more of a discussion on all fields ranging from campus life to UP politics to Sachin's retirement, etc.
I was asked about my internship experience and the reason i wanted to join their company .
Round: HR Interview
Experience: It was with the Director, who said that he had a sore throat and hence would not say much. he said that they wanted to hire me and that I do not interview with any other firm. I was more than glad! I was the first person to bag an offer in the placement season.
College Name: IIT KANPUR
Interview Questionnaire
4 Questions
- Q1. How would you find whether a number is even or odd without using any conditions?
- Ans.
Using bitwise operator to check the last bit of the number.
Use bitwise AND operator with 1 to check the last bit of the number.
If the result is 0, the number is even. If the result is 1, the number is odd.
Example: 6 & 1 = 0 (even), 7 & 1 = 1 (odd)
- Q2. Implement a dynamic 2D excel sheet using DS (underwent various levels of improvisations)
- Ans.
Implement a dynamic 2D excel sheet using DS
Use a 2D array to store the data
Implement functions to add, delete, and modify data
Use data structures like linked lists or hash tables for efficient searching and sorting
Implement dynamic resizing to handle large amounts of data
Use GUI libraries like Tkinter or PyQt for user interface
- Q3. A build up that resulted in the concept of using joins in DBMS
- Ans.
Joining tables in DBMS evolved as a solution to handle complex data relationships.
Joins allow combining data from multiple tables based on a common column.
The concept of joins originated from the need to handle complex data relationships.
Joins can be inner, outer, left, right, or cross depending on the type of data required.
Joins can improve query performance by reducing the number of queries needed to retrieve data.
Jo...
- Q4. Discussed the concept of virtual memory and paging in OS
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Add your answer
Interview Preparation Tips
Round: Test
Experience: There was negative marking for these questions (+4 & -1) and the number of questions in the second section were more (10 and 20 respectively, I think).The second part of the test was a Coding Round, online. We were given 3 problem statements to be solved in 45 minutes and the programming languages allowed were C, C++ and Java. However you are required to use the same language for Part 1 (Technical Skills) and Part 2 (Coding Round). So make sure you know any one language in its entirety. I hadn’t touched anything apart from C. The questions were essentially based on data structures.
Tips: Word of caution: Be wise in designing your strategy to solve questions, there always IS a sectional cut off and the competition is cutthroat.
Round: Technical Interview
Experience: -1 was pretty much basic, probably just for them to find out whether you know everything that you claim to know. I was asked questions on the basics of C, Data structure implementation, DBMS AND OS. Sounds daunting, but it really wasn't. My panellists were really cool about giving me all the time in the world to think about my answers, they'd even roll their chairs to the corner of the room and chit chat when I'd ask them to stop looking at me. Not a recommended course of action for you guys, because you might get really badass panellists who might want to take a stress interview and using this would probably get you a ticket to take you directly out of the building. But the point is that you don't need to panic when you're asked a question that you don't understand AT ALL. It is probably just a coating of shiny silver on a very basic problem. ALWAYS remember to restate the question as you understood it to make sure that you're on the right track. If you're right you get a bonus for being able to analyse well. If you're not, they will make you understand and you won't spend 15 minutes of your interview time solving a misinterpreted question.
Round: Group Activity
Experience: This is subject to change every year, but for ours we had the one with the Lego toys
Round: Technical Interview
Experience: This round was perhaps the most difficult of all, with gruelling technical questions that I couldn't make head or tail out of. But they were satisfied with a broad outlook to the number of solutions and the different ways to approach the problem. They asked me a little about how my day had been till then and for improvisations on the answers to the questions I was asked in the previous rounds. I was also asked a question about synchronization that I answered with my knowledge of embedded systems. They were really interested in how I applied unrelated knowledge to solve a problem that I would otherwise not be able to answer. This was the end of TECH-2 which made me believe that I had screwed up entirely and that I was out for sure.
Round: PRO FIT ROUND
Experience: I went in to my ProFit round with an "I-should-really-have the-best-time-with-this-thing-since-it-is-all-down-the-drain-anyway" attitude, but really, I think that is just what you're expected to do anyway. :) This ended up being the coolest round of all and I had the time of my life for those 30 minutes. My interviewer asked me ALL the general questions you expect in an HR, and I answered them all very, very truthfully and with really long explanations :P The guy was a veeeeery keen listener and caught on to each and every one of my indications. He let me talk about practically everything, from my very hippie-like outlook of life to the most silly bets I have placed, ever. And the best part was that he was always interested, poker-face like, but always waiting patiently for more exemplifications. Don't bother trying to make up achievements you haven't really made, because they don't care about how accomplished you are, more like how zestful you are, and it probably shows when you're talking about things that you love. Long story short, talk your heart out, they hardly speak in all of those 30 minutes. Let them know that you really ARE passionate about the things that you do.
Round: HR Interview
Experience: The next round that I was immediately ushered into was my HR. Now, I probably felt what I did because I had talked a LOT in my previous round, but I really thought this round was predominantly precursory. My interviewer was one of the big shots of the day, but he hardly asked me any questions that could qualify as HR. This person was the only one from all of my interviews who was even remotely rigid, but that too only marginally. He was ultra-friendly again by the end of the interview. This might vary case by case, but he only asked me things like my comfort with relocation and what I aimed to achieve in the next 5 years. At the end of the interview, he kid around a little and escorted me to the waiting room.
College Name: IIT MADRAS
Experience: There was negative marking for these questions (+4 & -1) and the number of questions in the second section were more (10 and 20 respectively, I think).The second part of the test was a Coding Round, online. We were given 3 problem statements to be solved in 45 minutes and the programming languages allowed were C, C++ and Java. However you are required to use the same language for Part 1 (Technical Skills) and Part 2 (Coding Round). So make sure you know any one language in its entirety. I hadn’t touched anything apart from C. The questions were essentially based on data structures.
Tips: Word of caution: Be wise in designing your strategy to solve questions, there always IS a sectional cut off and the competition is cutthroat.
Round: Technical Interview
Experience: -1 was pretty much basic, probably just for them to find out whether you know everything that you claim to know. I was asked questions on the basics of C, Data structure implementation, DBMS AND OS. Sounds daunting, but it really wasn't. My panellists were really cool about giving me all the time in the world to think about my answers, they'd even roll their chairs to the corner of the room and chit chat when I'd ask them to stop looking at me. Not a recommended course of action for you guys, because you might get really badass panellists who might want to take a stress interview and using this would probably get you a ticket to take you directly out of the building. But the point is that you don't need to panic when you're asked a question that you don't understand AT ALL. It is probably just a coating of shiny silver on a very basic problem. ALWAYS remember to restate the question as you understood it to make sure that you're on the right track. If you're right you get a bonus for being able to analyse well. If you're not, they will make you understand and you won't spend 15 minutes of your interview time solving a misinterpreted question.
Round: Group Activity
Experience: This is subject to change every year, but for ours we had the one with the Lego toys
Round: Technical Interview
Experience: This round was perhaps the most difficult of all, with gruelling technical questions that I couldn't make head or tail out of. But they were satisfied with a broad outlook to the number of solutions and the different ways to approach the problem. They asked me a little about how my day had been till then and for improvisations on the answers to the questions I was asked in the previous rounds. I was also asked a question about synchronization that I answered with my knowledge of embedded systems. They were really interested in how I applied unrelated knowledge to solve a problem that I would otherwise not be able to answer. This was the end of TECH-2 which made me believe that I had screwed up entirely and that I was out for sure.
Round: PRO FIT ROUND
Experience: I went in to my ProFit round with an "I-should-really-have the-best-time-with-this-thing-since-it-is-all-down-the-drain-anyway" attitude, but really, I think that is just what you're expected to do anyway. :) This ended up being the coolest round of all and I had the time of my life for those 30 minutes. My interviewer asked me ALL the general questions you expect in an HR, and I answered them all very, very truthfully and with really long explanations :P The guy was a veeeeery keen listener and caught on to each and every one of my indications. He let me talk about practically everything, from my very hippie-like outlook of life to the most silly bets I have placed, ever. And the best part was that he was always interested, poker-face like, but always waiting patiently for more exemplifications. Don't bother trying to make up achievements you haven't really made, because they don't care about how accomplished you are, more like how zestful you are, and it probably shows when you're talking about things that you love. Long story short, talk your heart out, they hardly speak in all of those 30 minutes. Let them know that you really ARE passionate about the things that you do.
Round: HR Interview
Experience: The next round that I was immediately ushered into was my HR. Now, I probably felt what I did because I had talked a LOT in my previous round, but I really thought this round was predominantly precursory. My interviewer was one of the big shots of the day, but he hardly asked me any questions that could qualify as HR. This person was the only one from all of my interviews who was even remotely rigid, but that too only marginally. He was ultra-friendly again by the end of the interview. This might vary case by case, but he only asked me things like my comfort with relocation and what I aimed to achieve in the next 5 years. At the end of the interview, he kid around a little and escorted me to the waiting room.
College Name: IIT MADRAS
Skills evaluated in this interview
Interview Preparation Tips
Round: Puzzle Interview
Tips: Prepare for questions on your resume, puzzles and a couple of HR questions.
Round: Puzzle Interview
Experience: A few resume based questions were asked too.
Round: HR Interview
Experience: They tried to judge how well the candidate would fit in with their company.
General Tips: Focus on the few companies that you want to get into, and prepare well for them.
Do not give way to peer influence. Do what you want to, even if it is not the most sought after.
College Name: IIT KANPUR
Tips: Prepare for questions on your resume, puzzles and a couple of HR questions.
Round: Puzzle Interview
Experience: A few resume based questions were asked too.
Round: HR Interview
Experience: They tried to judge how well the candidate would fit in with their company.
General Tips: Focus on the few companies that you want to get into, and prepare well for them.
Do not give way to peer influence. Do what you want to, even if it is not the most sought after.
College Name: IIT KANPUR
Interview Preparation Tips
Round: Test
Experience: First round - 1 hour online test split into 2 sections. First section - aptitude 10 questions and c/c++/java 10 question for a total of 30 minutes. Second section included 2 coding questions for a total time of 30 minutes. Approx - 400 students.
General Tips: Aptitude was hard and pace is important. Practicing commercial mathematics will help. Past projects are important and resume should have only information that you are thorough with.Understand the company and what it does before the personal interviews.
Skill Tips: Prepare well DSA, OS ,Aptitude,C,C++ , by the help of Indiabix.com.
Skills:
College Name: NIT Surathkal
Experience: First round - 1 hour online test split into 2 sections. First section - aptitude 10 questions and c/c++/java 10 question for a total of 30 minutes. Second section included 2 coding questions for a total time of 30 minutes. Approx - 400 students.
General Tips: Aptitude was hard and pace is important. Practicing commercial mathematics will help. Past projects are important and resume should have only information that you are thorough with.Understand the company and what it does before the personal interviews.
Skill Tips: Prepare well DSA, OS ,Aptitude,C,C++ , by the help of Indiabix.com.
Skills:
College Name: NIT Surathkal
I applied via Referral
Interview Questionnaire
2 Questions
- Q1. Mostly on Financial accounting
- Q2. Questions on Cash flow statements ( Project during 1st term )
Add your answer
Add your answer
Interview Preparation Tips
Round: Technical Interview
Experience: number of interviews were 2 where the 2nd was more of a confirmation that I am willing to work with them.
I answered most of the questions they asked except who is teaching you corporate finance. I asked a lot of questions about what they do and what is their view about Indian accounting laws
I think they are looking for knowledge in finance and less of globe during the interview.
Tips: Prof. R. Narayanswamies fundas of financial accounting.
Be thorough with financial.
Skills: Accounting, Finance
College Name: IIM Bangalore
Experience: number of interviews were 2 where the 2nd was more of a confirmation that I am willing to work with them.
I answered most of the questions they asked except who is teaching you corporate finance. I asked a lot of questions about what they do and what is their view about Indian accounting laws
I think they are looking for knowledge in finance and less of globe during the interview.
Tips: Prof. R. Narayanswamies fundas of financial accounting.
Be thorough with financial.
Skills: Accounting, Finance
College Name: IIM Bangalore
Sun Life Financial Interview FAQs
How many rounds are there in Sun Life Financial Data Analytics Lead interview?
Sun Life Financial interview process usually has 2 rounds. The most common rounds in the Sun Life Financial interview process are Resume Shortlist and Technical.
Tell us how to improve this page.
Sun Life Financial Interviews By Designations
- Sun Life Financial Process Associate Interview Questions
- Sun Life Financial Junior Process Associate Interview Questions
- Sun Life Financial Development Specialist Interview Questions
- Sun Life Financial Graduate Engineer Interview Questions
- Sun Life Financial Graduate Engineer Trainee (Get) Interview Questions
- Sun Life Financial Test Analyst Interview Questions
- Sun Life Financial Associate Analyst Interview Questions
- Sun Life Financial Technical Lead Interview Questions
- Show more
Interview Questions for Popular Designations
- Analytics Manager Interview Questions
- Data Analytics Intern Interview Questions
- Analytics Consultant Interview Questions
- IT (Data Analytics) Interview Questions
- Decision Analytics Associate Interview Questions
- Data Analytics Engineer Interview Questions
- Data Analytics Consultant Interview Questions
- Analytics Engineer Interview Questions
- Show more
Sun Life Financial Data Analytics Lead Interview Process
based on 1 interview
Interview experience
View more
Interview Questions from Similar Companies
|
Process Associate
579
salaries
|  ₹2.2 L/yr - ₹5.2 L/yr |
|
Senior Process Associate
372
salaries
| ₹3.2 L/yr - ₹6 L/yr |
|
Analyst Developer
120
salaries
| ₹7.8 L/yr - ₹18.6 L/yr |
|
Specialist Developer
102
salaries
| ₹11 L/yr - ₹26 L/yr |
|
Development Specialist
86
salaries
| ₹10 L/yr - ₹24.1 L/yr |
Compare Sun Life Financial with
Wells Fargo
Compare
JPMorgan Chase & Co.
Compare
Citicorp
Compare
American Express
Compare
Popular Calculators
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Sun Life Financial Interview Questions >
- Sun Life Financial Data Analytics Lead Interview Questions
Share an Interview