Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Diagnose an Integration Pipeline Issue

MediumPipelines00:00
Practice interviewer
In session
5 left
00:00

Your question is Diagnose an Integration Pipeline Issue. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

You need to log in / sign up to chat or submit.

Problem

Scenario

You're supporting a customer-facing data integration and need to troubleshoot why data is missing, delayed, or incorrect. You want a clear way to isolate whether the problem is in extraction, transformation, loading, scheduling, or downstream mapping.

Question

What steps would you take to diagnose a customer issue with an integration?

What to Inspect

Connector auth status and last successful sync
Airflow DAG run history and retry behavior
SQS backlog, DLQ volume, and worker errors
Snowflake raw vs curated row counts
dbt freshness and test failures

Reference Stack

  • Ramp connector service
  • Apache Airflow 2.8
  • Amazon SQS + DLQ
  • Amazon S3 Parquet staging
  • Snowflake raw and curated tables
  • dbt Core 1.7