Top 44
Prep plan
Updated weekly · Last refresh Oct 17

Aetna Data Engineer Interview Questions

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

44questions
~6htotal time
Track your progressSign up free to work through all 44 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 1 drill · ~87 min
Average Claims for Active MembersMedium
Practice

Calculate average Aetna claim amount for members active through each claim date for at least one year.

Date FunctionsJoinsAggregationsAetna
Top Meds Per Region SQLMedium
Practice

Rank the three most prescribed medications in each Aetna region using joins, aggregation, and ROW_NUMBER().

Window FunctionsJoinsRankingAetna
Schema Design for Analytics vs OLTPMedium

Explain how to choose normalized or denormalized schemas for transactional and analytics workloads, including trade-offs in performance and data quality.

JoinsData WranglingAggregationsAetna
Top Regions by EnrollmentMedium
Practice
Practice drill

Find the top three regional offices by distinct patient enrollment in the previous calendar month.

Date FunctionsJoinsRankingAetna
More SQL & Data Manipulation questions with a free account
2
Pipelines12 questions · ~103 min
Handle Bad Records in Streaming MLMedium

Approach for detecting, isolating, and recovering from missing or corrupted records in a real-time ML pipeline.

Data QualityStream ProcessingmonitoringAetna
Data Integrity During System MigrationHard

Approach for preserving correctness during a pipeline migration, including validation, replay safety, and controlled cutover.

ETLIdempotencyQualityAetna
More Pipelines 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
3
Coding7 questions · ~60 min
Parse and Transform Unstructured LogsMedium

Assesses ability to build robust parsing and transformation logic for messy healthcare data.

data parsingdata cleaningAetna
Debug Intermittent Distributed FailuresHard

Evaluates systematic debugging skills for flaky distributed jobs.

failureDebuggingAetna
More Coding questions with a free account
4
Behavioral & Leadership15 questions · ~128 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~9 min
Memory Management for Large DatasetsMedium

Tests practical approaches to avoid memory issues during large-scale processing.

memory managementCodinglarge datasetsAetna
The finish line: interview-readyComplete all 44 questions plus 1 hands-on drill to finish this plan.