Salary: £50,000 - 70,000 per year Requirements: Strong understanding of data cleansing and staging techniques Experience with ETL tools, data integrity strategies, and large-scale data migrations Knowledge of Oracle ERP 11i data structures and related tables Experience working within Oracle Cloud / Oracle Fusion environments Strong experience with Oracle SQL and PL/SQL Solid understanding of Oracle ERP (Financials, SCM, Projects) and Oracle Cloud Fusion database architecture Experience with joins, subqueries, analytic functions, and performance tuning of data extractions Knowledge of ETL methodologies and automation techniques Experience using PowerShell or other scripting/automation tools Experience working with Oracle Fusion ERP FBDI templates Responsibilities: Design, develop, and execute data migration extract routines to support ERP data migration into Oracle Cloud Ensure data is extracted and transferred accurately, securely, and efficiently, maintaining data integrity and quality Analyse source systems, data models, and data structures Profile source data to identify data quality issues, gaps, and anomalies Collaborate with business and technical teams to understand data usage, dependencies, and criticality Design the data migration approach for extracts and transfer procedures Develop ETL/ELT processes and scripts to support data migration activities Implement reconciliation, validation, and error-handling mechanisms Define data transformation rules and ensure traceability of changes Execute data migrations across development, test, and production environments Coordinate with DBAs to ensure appropriate backups are in place to support extract routines Perform multiple iterative cycles including unit testing, mock runs, and cutover rehearsals Support go-live activities and post-migration stabilisation Execute data extracts, reconciliations, and completeness checks Investigate and resolve data defects and discrepancies Ensure migrated data meets defined business and functional requirements Produce and maintain comprehensive migration documentation Maintain an audit trail of data transformations performed Ensure migration processes are controlled, repeatable, and compliant with internal governance standards Technologies: Cloud ETL ERP Support Oracle PowerShell SQL More: We are AMS, a global workforce solutions partner dedicated to building inclusive and dynamic workplaces. As we support PwC in their contingent recruitment processes, we are committed to connecting skilled professionals with meaningful opportunities. We cultivate a culture of high performance founded on exceptional quality and ethical standards. We are currently seeking a Data Migration Engineer (Oracle) for a 6-month contract based in Rochester (flexible). This role provides a chance to work within a diverse team, contributing to significant projects that drive impactful change. last updated 10 week of 2026