Design Data Quality and Observability Pipeline

Quick Overview

This question evaluates proficiency in designing production data orchestration, data quality validation, and observability frameworks for both batch and streaming pipelines, covering dependency management, schema and integrity checks, and operational handling of anomalous records.

Design Data Quality and Observability Pipeline

Company: Point72

Role: Data Engineer

Category: System Design

Difficulty: hard

Interview Round: Technical Screen

Design a production data orchestration, data quality, and observability framework for batch and streaming data pipelines. Your design should address: 1. How would you orchestrate data pipelines with upstream and downstream dependencies? 2. What data quality checks would you implement, such as threshold checks, upstream dependency checks, schema checks, null checks, and primary-key checks? 3. What would a data observability framework include? 4. If a small percentage of streaming records, for example 2%, fails validation, would you stop the entire pipeline? Explain your decision process and handling strategy.

Quick Answer: This question evaluates proficiency in designing production data orchestration, data quality validation, and observability frameworks for both batch and streaming pipelines, covering dependency management, schema and integrity checks, and operational handling of anomalous records.

|Home/System Design/Point72
Point72 logo
Point72
Apr 30, 2026, 12:00 AM
hardData EngineerTechnical ScreenSystem Design
11
0

Design a production data orchestration, data quality, and observability framework for batch and streaming data pipelines.

Your design should address:

  1. How would you orchestrate data pipelines with upstream and downstream dependencies?
  2. What data quality checks would you implement, such as threshold checks, upstream dependency checks, schema checks, null checks, and primary-key checks?
  3. What would a data observability framework include?
  4. If a small percentage of streaming records, for example 2%, fails validation, would you stop the entire pipeline? Explain your decision process and handling strategy.

Submit Your Answer to Earn 20XP

Sign in to leave a comment

Loading comments...