A critical CRM sync between HubSpot and Salesforce has broken, and downstream teams are seeing conflicting customer and pipeline data in allwhere operational reporting. You need to explain how you would diagnose the break, isolate whether it came from extraction, orchestration, transformation logic, or load behavior, and restore trust in the pipeline without creating duplicate or inconsistent records.
Freshness gaps between source systems and warehouse tablesField-level drift, especially owner, stage, and account mappingsDuplicate records caused by retries or partial loadsBroken dependencies in scheduled sync jobsNeed for replay or backfill after the fix