How do I approach System Design interview questions?

System Design questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master system design interviews.

What difficulty level is this interview question?

This is a medium difficulty System Design question, commonly asked during Onsite rounds at eBay.

What role is this question designed for?

This question is commonly asked for Software Engineer candidates at eBay during technical interviews.

Design a Relational-to-DynamoDB Migration System

Quick Overview

This question evaluates expertise in system design for large-scale relational-to-DynamoDB migrations, including NoSQL data modeling, schema and access-pattern analysis, historical backfill, change-data-capture, validation, cutover and rollback planning, and operational monitoring; it is categorized under System Design and database migration/NoSQL domains. It is commonly asked to assess practical application of architectural concepts and trade-offs required to achieve minimal downtime, ensure data correctness, and maintain availability and observability, emphasizing applied system-level design rather than low-level implementation details.

Design a production migration system that moves an existing e-commerce service from a relational database to DynamoDB with minimal downtime.

Your design should cover:

How to analyze the existing relational schema and access patterns.
How to model the target DynamoDB tables, partition keys, sort keys, and secondary indexes.
How to perform the initial historical backfill.
How to capture and replay ongoing writes while the migration is in progress.
How to validate data correctness between the old and new stores.
How to cut traffic over safely from the relational database to DynamoDB.
How to roll back if the migration causes correctness, latency, or availability problems.
What key indicators you would monitor during the migration and after cutover.

Quick Overview

Design a production migration system that moves an existing e-commerce service from a relational database to DynamoDB with minimal downtime.

Your design should cover:

How to analyze the existing relational schema and access patterns.
How to model the target DynamoDB tables, partition keys, sort keys, and secondary indexes.
How to perform the initial historical backfill.
How to capture and replay ongoing writes while the migration is in progress.
How to validate data correctness between the old and new stores.
How to cut traffic over safely from the relational database to DynamoDB.
How to roll back if the migration causes correctness, latency, or availability problems.
What key indicators you would monitor during the migration and after cutover.

Design a Relational-to-DynamoDB Migration System

Quick Overview

Solution

Submit Your Answer

Design a Relational-to-DynamoDB Migration System

Quick Overview

Solution

Submit Your Answer