ERP Data Migration Engineer

About the job Position Summary We are seeking an experienced ERP Data Migration Engineer to support financial data migration and transformation activities. This role is responsible for designing, developing, and executing data extraction, transformation, validation, and migration processes while ensuring data quality, accuracy, and auditability throughout the migration lifecycle. The ideal candidate will have strong experience with Financials data migrations, including General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Projects, and related financial data domains. Experience with Oracle Fusion Cloud ERP is preferred. Working closely with the Data Architect, Data Analyst, Business Analysts, Functional Consultants, and implementation partner technical teams, this individual will help deliver reliable, repeatable, and well-documented data migration solutions supporting Oracle Financials workstreams, including GL, AP, AR, Fixed Assets, Projects, and related financial data. Key Responsibilities 1. Source-to-Target Mapping, Transformation & Reconciliation Drive source-to-target mapping activities in collaboration with the Data Architect, Data Analyst, Functional Consultants, and business SMEs. Translate approved business and mapping rules into repeatable automated transformation logic. Develop automated reconciliation routines to compare source data, transformed outputs, control totals, exceptions, and migration results. Maintain traceability from source values through mappings and transformations to final conversion outputs. Validate mapping accuracy throughout testing and deployment cycles. 2. Data Engineering & Development Design, develop, and maintain scalable data pipelines supporting ERP implementations. Develop Python-based automation for file processing, data transformation, mapping, validation, reconciliation, and migration preparation. Automate repeatable data-conversion activities across mock migrations, testing cycles, and production cutover. Develop reusable scripts and utilities with appropriate logging, exception handling, configuration management, and reprocessing capabilities. 3. Data Migration Support end-to-end ERP data migration activities. Extract and stage data from multiple financial and enterprise source systems, reports, extracts, spreadsheets, and flat files for profiling, cleansing, mapping, and migration readiness. Support data conversion planning, mock migrations, and production cutovers. Support generation and validation of Oracle Fusion load-ready files, including FBDI files where applicable. Develop processes supporting controlled error handling, correction, reruns, and reprocessing. Collaborate with implementation partner technical teams to coordinate migration activities and avoid duplicate or conflicting work during the migration process. 4. Technical Documentation Create and maintain technical documentation for: Transformation logic. Validation rules. Automation processes and reusable utilities. Error handling and reprocessing procedures. Migration reconciliation activities. Ensure documentation is complete, repeatable, and auditable for future migration cycles and operational support. 5. Data Processing & Query Development - Develop SQL queries and scripts supporting data profiling, transformation, mapping, validation, and reconciliation. 6. Data Quality - Identify and resolve data quality issues. 7. Collaboration Work closely with Data, Functional, QA, Business, and implementation partner teams throughout migration activities. Participate in migration planning sessions and technical design discussions. Required Qualifications Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field. Demonstrated hands-on experience migrating financial data, including multiple financial domains such as GL, AP, AR, Fixed Assets, and Projects. 5+ years of Data Migration, Data Conversion, or Data Engineering experience. Strong Python scripting/development experience for file processing, data transformation, validation, reconciliation, and automation. Strong SQL skills for data profiling, transformation, validation, and reconciliation. Experience building ETL and automated data-conversion processes. Experience performing source-to-target mapping, data transformation, validation, and reconciliation for financial data migrations. Experience developing reconciliation processes using record counts, financial control totals, mapping validation, exception reporting, and rejected-record analysis. Excellent analytical, troubleshooting, and problem-solving skills. Strong documentation and communication skills. Required Technical Skills 1. ERP & Enterprise Platforms - ERP Financials implementation and data migration experience, including GL, AP, AR, Fixed Assets, and/or Projects (Oracle Fusion Cloud ERP preferred). 2. Development & Automation Python. Automation scripting and framework development. File processing and transformation (CSV, Excel, JSON, XML, or equivalent enterprise formats). Git/source control. Logging and exception handling. 3. Database Technologies SQL. Experience querying and validating data across databases, extracts, spreadsheets, flat files, and other source formats. Oracle ATP/PaaS database experience (preferred). 4. Data Integration ETL and Data Conversion Automation. REST APIs. SOAP APIs. Enterprise Data Integration. Oracle Integration Cloud experience (preferred). 5. Data Migration Migration Automation. Source-to-Target Mapping. Data Reconciliation. Data Extraction. Data Profiling. Data Cleansing. Data Transformation. Data Validation. Error Handling and Reprocessing. Oracle FBDI preparation/validation (preferred). Preferred Qualifications Oracle Fusion Cloud certifications. Oracle Cloud Infrastructure (OCI). Hands-on Oracle Fusion data conversion experience, including FBDI. Experience migrating financial data from multiple source systems and formats, including databases, reports, extracts, spreadsheets, and flat files. Experience with enterprise data governance and Master Data Management. Experience working alongside large ERP implementation partners. Experience building repeatable automation supporting multiple mock conversions and production cutover. Familiarity with Agile delivery methodologies. Experience with OCI, Oracle ATP/PaaS databases, or similar cloud data/integration platforms is a plus.