Optumrx Software Engineer Interview Questions

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

21questions

~3htotal time

Track your progressSign up free to work through all 21 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 4 questions + 1 drill · ~47 min

SQL With Complex Joins and AggregationsHard

Practice

Combine OptumRx claims, prescriptions, pharmacies, and members to calculate utilization metrics with CTEs and window functions.

JoinsGroup ByAggregations

Optumrx

SQL Merge Stage PurposeMedium

Tests understanding of SQL data manipulation patterns and when to apply MERGE.

sql

Optumrx

Total Prescriptions Per MemberMedium

Practice

Given a table of prescription transactions and a table of members, write a query to find the total prescriptions per member for the last 30 days. Return e...

Date FunctionsJoinsAggregations

Optumrx

Refactoring a Slow QueryMedium

Practice

Practice drill

Refactor a slow Candid Health claims query using pre-aggregation, latest-event logic, and monthly payer metrics.

Performance Tuningdatabase optimizationCTEs

Candid Health

More SQL & Data Manipulation questions with a free account

Coding4 questions · ~37 min

Difference Between Interface and Abstract Class in JavaMedium

Explain the differences between interfaces and abstract classes in Java and when to use each.

Hash TablesArraysStrings

Optumrx

React Search Filter ComponentMedium

Tests your ability to implement interactive React UI with correct state and efficient updates.

javascriptreactfunctions

Optumrx

More Coding 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

Technical Fundamentals5 questions · ~47 min

Dependency Injection for Enterprise AppsMedium

Tests your understanding of decoupling, testability, and maintainable architecture in large systems.

enterprise systemstechnical experiencedependency injection

Optumrx

Event Bubbling and CaptureMedium

Tests your knowledge of DOM event propagation and how you control event flow in UI code.

javascriptbasics

Optumrx

More Technical Fundamentals questions with a free account

Behavioral & Leadership7 questions · ~65 min

More Behavioral & Leadership questions with a free account