Senior Data Migration Specialist / ETL Developer

TheCorporate LLC; United States; Remote; USD 110,000 - 160,000; Full time

Job summary

TheCorporate LLC is seeking a Senior Data Migration Specialist / ETL Developer to lead a PeopleSoft-to-Workday migration. You will perform record-by-record reconciliation, refine crosswalks, and validate data integrity across systems in a remote, long-term engagement.

You will collaborate with functional teams and Workday consultants, review FDM mappings, document validation findings, and support UAT to certify readiness for go-live, ensuring no data loss or corruption.

Qualifications

• 84 months of experience in data extraction and transformation for budgets and finance.
• 84 months optimizing SQL queries, Application Engine, and SQR scripts for data migration.
• 84 months mapping PeopleSoft data fields to Workday and resolving inconsistencies.
• 84 months implementing ETL tools and validating data post-migration.

Responsibilities

• Perform record-by-record reconciliation to prevent data loss during migration.
• Refine crosswalks showing PeopleSoft equivalents and Workday integration points.
• Identify data quality issues, unmapped fields, and transformation failures.
• Review how budget data flows into Workday via FDM, ensuring schema compliance.
• Document validation findings with remediation steps and root-cause analysis.
• Collaborate with other teams to solve issues.
• Support UAT and sign-off activities and validate reconciliation results for go-live readiness.

Skills

Data migration

ETL development

PeopleSoft

Workday

SQL optimization

Data mapping

Cross-functional collaboration

Tools

SQL

Application Engine

SQR scripts

ETL tools

Workday integration

Job description

Job Title: Senior Data Migration Specialist / ETL Developer who specializes in PeopleSoft-to-Workday ERP financial migrations.

Location: Remote

Duration: Long term

Interview Mode: Phone then Video

84 months of experience developing and executing data extraction and transformation processes for Budget and Finance.

84 months of experience optimizing SQL queries, Application Engine, and SQR scripts for efficient data migration.

84 months of experience mapping PeopleSoft data fields to Workday equivalents and resolving inconsistencies.

84 months of experience implementing ETL tools and validating data accuracy post-migration.

84 months of experience collaborating with functional teams and Workday consultants for seamless transition.

84 months of experience developing and maintaining clear and consistent documentation for data and conversion processes and procedures.

84 months of experience working collaboratively with various technical teams (but not limited to) such as peoplesoft, workday, database administrators, cybersecurity analysts to ensure comprehensive identity management practices.

Role:

• 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 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-liv