Top 50
Prep plan
Updated weekly · Last refresh Aug 30

Aetna Data Engineer Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 1 drill · ~86 min
Top Meds Per Region SQLMedium
Practice

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

Window FunctionsJoinsRankingAetna
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
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
Rolling 30-Day Claim Totals SQLMedium
Practice
Practice drill

Use a date-based window function to calculate each active member's rolling 30-day paid claim total.

Window FunctionsData ManipulationsqlAetna
More SQL & Data Manipulation questions with a free account
2
Pipelines12 questions · ~102 min
Batch vs Stream Processing Trade-offsMedium

Compare batch and stream processing across latency, complexity, cost, and data quality in a modern analytics pipeline.

InfrastructureStream ProcessingETLAetna
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityAetna
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
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
Coding9 questions · ~76 min
Parse Logs and Count Error CodesMedium

Tests Python parsing, text processing, and aggregation for operational log analysis.

Hash TablesStringsAetna
Python Coding RoundEasy

Tests your ability to implement Python solutions for data engineering tasks.

ArraysStringsAetna
More Coding questions with a free account
4
Behavioral & Leadership20 questions · ~170 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 1 hands-on drill to finish this plan.