Optum Global Solutions Software Developer Interview Questions, Process, and Tips

Round duration - 90 minutes
Round difficulty - Medium

2 Programing Questions and 30 MCQs. 
Programing questions were medium with one being array manipulation and other being graph based. 

MCQ were from OOPs concepts, SQL, Operating System and Network, prepare in depth knowledge for all the topics.

Q1. 
Count Pairs Problem Statement
You are given an array A of length N consisting only of integers. Additionally, you are provided with three integers X, Y and SUM. Your task is to count the number of pairs (...read more
Ans. 
Count the number of pairs in an array that satisfy a given equation.
• Iterate through all pairs of indices in the array and check if the equation is satisfied.

• Use a hashmap to store the frequency of values that can be used to form pairs.

• Optimize the solution by using two pointers approach to find pairs efficiently.
Answered by AI
Add your answer
Q2. 
Longest Substring Without Repeating Characters Problem Statement
Given a string S of length L, determine the length of the longest substring that contains no repeating characters.
Example:
Input:
"abac...read more
Ans. 
Find the length of the longest substring without repeating characters in a given string.
• Use a sliding window approach to keep track of the longest substring without repeating characters.

• Use a hashmap to store the index of each character in the string.

• Update the start index of the window when a repeating character is encountered.

• Calculate the maximum length of the substring as you iterate through the string.

• Return the m
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Questions on SQL and DBMS were asked in this round

Q1. What are the ACID properties in DBMS?
Ans. 
ACID properties in DBMS ensure data integrity and consistency.
• Atomicity: All operations in a transaction are completed successfully or none are. For example, transferring money from one account to another.

• Consistency: Database remains in a consistent state before and after the transaction. For example, maintaining referential integrity.

• Isolation: Transactions are executed independently without interference. For example...read more
Answered by AI
View 2 more answers
Q2. Can you explain the different levels of data abstraction in a DBMS?
Ans. 
Data abstraction in a DBMS involves hiding complex details from users, allowing them to interact with data at different levels of complexity.
• Data abstraction in DBMS involves three levels: Physical level, Logical level, and View level.

• Physical level deals with how data is stored on the storage medium, including details like data structures and file formats.

• Logical level defines the structure of the database, including ...read more
Answered by AI
Add your answer
Q3. What are constraints in SQL?
Ans. 
Constraints in SQL are rules that are enforced on data columns in a table.
• Constraints ensure data integrity by enforcing rules on data columns

• Common constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK

• Example: NOT NULL constraint ensures a column cannot have NULL values
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

HR round was pretty much a casual conversation about why optum, work location, joining availablity and what qualities you would like to highlight about yourself.

Q1. Why do you want to work at Optum, and what qualities would you like to highlight?
Add your answer

Q1. Basic architecture related questions
Add your answer
Q2. Application Architecture
Add your answer

Every thing realted job

Q1. Any thing about knowledge communication skills etc
Add your answer

Q1. Notice period, expected CTC
Add your answer

Q1. Explain your projects done in college
Add your answer

Q1. What is the difference between obj open and obj open by handle
Ans. 
obj open vs obj open by handle
• obj open opens a file and returns a file object

• obj open by handle opens a file using a file descriptor

• obj open by handle is faster than obj open

• obj open by handle is used when you already have a file descriptor
Answered by AI
Add your answer
Q2. How to change the work object status of the multiple cases from pending to closed.
Ans. 
To change work object status of multiple cases from pending to closed.
• Identify the cases that need to be closed

• Update the status of each case to closed

• Save the changes made to the cases

• Use a loop to perform the above steps for multiple cases

• Example: Use a query to identify all cases with pending status and update their status to closed
Answered by AI
Add your answer
Q3. Why blocked rules are carry forward
Ans. 
Blocked rules are carry forward to ensure consistency and prevent errors in future processing.
• Blocked rules are rules that have been prevented from executing due to certain conditions not being met.

• These rules are carried forward to ensure that they are not missed in future processing.

• This helps to maintain consistency and prevent errors in the system.

• For example, if a rule is blocked due to a missing data field, it wi...read more
Answered by AI
Add your answer
Q4. What is the use of previliges
Ans. 
Privileges are permissions granted to users or processes to perform specific actions or access certain resources.
• Privileges are used to control access to sensitive data or critical system resources.

• They can be assigned to individual users or groups.

• Examples include read, write, execute, and delete permissions.

• Privileges can also be used to restrict access to certain functions or features within an application.

• Without p...read more
Answered by AI
Add your answer
Q5. Last Project related questions
Add your answer
Q6. SLA related questions
Add your answer
Q7. Queue processor and job schedule difference
Ans. 
Queue processor manages tasks in a queue while job scheduler schedules tasks based on time or event triggers.
• Queue processor manages tasks in a queue and processes them in a first-in, first-out (FIFO) order.

• Job scheduler schedules tasks based on time or event triggers, and can prioritize tasks based on their importance.

• Queue processor is typically used for real-time processing of tasks, while job scheduler is used for ...read more
Answered by AI
Add your answer
Q8. Difference between append to and append to map to
Ans. 
Append to adds an element to a list while append to map adds a key-value pair to a map.
• Append to is used for lists while append to map is used for maps.

• Append to adds an element to the end of the list while append to map adds a key-value pair to the map.

• Append to map can also update the value of an existing key in the map.
Answered by AI
Add your answer
Q9. Use of superclass data transform check box
Ans. 
Superclass data transform checkbox is used to inherit data transform rules from a parent class.
• When checked, the subclass will inherit the data transform rules from the superclass

• This can save time and effort in creating duplicate data transform rules

• Example: A superclass has a data transform rule to convert a date format, when the checkbox is checked in a subclass, it will also use the same rule

• This checkbox is availa
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

It was around 4 pm in the evening and it includes both MCQs and coding questions. Hackerrank platform was user friendly and good.

Q1. 
Maximum XOR Problem Statement
You are given an integer X. Your goal is to find an integer Y such that the bitwise XOR of X and Y yields the maximum possible value. The integer Y must not exceed 2305843009...read more
Ans. 
Find an integer Y such that XOR of X and Y yields maximum value within given constraints.
• Iterate through each test case and find the maximum possible Y by flipping all bits of X except the most significant bit.

• The maximum value of Y is 2^61 - 1, which is 2305843009213693951.

• Ensure that the obtained Y does not exceed the given constraints.
Answered by AI
Add your answer

Round duration - 40 minutes
Round difficulty - Medium

30-40 minutes interview round.

Q1. 
Kth Largest Element Problem
Given an array containing N distinct positive integers and a number K, determine the Kth largest element in the array.
Example:
Input:
N = 6, K = 3, array = [2, 1, 5, 6, 3, ...read more
Ans. 
Find the Kth largest element in an array of distinct positive integers.
• Sort the array in non-increasing order to easily find the Kth largest element.

• Ensure all elements in the array are distinct for accurate results.

• Handle multiple test cases efficiently by iterating through each case.
Answered by AI
Add your answer
Q2. How can you measure 9 minutes using only a 4-minute hourglass and a 7-minute hourglass?
Add your answer

Round duration - 40 minutes
Round difficulty - Medium

Resume based round and some technical concepts were asked

Q1. How can you find the 5th highest salary in a list of salaries using a SQL query?
Ans. 
Use SQL query with ORDER BY and LIMIT to find the 5th highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 4,1 to skip the first 4 salaries and get the 5th highest salary
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

Easiest of all was the HR round.