Data Quality and Lineage | Dataford Interview Questions

Explain your approach to ensuring data quality and lineage in a multi-source environment for Jpmorgan Chase &.

Implement the function below to validate records, retain the latest valid record from each source, detect conflicting field values, and record source lineage.

Input: a list of record dictionaries plus required fields and expected source names. Return clean_records and structured issues; each clean record must include its contributing source names.

Constraints

0 <= len(records) <= 500
1 <= len(required_fields) <= 20
1 <= len(expected_sources) <= 20
Each record contains entity_id, source, event_time, and fields
event_time values use lexicographically sortable ISO-8601 strings
Each entity-source pair may appear multiple times

Function Signature

def audit_records(records, required_fields, expected_sources):

Your question is Data Quality and Lineage. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem