HR Data Import Reconciliation Agent

HR system migrations fail when the export contains invalid employee IDs, broken dates or records that do not match each other. This agent validates every record in the HR export against the target system's schema. It applies only reversible repairs in a staging copy, and only where the schema clearly defines the fix, such as date formats or code mappings. It then reconciles row counts between source and staging, so no employee is lost or duplicated. When two records look like the same person but conflict, it keeps them separate and lists them for review instead of merging. The HR systems admin approves the final import. Edge case: two records share an employee ID but have different birth dates, so the agent flags both and leaves the merge decision to a person.