Optum Technology Data Engineer Interview Questions
The questions to prepare for a Optum Technology Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Optimize a PySpark join when one DataFrame is much smaller, focusing on join strategy, shuffle reduction, and practical Spark tuning.
Optum TechnologyDesign and implement SCD Type 1 and Type 2 dimensions with history tracking, idempotent loads, and data quality controls.
Optum TechnologyKey security considerations for a cloud data pipeline, from ingestion through storage, orchestration, and monitoring.
Optum TechnologyExplain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.
Optum TechnologyAssesses practical experience with ETL, data warehousing, SQL, and protecting data via masking.
Optum TechnologyCompare consecutive monthly patient utilization using aggregation and LAG, including utilization changes and percentage changes.
Optum TechnologyCompute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPCompare generator expressions and list comprehensions by memory usage, execution model, and when each is preferable.
Optum TechnologyTests your understanding of Snowflake’s architecture and how it separates compute and storage.
Optum TechnologyTests your ability to build robust Python ETL logic for nested healthcare claim data.
Optum TechnologySign up to see every question
Create a free account to unlock this list and practice real interview questions.