Top 9

Prep plan

Updated weekly · Last refresh Oct 17

Optum Financial Data Engineer Interview Questions

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

9questions

~1htotal time

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

Start practicing free →

SQL & Data ManipulationStart here. 5 questions + 3 drills · ~70 min

Star vs Snowflake for Sales AnalyticsMedium

Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.

JoinsData WranglingGroup By

Optum Financial

Handling Slowly Changing DimensionsMedium

Tests understanding of SCD modeling and implementation choices in data warehousing.

slowly changing dimensionsdata management

Optum Financial

Optimizing Complex SQL JoinsHard

Assesses query optimization techniques and performance troubleshooting for complex SQL.

Joinsperformancequery optimization

Optum Financial

Designing Reporting SchemaHard

Evaluates database design decisions that support reliable financial reporting at scale.

schema designdatabase designFinancial Reporting

Optum Financial

Top High-Cost Claims QueryMedium

Practice

Practice drill

Rank Optum Financial claims by paid amount and return the highest-cost 10% using CTEs and PERCENT_RANK.

sql queryData Analysis

Optum Financial

Database Schema DesignMedium

Practice

Practice drill

Audit user, application, and event relationships to validate completeness and referential integrity.

data relationshipsJoinsData Wrangling

Mercer France

bet365

Normalization in Database DesignMedium

Practice

Practice drill

Demonstrate normalization by aggregating customer revenue across separate customer, order, and order item tables.

JoinsData WranglingCTEs

EPAM Systems

More SQL & Data Manipulation questions with a free account

Pipelines3 questions · ~24 min

Snowflake on AWS ArchitectureMedium

Evaluates ability to architect scalable Snowflake pipelines on AWS using SQL and Python.

cloud servicesarchitecture

Optum Financial

Building Optum Data PipelinesMedium

Assesses experience designing secure ETL and warehousing pipelines for healthcare data.

ETLsql

Optum Financial

Orchestrating ETL with AirflowMedium

Tests practical orchestration skills for ETL using Airflow, Python, SQL, and Informatica.

data processingTools

Optum Financial

Sign up to see every question

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

Get my prep plan