Job Summary
Defines and executes validation, reconciles source-to-target data, validates metadata, version history and OUWM outputs, tracks defects, supports triage, and prepares sign-off evidence
Key Responsibilities
Purpose
Validates SharePoint and OUWM-related migration completeness, accuracy, metadata quality, version-history preservation, and usability of migrated content in ProjectWise. This role supports wave-level readiness checks, defect tracking, reconciliation reporting, and customer sign-off.
Key Responsibilities
- Define and execute migration validation approach, including source-to-target reconciliation, file counts, metadata checks, version-history checks, and sampling rules.
- Validate migrated SharePoint documents, folders, metadata, permissions where applicable, and ProjectWise document property values.
- Validate OUWM-related migration outputs, including CAD/DGN files, reference relationships, design document attributes, and SAP Notification/Work Order alignment.
- Track validation defects, support triage with migration engineers and SMEs, and confirm remediation before wave sign-off.
- Prepare wave-level validation reports, exception summaries, sign-off evidence, and customer-ready approval documentation.
Skill Requirements
- Data reconciliation scripting — record-count comparisons, checksum/hash validation, and metadata-field comparison between source and target
- Sampling methodology design — defining statistically reasonable spot-QA sample sizes per migration wave and per content type
- Version history validation — confirming complete major/minor version chains and correct revision authorship post-migration
- CAD/DGN-specific validation — verifying reference-file integrity and file-open validation post-migration in coordination with the Bentley OpenUtilities (OUWM) SME and technical SMEs.
- Experience validating both structured (SAP/OUWM property data) and unstructured (SharePoint document/version) content migrations within the same program
- Sign-off reporting — producing wave-level validation reports in a format suitable for customer review and approval gates
- Basic SQL and reporting tool proficiency (e.g., Power BI, Excel with Power Query) for reconciliation reporting
Experience
5+ years QA/data validation experience in migration or data engineering projects, ideally including document/content management system migrations.