Ancestry Data Engineer Interview Questions
The questions to prepare for a Ancestry Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Implement an LRU cache in O(1) average time using a hash table and doubly linked list.
AncestryExplain narrow vs wide transformations, how dependencies differ, and why wide transformations trigger network shuffle.
AncestryAssesses your ability to design service boundaries and API contracts for a distributed system.
AncestryDesign an AWS data lake architecture handling 12 TB/day batch data and 80K events/sec with governed bronze, silver, and gold layers.
AncestryDesign and implement SCD Type 1 and Type 2 dimensions with history tracking, idempotent loads, and data quality controls.
AncestryExplain how to build and operate an incremental daily batch load with safe reruns, backfills, and data quality checks.
AncestrySign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests SQL window function proficiency for deduplication and latest-record retrieval.
AncestryTests dimensional modeling skills for analytics and subscription-focused reporting.
AncestryUse ROW_NUMBER and a LEFT JOIN to find each paid Ancestry member's best January Record Search session.
AncestryMeasure monthly retention for a January Ancestry Family Tree cohort using CTEs and ROW_NUMBER().
AncestryCalculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.
Trideum
Zulily
eBay