AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Optum Global
Solutions
Compare
Proud winner of ABECA 2025 - AmbitionBox Employee Choice Awards
Filter interviews by
Optum Global Solutions Software Engineer Interview Questions and Answers
25 Interview questions
Constructors are special methods used to initialize objects. Overloading allows multiple constructors with different parameters.
Constructors have the same name as the class and no return type.
Overloading constructors allows for different ways to initialize objects.
Example: public class Person { public Person(string name) { } public Person(string name, int age) { } }
Overloaded constructors can call each other using...
ETL design involves identifying data sources, defining data transformations, and selecting a target system for loading the transformed data.
Identify data sources and determine the data to be extracted
Define data transformations to convert the extracted data into the desired format
Select a target system for loading the transformed data
Consider scalability, performance, and data quality issues
Use ETL tools such as I...
I have worked with React, Node.js, and AWS recently.
Developed a web application using React and Node.js
Deployed the application on AWS EC2 instance
Used AWS S3 for storing and retrieving files
Implemented authentication and authorization using AWS Cognito
Integrated Stripe payment gateway for online payments
Hive, Spark, and Hadoop are big data technologies used for data processing and analysis in distributed computing environments.
Hive: A data warehouse infrastructure built on top of Hadoop for querying and managing large datasets using SQL-like language (HiveQL).
Spark: An open-source distributed computing system that provides fast data processing capabilities and supports batch and stream processing.
Hadoop: A framew...
What people are saying about Optum Global Solutions
Normalization organizes data to reduce redundancy and improve integrity in databases.
Normalization involves dividing a database into tables and defining relationships.
It typically follows several normal forms (1NF, 2NF, 3NF) to eliminate data anomalies.
Example: Splitting a customer table into separate tables for customer info and orders.
Group By is an SQL clause that aggregates data based on one or more columns.
Ex...
Understanding SQL concepts like Nth value, data types, keys, and CRUD operations is essential for database management.
Nth Value: Use the ROW_NUMBER() function in SQL to find the Nth value in a result set. Example: SELECT * FROM (SELECT column, ROW_NUMBER() OVER (ORDER BY column) AS rn FROM table) AS temp WHERE rn = N.
Varchar vs Nvarchar: Varchar stores non-Unicode characters, while Nvarchar stores Unicode characte...
Procedure and package are two types of database objects used in Oracle database.
A procedure is a subprogram that performs a specific action and can be called by other programs.
A package is a collection of related procedures, functions, and variables that can be used by multiple programs.
Procedures and packages are stored in the database and can be called from any program that has access to the database.
Procedures ...
Design patterns are reusable solutions to common software design problems, enhancing code maintainability and scalability.
Singleton Pattern: Ensures a class has only one instance and provides a global point of access, useful for managing shared resources like configuration settings.
Observer Pattern: Defines a one-to-many dependency between objects, allowing multiple observers to be notified of state changes, commo...
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
Encapsulation helps in hiding the internal state of an object and restricting access to it.
It allows for better control over the data by preventing direct access from outside the class.
Example: In object-oriented programming, classes are used to implement encapsulation by combining data attributes and methods.
TDP ...
View is a virtual table while Materialized view is a physical table.
View is a logical representation of data while Materialized view is a physical copy of data.
View is updated dynamically while Materialized view needs to be refreshed manually.
Materialized view is faster for read-heavy operations while View is better for write-heavy operations.
Materialized view can be indexed while View cannot be indexed.
Optum Global Solutions Software Engineer Interview Experiences
43 interviews found
Anonymous
Linked list graph string to be prepared
Graph linked list was asked in this round
(1 Question)
- Q1. Salary negotiation
pratyansh
(1 Question)
- Q1. Rate yourself in the technology that you have added in your skills.
- Ans.
I rate myself 8 out of 10 in Java, 7 out of 10 in Python, and 6 out of 10 in SQL.
Java - Strong understanding of OOP concepts, experience with Spring framework
Python - Proficient in data manipulation and analysis, used in various automation scripts
SQL - Comfortable writing complex queries, experience with database management
Selected
I appeared for an interview in Oct 2024, where I was asked the following questions.
- Q1. Design Patterns and their usecase
- Ans.
Design patterns are reusable solutions to common software design problems, enhancing code maintainability and scalability.
Singleton Pattern: Ensures a class has only one instance and provides a global point of access, useful for managing shared resources like configuration settings.
Observer Pattern: Defines a one-to-many dependency between objects, allowing multiple observers to be notified of state changes, commonly u...
- Q2. Mostly Map related questions in Java
- Q3. Cloud questions
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Basic Questions of Data structure
- Q2. 2 Sum
Shreya Verma
There were DSA and SQL questions
(1 Question)
- Q1. Question about Arrays and DBMS
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
It was a standard and pretty easy one
(2 Questions)
- Q1. Why do you want to join
- Q2. Very professional HR
Interview Preparation Tips
I applied via Campus Placement
String manipulation questions
(1 Question)
- Q1. Array search and sorting
Selected
I applied via Naukri.com and was interviewed in Feb 2023. There were 3 interview rounds.
(3 Questions)
- Q1. What are constructors in dot net core and how will you overload a constructor.
- Q2. How to make restrict a class so that it can not be inherited
- Q3. What are constraints in Sql
(2 Questions)
- Q1. Tell me about yourself and the work you have done in recent times.
- Ans.
I am a software engineer with experience in developing web applications using Java and JavaScript.
Developed a web application using Java Spring framework
Implemented RESTful APIs for data retrieval and manipulation
Utilized JavaScript frameworks like React.js for front-end development
Worked on database design and optimization using SQL
Collaborated with cross-functional teams to deliver high-quality software
- Q2. What new technology have you learned in last 6 months.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I appeared for an interview before Mar 2024.
(2 Questions)
- Q1. What are the features of Java 8?
- Q2. What is the process for implementing a linked list?
- Ans.
Implementing a linked list involves defining nodes, linking them, and providing methods for insertion, deletion, and traversal.
Define a Node class with data and a pointer to the next node.
Create a LinkedList class to manage the head node and operations.
Implement methods for insertion (at head, tail, or specific position).
Implement methods for deletion (by value or position).
Provide traversal methods to display the list...
(1 Question)
- Q1. What is an IoC (Inversion of Control) container?
- Ans.
An IoC container manages object creation and dependencies, promoting loose coupling and easier testing in software applications.
IoC containers handle the instantiation and lifecycle of objects, reducing manual dependency management.
They support Dependency Injection (DI), allowing dependencies to be provided externally rather than hard-coded.
Examples include Spring Framework (Java), .NET Core's built-in IoC container, a...
Skills evaluated in this interview
(2 Questions)
- Q1. What is Procedure and package
- Ans.
Procedure and package are two types of database objects used in Oracle database.
A procedure is a subprogram that performs a specific action and can be called by other programs.
A package is a collection of related procedures, functions, and variables that can be used by multiple programs.
Procedures and packages are stored in the database and can be called from any program that has access to the database.
Procedures and p...
- Q2. View and materilzed view differences
- Ans.
View is a virtual table while Materialized view is a physical table.
View is a logical representation of data while Materialized view is a physical copy of data.
View is updated dynamically while Materialized view needs to be refreshed manually.
Materialized view is faster for read-heavy operations while View is better for write-heavy operations.
Materialized view can be indexed while View cannot be indexed.
(1 Question)
- Q1. Database types and standards
Skills evaluated in this interview
Optum Global Solutions Interview FAQs
Some of the top questions asked at the Optum Global Solutions Software Engineer interview -
The duration of Optum Global Solutions Software Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Optum Global Solutions Interviews By Designations
- Optum Global Solutions Claims Associate Interview Questions
- Optum Global Solutions Software Engineer Interview Questions
- Optum Global Solutions Medical Coder Interview Questions
- Optum Global Solutions Clinical Investigator Interview Questions
- Optum Global Solutions Software Developer Interview Questions
- Optum Global Solutions Senior Software Engineer Interview Questions
- Optum Global Solutions Data Analyst Interview Questions
- Optum Global Solutions Associate Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Senior Software Engineer Interview Questions
- Senior Engineer Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Project Engineer Interview Questions
- Lead Engineer Interview Questions
- Software Development Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 29 interview experiences
Difficulty level
Duration
Software Engineer Interview Questions from Similar Companies
Optum Global Solutions Software Engineer Reviews and Ratings
based on 329 reviews
Rating in categories
Gurgaon / Gurugram
4-6 Yrs
₹ 9.3-21 LPA
|
Claims Associate
4.1k
salaries
|  ₹2 L/yr - ₹5 L/yr |
|
Senior Software Engineer
3.3k
salaries
| ₹15.9 L/yr - ₹26 L/yr |
|
Software Engineer
2.9k
salaries
| ₹10.3 L/yr - ₹18 L/yr |
|
Medical Coder
1.7k
salaries
| ₹2 L/yr - ₹5.8 L/yr |
|
Senior Claims Associate
1.2k
salaries
| ₹2.6 L/yr - ₹5.9 L/yr |
Accenture
Wipro
Cognizant
Capgemini
- Home >
- Interviews >
- Optum Global Solutions Interview Questions
