Interview guides · Ancestry Marketing

Ancestry Marketing Software Engineer Interview Guide

Ancestry Marketing Software Engineer interview guide: reported rounds, questions and how candidates describe the process.

The 60-second brief

As a Software Engineer within Ancestry Marketing, you are at the intersection of robust technical execution and global user acquisition. Your work directly enables the systems, platforms, and web experiences that introduce millions of people to Ancestry and its family history and DNA products. Unlike traditional backend engineering roles, this position requires a keen understanding of how performance, architecture, and user experience drive business growth. You will be responsible for building and scaling high-traffic marketing platforms, integrating complex Content Management Systems (CMS), and developing seamless web applications. The code you write will power highly visible campaigns and dynamic user journeys that must perform flawlessly under heavy traffic.

This guide is scoped to a Software Engineer candidate at Ancestry Marketing.

Focus areas

Coding challenges / programming assessments
Programming language: C#
Problem solving / algorithmic thinking

The Ancestry Marketing interview process

Ancestry Marketing candidates report 4 rounds over 3-5 weeks. The stages below are what candidates describe, not a published process.

Recruiter Phone Screen

Initial call to discuss your background, career goals, and alignment with the role.

What to demonstrate

Initial call to discuss your background, career goals, and alignment with the role
Depth in Coding challenges / programming assessments

How to prepare

Be able to walk your CV end to end in two minutes, and say why this company specifically.
Have your salary expectations, notice period and location constraints ready, and ask for the rest of the loop in writing.

Technical Screening

May involve an online HackerRank assessment or a take-home coding project.

What to demonstrate

May involve an online HackerRank assessment or a take-home coding project
Depth in Coding challenges / programming assessments

How to prepare

Answer aloud and timed: Given a string, write a function to find the first non-repeating character.
Answer aloud and timed: How would you reverse a linked list, and what is the time complexity of your solution?

Technical Phone Interview

Live coding session with a senior engineer or hiring manager, including deep-dive questions.

What to demonstrate

Live coding session with a senior engineer or hiring manager
Including deep-dive questions

How to prepare

Answer aloud and timed: Write a function that traverses a binary tree and returns the sum of all its nodes.
Answer aloud and timed: Walk me through the SOLID principles and explain how they guide your software design.

Onsite Interview

Comprehensive interview with multiple team members covering coding, system design, and behavioral questions.

What to demonstrate

Comprehensive interview with multiple team members covering coding, system design, and behavioral questions
Depth in Coding challenges / programming assessments

How to prepare

