Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Optum Global Solutions Team. If you also belong to the team, you can get access from here

Optum Global Solutions Verified Tick

Compare button icon Compare button icon Compare
4.1

based on 1.7k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Optum Global Solutions Senior Software Engineer Interview Questions, Process, and Tips

Updated 24 Dec 2024

Top Optum Global Solutions Senior Software Engineer Interview Questions and Answers

Optum Global Solutions Senior Software Engineer Interview Experiences

8 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I was interviewed in Jun 2024.

Round 1 - Technical 

(5 Questions)

  • Q1. All the questions were from SQL server.
  • Q2. How to get 3rd highest salary ?
  • Ans. 

    To get the 3rd highest salary, you can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.

    • Use a SQL query to select distinct salaries in descending order.

    • Use the 'LIMIT' keyword to limit the results to 3.

    • Use the 'OFFSET' keyword to skip the first 2 highest salaries.

    • Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;

  • Answered by AI
  • Q3. Inner join result of 2 table. Table one [1,1,1,1] table two [1,1,1,1,1,1]
  • Ans. 

    The inner join of two tables with duplicate values results in a combined set of common values.

    • Inner join combines rows from both tables where the key columns match

    • In this case, the result would be [1,1,1,1,1,1] as all values are common in both tables

  • Answered by AI
  • Q4. SSIS Package creation.
  • Q5. Latest project explanation
  • Ans. 

    Developed a web application for tracking and managing project tasks

    • Used React.js for front-end development

    • Implemented RESTful APIs using Node.js and Express

    • Utilized MongoDB for database management

    • Incorporated authentication and authorization features for user security

  • Answered by AI
Round 2 - One-on-one 

(6 Questions)

  • Q1. What is difference between SQL and NoSQL
  • Ans. 

    SQL is a relational database management system, while NoSQL is a non-relational database management system.

    • SQL databases are table-based, NoSQL databases are document, key-value, graph, or wide-column stores

    • SQL databases use structured query language for defining and manipulating data, NoSQL databases use different query languages

    • SQL databases are vertically scalable, NoSQL databases are horizontally scalable

    • SQL databa...

  • Answered by AI
  • Q2. Why is NoSQL better then SQL
  • Ans. 

    NoSQL is better for handling unstructured data, providing scalability and flexibility.

    • NoSQL databases are better suited for handling unstructured data like social media posts, user-generated content, and IoT data.

    • NoSQL databases provide better scalability as they can easily distribute data across multiple servers, allowing for horizontal scaling.

    • NoSQL databases offer more flexibility in terms of data model, allowing fo...

  • Answered by AI
  • Q3. Explain the data pipeline you have worked on.
  • Ans. 

    Designed and implemented a real-time data pipeline for processing and analyzing user behavior data.

    • Used Apache Kafka for real-time data streaming

    • Utilized Apache Spark for data processing and analysis

    • Implemented data transformations and aggregations using Scala

    • Stored processed data in a data warehouse like Amazon Redshift

    • Built monitoring and alerting systems to ensure data pipeline reliability

  • Answered by AI
  • Q4. Managing team
  • Q5. What will you do if you have conflict with your manager.
  • Ans. 

    I would address the conflict directly and professionally, seeking to understand the root cause and find a mutually beneficial solution.

    • Schedule a private meeting with the manager to discuss the conflict

    • Listen actively to the manager's perspective and express your own calmly

    • Seek to find common ground and propose potential solutions

    • If necessary, involve HR or a mediator to help resolve the conflict

  • Answered by AI
  • Q6. What do you love to do when you are free
  • Ans. 

    I love to spend my free time hiking, reading, and trying out new recipes in the kitchen.

    • Hiking in the mountains or local trails

    • Reading fiction and non-fiction books

    • Experimenting with new recipes and cooking techniques

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Salary expectations
  • Q2. Family background

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare best for SQL related questions.
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 was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Technical question from java
  • Q2. Real time scenario based question

Interview Preparation Tips

Interview preparation tips for other job seekers - Very good product based company

Senior Software Engineer Interview Questions Asked at Other Companies

asked in UST
Q1. Find Nth PrimeYou are given a number 'N'. Your task is to find Nt ... read more
asked in Capgemini
Q2. Pascal's TriangleYou are given an integer N. Your task is to retu ... read more
Q3. K Largest Elements You are given with an integer k and an array o ... read more
asked in GlobalLogic
Q4. System Design QuestionCreate a simple shopping application. They ... read more
asked in Info Edge
Q5. Buy and Sell StockYou are Harshad Mehta’s friend. He told you the ... read more
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Questions related Data Sctructure and Algorithms
Round 2 - Technical 

(1 Question)

  • Q1. Questions related to Project and TechStack
Round 3 - HR 

(1 Question)

  • Q1. Behavioral questions were asked
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(1 Question)

  • Q1. Java, spring framework, hibernate questions
Round 3 - Technical 

(1 Question)

  • Q1. Java, spring boot, design
Round 4 - HR 

(1 Question)

  • Q1. Why are you switching comany ? and Salary Expectations

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared because opportunities are every very and you never know until you get the opportunity.

Optum Global Solutions interview questions for designations

 Software Engineer

 (4)

 Senior Software Tester

 (1)

 Associate Software Engineer

 (8)

 Software Developer

 (5)

 Associate Software Engineer 2

 (4)

 SDE (Software Development Engineer)

 (1)

 Principal Engineer

 (1)

 Data Engineer

 (1)

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Coding Test 

SQL, ADF questions were asked, previous work exp

Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Basic coding questions related to programming

Round 2 - Technical 

(1 Question)

  • Q1. Technical questions based on resume
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(1 Question)

  • Q1. Salesforce trigger, batch apex , process automation
Round 3 - Technical 

(1 Question)

  • Q1. Salesforce trigger , batch apex, community, and service cloud, lightning questions
Round 4 - HR 

(1 Question)

  • Q1. Behavioural questions and salary expectation

I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(3 Questions)

  • Q1. Angular Questions were asked.
  • Q2. .NetCore Questions were asked.
  • Q3. Azure Functions, App Services

Interview Preparation Tips

Topics to prepare for Optum Global Solutions Senior Software Engineer interview:
  • Angular
  • .NetCore
  • SqlServer
Interview preparation tips for other job seekers - Good fundamentals should be there and good communication skill.

Interview questions from similar companies

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

I applied via Job Fair and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions on Asp.net.
  • Ans. Just google interview questions for Asp.net and prepare from there
  • Answered Anonymously
Round 3 - Technical 

(2 Questions)

  • Q1. Again there was basic questions on asp.net
  • Q2. Management questions were also there. 1. If there is escalation from client how will you handle it.
Round 4 - HR 

(1 Question)

  • Q1. This was just a discussion round with HR where you can discuss about salary, company policies etc

Interview Preparation Tips

Topics to prepare for Fujitsu Senior Software Engineer interview:
  • ASP.Net
  • SQL

I applied via Naukri.com and was interviewed in Jul 2022. There was 1 interview round.

Round 1 - Technical 

(7 Questions)

  • Q1. What are indexes in the database? what is the difference between clustered and non-clustered indexes?
  • Ans. 

    Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.

    • Indexes are used to speed up data retrieval operations in a database.

    • Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.

    • A table can have only one clustered index, but multiple non-clustered indexes.

    • Clustered indexes are generally ...

  • Answered by AI
  • Q2. Write a query to delete duplicate rows from a table.
  • Ans. 

    Query to delete duplicate rows from a table

    • Use GROUP BY clause to group the rows by their unique values

    • Use HAVING clause to filter out the groups with count greater than 1

    • Use DELETE statement to delete the duplicate rows

  • Answered by AI
  • Q3. Class A { public string A() { return "hello"; } } what is wrong with above code?
  • Q4. What is a singleton pattern and how to implement it?
  • Ans. 

    Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.

    • Create a private constructor to restrict instantiation of the class

    • Create a private static instance of the class

    • Create a public static method to access the instance

    • Ensure thread safety if necessary

    • Examples: Database connection, Logger, Configuration settings

  • Answered by AI
  • Q5. How do you handle exceptions in stored procedures?
  • Ans. 

    Handle exceptions in stored procedures by using TRY-CATCH blocks.

    • Use TRY-CATCH blocks to catch and handle exceptions

    • Log the error message and severity level

    • Rollback the transaction if necessary

    • Rethrow the error if it cannot be handled

    • Use RAISERROR to raise custom error messages

  • Answered by AI
  • Q6. Explain SOLID principles.
  • Ans. 

    SOLID principles are a set of five design principles that help in creating maintainable and scalable software.

    • S - Single Responsibility Principle: A class should have only one reason to change.

    • O - Open-Closed Principle: Software entities should be open for extension but closed for modification.

    • L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.

    • I - Interface Segregation Principle: C...

  • Answered by AI
  • Q7. Difference between throw and throw exception?
  • Ans. 

    throw is used to throw an exception while throw exception is used to throw a specific exception.

    • throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.

    • throw exception is followed by the type of exception that needs to be thrown.

    • throw can be used to throw any object while throw exception can only be used to throw an exception object.

    • Example: throw new Exception("

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - You need to give quite a few interviews to be prepared.

Skills evaluated in this interview

Optum Global Solutions Interview FAQs

How many rounds are there in Optum Global Solutions Senior Software Engineer interview?
Optum Global Solutions interview process usually has 2-3 rounds. The most common rounds in the Optum Global Solutions interview process are Technical, HR and Resume Shortlist.
How to prepare for Optum Global Solutions Senior Software 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 Optum Global Solutions. The most common topics and skills that interviewers at Optum Global Solutions expect are Java, Software Development, Software Engineering, Spring Boot and Application Development.
What are the top questions asked in Optum Global Solutions Senior Software Engineer interview?

Some of the top questions asked at the Optum Global Solutions Senior Software Engineer interview -

  1. Inner join result of 2 table. Table one [1,1,1,1] table two [1,1,1,1,1...read more
  2. What is difference between SQL and No...read more
  3. Explain the data pipeline you have worked ...read more

Tell us how to improve this page.

Optum Global Solutions Senior Software Engineer Interview Process

based on 5 interviews in last 1 year

Interview experience

4.2
  
Good
View more

People are getting interviews through

based on 5 Optum Global Solutions interviews
Referral
Job Portal
40%
40%
20% candidates got the interview through other sources.
Moderate Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Optum Global Solutions Senior Software Engineer Salary
based on 622 salaries
₹9 L/yr - ₹30 L/yr
21% more than the average Senior Software Engineer Salary in India
View more details

Optum Global Solutions Senior Software Engineer Reviews and Ratings

based on 72 reviews

3.9/5

Rating in categories

3.5

Skill development

4.1

Work-Life balance

3.3

Salary & Benefits

4.1

Job Security

3.6

Company culture

2.8

Promotions/Appraisal

3.6

Work Satisfaction

Explore 72 Reviews and Ratings
Claims Associate
1k salaries
unlock blur

₹1.7 L/yr - ₹5 L/yr

Senior Software Engineer
622 salaries
unlock blur

₹9 L/yr - ₹30 L/yr

Software Engineer
440 salaries
unlock blur

₹5.1 L/yr - ₹20.1 L/yr

Senior Claims Associate
369 salaries
unlock blur

₹2.3 L/yr - ₹5.5 L/yr

Senior Associate
147 salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Optum Global Solutions with

Cognizant

3.8
Compare

Accenture

3.9
Compare

IBM

4.1
Compare

TCS

3.7
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