Assignment
Create 25 synthetic records containing duplicates, missing owners, two formats, stale versions, and one deletion event.
Build sequence
- Profile completeness and permissions by source category.
- Define transformation and rejection rules with provenance fields.
- Run ingestion twice and reconcile source, accepted, rejected, and indexed IDs.
- Apply updates and deletions and inspect derived records.
Acceptance checks
- Every source record has an accounted-for outcome.
- Repeated ingestion does not duplicate records.
- The report identifies which data gaps block a pilot and who can resolve them.
Evidence to keep
Submit the working artifact or decision document described above, the inputs used, and the observed results for every acceptance check. Include one failed attempt and the change you made after investigating it. Label fixture-based outcomes separately from live-system measurements. These artifacts become part of your final portfolio review.