Sun Life Financial Analyst Developer Interview Questions and Answers

It was 2 coding ques and computer basics ques

Similar to first with difficulty level high

Q1. Introduction about yourself
Ans. 
I am a backend developer with 5 years of experience in building scalable and efficient web applications.
• Experienced in programming languages like Java, Python, and Node.js

• Proficient in database management with SQL and NoSQL databases

• Familiar with cloud services like AWS and Azure

• Strong problem-solving skills and ability to work in a team environment
Answered by AI
Add your answer
Q2. DBMS,ops and SQL ques
Add your answer
Q3. One simple SQL query
Add your answer
Q4. Oops implementation
Add your answer

Q1. Mcq questions, create proc for displaying collection values, write func to show values.
Add your answer

Q1. Difference between primary key and unique key. Questions based on unique key and composite key. Write function to return multiple values. Sql queries to print values, update statement to update multiple ro...read more
Add your answer
Q2. Performance tuning questions related to hints.
Add your answer

HireVue, a few coding and some aptitude

Q1. Questions about Devops
Add your answer
Q2. Questions about project
Add your answer

Q1. Why do you want to work here
Ans. 
I am passionate about software development and believe this company offers a great learning opportunity.
• I admire the company's innovative projects and cutting-edge technologies.

• I am impressed by the company's positive reputation in the industry.

• I am excited about the opportunity to work with a talented team of developers.

• I believe this internship will provide me with valuable experience and skills for my future career.
Answered by AI
Add your answer
Q2. What do you think about your college
Ans. 
I think highly of my college as it provided me with a strong foundation in software development.
• My college has a reputable computer science program with experienced faculty members.

• The curriculum included hands-on projects and internships to enhance practical skills.

• I was able to participate in coding competitions and hackathons organized by the college.

• The college also offered networking opportunities with industry pr...read more
Answered by AI
Add your answer
Q3. Where do you see yourself in 5years
Ans. 
In 5 years, I see myself as a senior software developer leading a team and working on impactful projects.
• Continuing to enhance my technical skills and knowledge through continuous learning and training

• Taking on more leadership responsibilities and mentoring junior developers

• Contributing to the success of the company by delivering high-quality software solutions

• Exploring new technologies and trends in the software devel...read more
Answered by AI
Add your answer

Q1. I got a referral and was directly called into the first round of interview.
Add your answer
Q2. 1.5 hrs round, coding questions were there( can’t reveal ). Low level system design. Questions based on Frontend
Add your answer

Q1. Managerial round. 1 hour. In depth questions . Focused mainly upon projects, work done, etc.
Add your answer

Q1. Basic hr questions and salary negotiations.
Add your answer

Q1. Diff btwn this and arrow in javascript
Ans. 
The 'this' keyword in JavaScript refers to the current object, while the arrow function does not bind its own 'this'.
• The 'this' keyword in JavaScript refers to the object that is executing the current function.

• Arrow functions do not bind their own 'this' value, instead they inherit the 'this' value from the enclosing lexical context.

• Using 'this' in a regular function can lead to unexpected behavior, especially in neste...read more
Answered by AI
Add your answer
Q2. Diff btwn let, var, const
Ans. 
let, var, and const are all used to declare variables in JavaScript, but they have different scopes and behaviors.
• let is block-scoped and can be reassigned, var is function-scoped and can be reassigned, const is block-scoped and cannot be reassigned

• Using let:

• let x = 10;

• x = 20; // valid

• Using var:

• var y = 5;

• y = 8; // valid

• Using const:

• const z = 15;

• z = 25; // error, cannot reassign const variable
Answered by AI
Add your answer

Q1. Finalizer and un manageable resources
Add your answer

Hackerrank Coding - They have asked 2 questions.

Q1. OOPS Concepts and general questions.
Add your answer
Q2. About the project I have worked on.
Add your answer

Q1. Package, relocation and sponsorship for staying in the US
Add your answer