Dataford
Top 50
Prep plan
Updated weekly · Last refresh Sep 20

Optum Software Engineer Interview Questions

The questions to prepare for a Optum Software Engineer interview. Questions from real interview reports rank first. Updated daily.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions + 2 drills · ~106 min
Second Highest Trader SalaryEasy
Practice
Recently asked

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingOptum
Explain ACID in Transaction SystemsEasy
Recently asked

Explain the four ACID properties and why they matter for reliable transaction processing in SQL systems.

acid propertiestransactionsdata integrityOptum
Top N Per Group with WindowMedium
Practice
Practice drill

Use a window function to return the three highest-paid employees within each department.

Window FunctionsJoinsRankingBlue YonderInc.nference
Finding Duplicate RecordsEasy
Practice
Practice drill

Find duplicate customer emails using GROUP BY and HAVING in PostgreSQL.

Group ByHavingAggregationsGuy CarpenterWestern DigitalBismart
More SQL & Data Manipulation questions with a free account
2
Coding11 questions · ~94 min
Swap Characters Without Built-insEasy
Practice
Recently asked

Reverse a string by manually swapping characters without using built-in string reversal methods.

coding challengestring manipulationData StructuresOptum
More Coding questions with a free account
3
System Design4 questions · ~34 min
Abstract Classes vs InterfacesMedium
Recently asked

Tests your grasp of OOP design concepts and when each construct is appropriate.

abstractionOptum
More System Design questions with a free account
4
Security & Infrastructure7 questions · ~60 min
Implementing AuthenticationMedium
Recently asked

Assesses your approach to authentication design and implementation details.

authenticationimplementationOptum
More Security & Infrastructure questions with a free account
5
Technical Fundamentals7 questions · ~60 min
Elasticsearch KnowledgeMedium
Recently asked

Assesses your knowledge of Elasticsearch and how you apply it in real systems.

Optum
More Technical Fundamentals questions with a free account
6
Execution7 questions · ~60 min
Connecting Multiple Databases in Spring BootMedium
Recently asked

Assesses your ability to configure and integrate data sources in Spring Boot.

spring bootOptum
More Execution questions with a free account
7
More topics4 questions · ~34 min
Handling Architectural Stakeholder ConflictMedium
Recently asked

Tests conflict resolution and influence when a stakeholder challenges an architectural decision with meaningful business or technical stakes.

Conflict ResolutionStakeholder ManagementCommunicationOptum
More questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 50 questions plus 2 hands-on drills to finish this plan.