Interview Guides
You are responsible for a reporting pipeline that feeds executive dashboards and operational alerts. Two upstream systems publish the same KPI, but the values do not match, and the discrepancy is now visible to business users. The team needs a clear way to detect, explain, and resolve the mismatch without breaking downstream reports.
How would you handle a situation where two source systems report different values for the same KPI?
