Dataford
Top 50
Prep plan
Updated weekly · Last refresh Aug 30

Ancestry Marketing Data Engineer Interview Questions

The questions to prepare for a Ancestry Marketing 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
PipelinesStart here. 28 questions · ~225 min
IaC for Pipeline InfrastructureMedium

Explain how you use IaC to provision and manage pipeline infrastructure consistently across environments.

InfrastructureOrchestrationDependenciesAncestry Marketing
Optimize Skewed Spark JoinMedium

Optimize a Spark join where skewed keys create long-running tasks during a transaction to merchant metadata enrichment step.

JoinsperformancesparkAncestry Marketing
Data Quality in ML PipelinesMedium

Practical approach for maintaining data quality across ML ETL pipelines, orchestration, and repeatable data processing.

Data QualityETLData ModelingAncestry Marketing
More Pipelines questions with a free account
2
SQL & Data Manipulation17 questions + 3 drills · ~167 min
Star vs Snowflake for Meta AnalyticsEasy

Explain star and snowflake schemas, their tradeoffs, and when to use each in Meta-scale analytics systems.

Ancestry Marketing
Simplify Reporting Queries with CTEsEasy

Explain how CTEs make complex PostgreSQL queries easier to read, debug, and maintain in reporting workflows.

SubqueriesJoinsCTEsAncestry Marketing
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberAncestry Marketing
SQL for 30-Day DNA Kit RetentionHard
Practice
Practice drill

Calculate 30-day DNA kit retention for an Ancestry Marketing promotion using CTEs, window functions, joins, and conditional aggregation.

Date FunctionsJoinsAggregationsAncestry Marketing
Calculate 30-Day User RetentionHard
Practice
Practice drill

Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.

Window FunctionsDate FunctionsAggregationsCurefitReachMobiIndeed
Window Functions for ChurnEasy
Practice
Practice drill

Use ROW_NUMBER and date logic to identify Ancestry users who became inactive after repeated activity.

Window FunctionssqlAncestry Marketing
More SQL & Data Manipulation 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
Coding5 questions · ~40 min
Design Parking Lot With REST MicroservicesMedium

Evaluates system design thinking for API-driven services and modular architecture.

rest apisdesignmicroservicesAncestry Marketing
Design LRU CacheMedium

Tests ability to design a correct caching system with appropriate data structures.

designcacheAncestry Marketing
More Coding questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.