Optum Tech Data Engineer Interview Questions
The questions to prepare for a Optum Tech Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Find all active Freecharge employees at the third-highest distinct salary using DENSE_RANK and a department join.
Optum TechExplain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.
Optum TechCompare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
Optum TechExplain how to tune a slow PostgreSQL query that joins several large transaction tables using indexes, join strategy, and partitioning.
Optum TechAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreUse joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.
Ramsey Solutions
ACME HouseApproach for maintaining data quality and integrity across ETL pipelines.
Optum TechDesign and implement SCD Type 1 and Type 2 dimensions with history tracking, idempotent loads, and data quality controls.
Optum TechTests modeling knowledge for historical tracking and dimensional updates.
Optum TechSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your ability to summarize relevant experience and connect it to the Business Analyst role.
Optum Tech