Note: The job is a remote job and is open to candidates in USA. Mega Cloud Lab is seeking an experienced Data Migration & Reconciliation Analyst to support a critical PeopleSoft-to-Workday migration. The role focuses on reconciliation, data transformation, validation, exception identification, documentation, UAT support, and go-live readiness for Budget and Finance data.
Responsibilities
- Perform record-by-record reconciliation, aggregate totals validation, and exception identification to ensure no data loss or corruption during the PeopleSoft-to-Workday migration
- Refine data crosswalks showing PeopleSoft field equivalents, data type conversions, formula translations, and Workday FDM integration points
- Identify data quality issues, unmapped fields, transformation failures, and process deviations between legacy and target systems
- Review and validate how PeopleSoft budget data integrates into Workday via the Financial Data Model, ensuring compliance with FDM schema requirements
- Document validation findings and remediation steps; prepare detailed validation reports with exception logs, root cause analysis, and recommended corrective actions for data issues
- Work closely with other teams to identify and solve issues
- Support UAT and sign-off activities
- Collaborate with Budget team members and project stakeholders to validate reconciliation results and certify readiness for go-live
- Perform other duties as assigned
Skills
- • 7 years of experience developing and executing data extraction and transformation processes for Budget and Finance
- • 7 years of experience optimizing SQL queries, Application Engine, and SQR scripts for efficient data migration
- • 7 years of experience mapping PeopleSoft data fields to Workday equivalents and resolving inconsistencies
- • 7 years of experience implementing ETL tools and validating data accuracy post-migration
- • 7 years of experience collaborating with functional teams and Workday consultants for seamless transition
- • 7 years of experience developing and maintaining clear and consistent documentation for data and conversion processes and procedures
- • 7 years of experience working collaboratively with various technical teams (including but not limited to PeopleSoft, Workday, database administrators, and cybersecurity analysts) to ensure comprehensive identity management practices
- • Experience with Active Directory Identity Management (ADIM) consulting
- • Strong analytical and problem-solving skills with attention to detail
- • Excellent communication and stakeholder collaboration abilities
- • Prior experience supporting UAT and go-live certification activities
Company Overview