Answer aloud and timed: How does garbage collection work in Java (or C#), and how can you optimize memory usage?
Answer aloud and timed: Design a relational database schema for a content management system.

Where candidates lose points

Think Out Loud During CodePair

When solving live coding challenges, never code in silence. Explain your assumptions, discuss edge cases, and talk through your brute-force solution before optimizing it. Your communication is evaluated just as heavily as your syntax.

Master the "Why" Behind the Code

Ancestry interviewers love to ask how things work under the hood. Don't just know how to use a framework or language feature; know how it is compiled, how it manages memory, and why it was designed that way.

Prepare for Ambiguity

You may be given a system design or coding problem with intentionally vague requirements. It is your job to ask clarifying questions to define the scope before you start designing or coding.

Be Patient with the Process

The recruiting coordination can sometimes be slow. If you don't hear back immediately after a round, follow up politely with your recruiter. Persistence and professionalism go a long way.

Showcase Your User-Centric Mindset

Because this role supports marketing, always tie your technical decisions back to the user experience. Mentioning how an architectural choice improves page load speed or user conversion will score you major points.

Questions & practice

Write a program to implement a caching system using an optimal data structure.

Medium · Coding and Algorithms

Approach

Restate the input: its shape, its size, and what is guaranteed about it.
Name the brute-force solution and its complexity before improving on it.
Choose the data structure from the access pattern, not from familiarity.
State the target complexity and say which constraint rules the naive version out.

Follow-up

How does this change if the input no longer fits in memory?
What is the worst case, and how likely is it on real data?

Use dynamic programming to solve the Fibonacci sequence efficiently.

Medium · Coding and Algorithms

Approach

Restate the input: its shape, its size, and what is guaranteed about it.
Name the brute-force solution and its complexity before improving on it.
Choose the data structure from the access pattern, not from familiarity.
State the target complexity and say which constraint rules the naive version out.

Follow-up

How does this change if the input no longer fits in memory?
What is the worst case, and how likely is it on real data?

Given a string, write a function to find the first non-repeating character.

Medium · Coding and Algorithms

Approach

Restate the input: its shape, its size, and what is guaranteed about it.
Name the brute-force solution and its complexity before improving on it.
Choose the data structure from the access pattern, not from familiarity.
State the target complexity and say which constraint rules the naive version out.

Follow-up

How does this change if the input no longer fits in memory?
What is the worst case, and how likely is it on real data?

How would you reverse a linked list, and what is the time complexity of your solution?

Medium · Coding and Algorithms

Approach

Restate the input: its shape, its size, and what is guaranteed about it.
Name the brute-force solution and its complexity before improving on it.
Choose the data structure from the access pattern, not from familiarity.
State the target complexity and say which constraint rules the naive version out.

Follow-up

How does this change if the input no longer fits in memory?
What is the worst case, and how likely is it on real data?

Write a function that traverses a binary tree and returns the sum of all its nodes.

Medium · Coding and Algorithms

Approach

Restate the input: its shape, its size, and what is guaranteed about it.
Name the brute-force solution and its complexity before improving on it.
Choose the data structure from the access pattern, not from familiarity.
State the target complexity and say which constraint rules the naive version out.

Follow-up

How does this change if the input no longer fits in memory?
What is the worst case, and how likely is it on real data?

How does garbage collection work in Java (or C#), and how can you optimize memory usage?

Medium · Core Engineering and Architecture

Approach

Say what the runtime actually does before reasoning about the code.
Name what is shared across threads and what owns each piece of state.
Identify the window where an invariant is briefly untrue.
Distinguish a value from a reference to it, and say which one you handed out.

Follow-up

What happens if two callers reach this at the same time?
Where could this allocate more than you expect?

Explain the JavaScript event loop and how it handles asynchronous operations.

Medium · Web Development and Marketing Tech

Approach

Say what the runtime actually does before reasoning about the code.
Name what is shared across threads and what owns each piece of state.
Identify the window where an invariant is briefly untrue.
Distinguish a value from a reference to it, and say which one you handed out.

Follow-up

What happens if two callers reach this at the same time?
Where could this allocate more than you expect?

Replace offset paging on the resource feed with keyset

Easy · keyset pagination · composite index · sort order

resource holds resource_id, tenant_id, owner_user_id, title, body_ref, version, status ('draft','active','archived','deleted'), created_at, updated_at, deleted_at, with an index on (tenant_id, status, updated_at DESC, resource_id DESC). The listing endpoint returns active resources for one tenant, newest update first, 50 per page, today with LIMIT 50 OFFSET n. Tenants reach page 400 and rows are created while they read. Write the keyset query, define what the cursor carries and how it is encoded, and say which part of the index each predicate uses. Assume PostgreSQL 16.

Approach

Name the two failures separately. OFFSET 20000 makes the server produce and discard 20,000 rows, so page cost grows with depth rather than with page size. Independently, any write that changes how many rows sort above the offset moves the window between two fetches, and the direction decides which anomaly you get: an insert lands at the head of updated_at DESC and pushes already-returned rows down past the boundary, so they are returned a second time; a delete above the offset, or a row whose updated_at is bumped above the cursor, pulls rows up and one is never returned at all. Nothing in the response reveals either.
Write the seek: WHERE tenant_id = $1 AND status = 'active' AND (updated_at, resource_id) < ($2, $3) ORDER BY updated_at DESC, resource_id DESC LIMIT 50. The row-value comparison is one index range rather than a disjunction, and both columns are NOT NULL, which is what makes that comparison well defined.
Map each predicate onto the index: tenant_id and status are equality on the leading columns, (updated_at, resource_id) is the range, and the ORDER BY matches the index order so no Sort node appears and the scan stops after 50 rows. The DESC in the definition only matters for mixed directions — a plain ascending btree on the same columns is read backwards for this query.
Put both sort columns in the cursor and nothing the client can tamper with into another tenant: base64 of (updated_at, resource_id), validated server-side, with tenant_id taken from the principal.

Follow-up

The client asks for 'jump to page 400'. What do you offer instead, and what does the honest version cost?
Sort order becomes user-selectable across four columns. How many indexes is that, and which would you refuse to add?

Stop tag and share joins from fanning out a page

Medium · join fan-out · semi-joins · many-to-many

resource_tag is (resource_id, tag_id) with PK (resource_id, tag_id); resource_share is (resource_id, shared_with_user_id, permission). The tagged-and-shared listing inner-joins resource to both, filters tenant_id, tag_id = ANY($2) and shared_with_user_id = $3, orders by updated_at DESC and takes 50. Pages come back with fewer than 50 distinct resources and the total in the header is far too high. Explain the row multiplication, rewrite both the page query and the count query so each is correct, and name the index each one needs. PostgreSQL 16.

Approach

Do the arithmetic against the predicates that are actually there. An inner join emits one row per matching child row, and both joins are filtered: tag_id = ANY($2) admits only the requested tags, shared_with_user_id = $3 admits one user's share rows. So a resource holding three of the requested tags and shared with $3 once yields three rows, not one — the multiplier is its count of matching tags times its share rows for that single user, and that second factor is 1 unless the table admits duplicate (resource_id, shared_with_user_id) pairs. LIMIT 50 then limits rows rather than resources, and COUNT(*) counts pairs — the header is the product, not the population.
Reject DISTINCT as the fix. It deduplicates after the product has been built, so the planner must materialise and sort the fanned-out set before the LIMIT can apply, and it leaves any SUM or AVG in the same select list wrong.
Rewrite both filters as semi-joins, keeping resource as the only row source: AND EXISTS (SELECT 1 FROM resource_tag rt WHERE rt.resource_id = r.resource_id AND rt.tag_id = ANY($2)) and the same shape against resource_share. A semi-join stops at the first match per resource and preserves the driving index order, so ORDER BY updated_at DESC, resource_id DESC LIMIT 50 still stops after 50 rows.
Count with the same predicates and no join at all: SELECT count(*) FROM resource r WHERE r.tenant_id = $1 AND r.status = 'active' AND EXISTS (...) AND EXISTS (...). Nothing multiplies a resource, so the number is the population.

Follow-up

The filter changes from 'any of these tags' to 'all of these tags'. Rewrite it and state what it costs relative to the ANY form.
A resource can be shared with the same user twice under different permissions. Does your count change, and should it?

Walk me through the SOLID principles and explain how they guide your software design.

Medium · Core Engineering and Architecture

Approach

Fix the scope first: who calls this, how often, and what they do when it fails.
Name the read and write paths separately; they rarely have the same bottleneck.
Choose a partition key and say what query it makes expensive.
State the consistency you need, and where you are willing to be stale.

Follow-up

What breaks first when traffic grows ten times?
How does this behave when that dependency is down for an hour?

Design a relational database schema for a content management system.

Medium · Core Engineering and Architecture

Approach

Fix the scope first: who calls this, how often, and what they do when it fails.
Name the read and write paths separately; they rarely have the same bottleneck.
Choose a partition key and say what query it makes expensive.
State the consistency you need, and where you are willing to be stale.

Follow-up

What breaks first when traffic grows ten times?
How does this behave when that dependency is down for an hour?

Explain the difference between abstract classes and interfaces, and when you would use each.

Medium · Core Engineering and Architecture

Approach

Fix the scope first: who calls this, how often, and what they do when it fails.
Name the read and write paths separately; they rarely have the same bottleneck.
Choose a partition key and say what query it makes expensive.
State the consistency you need, and where you are willing to be stale.

Follow-up

What breaks first when traffic grows ten times?
How does this behave when that dependency is down for an hour?

How would you design a scalable web service hosted on AWS to handle high traffic?

Medium · Core Engineering and Architecture

Approach

Fix the scope first: who calls this, how often, and what they do when it fails.
Name the read and write paths separately; they rarely have the same bottleneck.
Choose a partition key and say what query it makes expensive.
State the consistency you need, and where you are willing to be stale.

Follow-up

What breaks first when traffic grows ten times?
How does this behave when that dependency is down for an hour?

How do you manage state in a complex React application?

Medium · Web Development and Marketing Tech

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

Walk me through your process for taking a PSD design file and turning it into a responsive web page.

Medium · Web Development and Marketing Tech

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

What strategies would you use to improve the load time and SEO of a marketing landing page?

Medium · Web Development and Marketing Tech

Approach

Clarify what is being asked and what a complete answer contains.
State your assumptions explicitly before working the problem.
Say what you would check first and why it is the highest-information step.
Work from the requirement backwards to the design.

Follow-up

What assumption would you test first?
How would you know your answer was wrong?

Listing latency scales with page size, not with filters

Easy · n+1 · latency · query batching

The tenant listing endpoint reads resource filtered by tenant_id and status, ordered by updated_at DESC, and returns each row plus the owner's display name from app_user and the actor of that resource's latest resource_revision. p99 is 55 ms at 10 rows per page and 1.4 s at 200. Database telemetry shows 401 statements per request, each under 1 ms, and nothing in the slow-query log. Diagnose the cause and give the fix, stating the statement count per request and the p99 you expect afterwards.

Approach

Read the counters before forming a theory. 401 statements for 200 rows is one driver query plus two per row, and sub-millisecond execution with an empty slow-query log rules out a bad plan. The time is round trips, which is why it is invisible in every per-query metric and scales with rows returned rather than with filter selectivity.
Name the two per-row statements from their normalised text: a single-row app_user lookup by user_id, and a resource_revision lookup by resource_id ordered by version DESC LIMIT 1. Confirm by dropping those two response fields and watching the statement count fall to one. That locates the calls in the serialisation layer, not the repository.
Check that the arithmetic accounts for the whole gap. Measure one round trip to the replica in isolation; 400 trips at roughly 3 ms of network plus 0.2 ms of execution is about 1.3 s on top of a 55 ms baseline, which matches. If the multiplication had fallen short, the N+1 would only be part of the story and you would keep looking.
Batch both lookups. Collect owner_user_ids and resource_ids from the driver query, then issue WHERE tenant_id = $1 AND user_id = ANY($2) for the users, and PostgreSQL's SELECT DISTINCT ON (resource_id) ... WHERE resource_id = ANY($2) ORDER BY resource_id, version DESC for the latest revision, which the UNIQUE (resource_id, version) index serves directly. On an engine without DISTINCT ON, use a lateral join or a row_number window. Three statements per request at any page size.

Follow-up

The page size is capped at 200 today. What breaks first if it is raised to 2,000, and is it still this bug?
How do you stop the next N+1 from reaching production, given that no individual query is slow and the endpoint's tests pass?

Suggested practice checklist

Built from the rounds and topics Ancestry Marketing candidates report.

Day 1 — Map the Ancestry Marketing loop

Write out the reported sequence: Recruiter Phone Screen, Technical Screening, Technical Phone Interview, Onsite Interview.
For each round, write one sentence on what it is judging, from the description above, and mark the one you are least ready for.

Deliverable: A one-page map of the 4 reported rounds, with the weakest marked.

Day 2 — Work Coding challenges / programming assessments

Spend the session on Coding challenges / programming assessments, which Ancestry Marketing candidates report being tested on.
Write one worked example in Coding challenges / programming assessments and time yourself on it.

Deliverable: One timed worked example in Coding challenges / programming assessments.

Day 3 — Work Programming language: C#

Spend the session on Programming language: C#, which Ancestry Marketing candidates report being tested on.
Write one worked example in Programming language: C# and time yourself on it.

Deliverable: One timed worked example in Programming language: C#.

Day 4 — Work Problem solving / algorithmic thinking

Spend the session on Problem solving / algorithmic thinking, which Ancestry Marketing candidates report being tested on.
Write one worked example in Problem solving / algorithmic thinking and time yourself on it.

Deliverable: One timed worked example in Problem solving / algorithmic thinking.

Day 5 — Answer out loud: Coding and Algorithms

Answer aloud, timed: Write a program to implement a caching system using an optimal data structure.
Answer aloud, timed: Use dynamic programming to solve the Fibonacci sequence efficiently.

Deliverable: Spoken answers to 2 reported Coding and Algorithms question(s), under time.

Day 6 — Answer out loud: Core Engineering and Architecture

Answer aloud, timed: Walk me through the SOLID principles and explain how they guide your software design.
Answer aloud, timed: How does garbage collection work in Java (or C#), and how can you optimize memory usage?

Deliverable: Spoken answers to 2 reported Core Engineering and Architecture question(s), under time.

Day 7 — Answer out loud: Web Development and Marketing Tech

Answer aloud, timed: Explain the JavaScript event loop and how it handles asynchronous operations.
Answer aloud, timed: How do you manage state in a complex React application?

Deliverable: Spoken answers to 2 reported Web Development and Marketing Tech question(s), under time.

Behavioural preparation

Behavioural rounds judge the decision you made and what it cost.

Explain how CSS specificity works and how you avoid conflicts in large stylesheets.

Medium · Web Development and Marketing Tech

Approach

Pick a story where you made the decision, not one where you watched it.
State the situation in two sentences and spend the rest on the reasoning.
Give the blast radius: what could have broken, and what you measured.
Name the disagreement and how you resolved it with evidence.

Follow-up

What would you do differently if you ran that again?
How did you know your change caused the improvement?

Tell me about a time you had to push back on a product requirement because of technical limitations.

Medium · Behavioral and Culture Fit

Approach

Pick a story where you made the decision, not one where you watched it.
State the situation in two sentences and spend the rest on the reasoning.
Give the blast radius: what could have broken, and what you measured.
Name the disagreement and how you resolved it with evidence.

Follow-up

What would you do differently if you ran that again?
How did you know your change caused the improvement?

Describe a challenging bug you recently fixed. How did you diagnose and resolve it?

Medium · Behavioral and Culture Fit

Approach

Pick a story where you made the decision, not one where you watched it.
State the situation in two sentences and spend the rest on the reasoning.
Give the blast radius: what could have broken, and what you measured.
Name the disagreement and how you resolved it with evidence.

Follow-up

What would you do differently if you ran that again?
How did you know your change caused the improvement?

How do you handle working with a team member who has a completely different approach to solving a problem?

Medium · Behavioral and Culture Fit

Approach

Pick a story where you made the decision, not one where you watched it.
State the situation in two sentences and spend the rest on the reasoning.
Give the blast radius: what could have broken, and what you measured.
Name the disagreement and how you resolved it with evidence.

Follow-up

What would you do differently if you ran that again?
How did you know your change caused the improvement?

Walk me through a project on your resume that you are particularly proud of. What was your specific contributi

Medium · Behavioral and Culture Fit

Walk me through a project on your resume that you are particularly proud of. What was your specific contribution?

Approach

Pick a story where you made the decision, not one where you watched it.
State the situation in two sentences and spend the rest on the reasoning.
Give the blast radius: what could have broken, and what you measured.
Name the disagreement and how you resolved it with evidence.

Follow-up

What would you do differently if you ran that again?
How did you know your change caused the improvement?

Why are you interested in joining Ancestry, and specifically the marketing technology organization?

Medium · Behavioral and Culture Fit

Approach

Pick a story where you made the decision, not one where you watched it.
State the situation in two sentences and spend the rest on the reasoning.
Give the blast radius: what could have broken, and what you measured.
Name the disagreement and how you resolved it with evidence.

Follow-up

What would you do differently if you ran that again?
How did you know your change caused the improvement?