Work across multiple functional projects to understand data usage and implications for data migration.
Lead the Data Migration stream, ensuring successful migration of all master and transactional data into Oracle Cloud Fusion ERP.
Create and maintain a data migration strategy and produce/quality migration deliverables.
Identify risks and issues in a timely manner and escalate for resolution as needed.
Manage data quality across different phases of the data migration and making sure that data is fit for purpose.
Lead and work collaboratively to ensure data is cleansed in a timely manner.
Provide technical expertise and produce necessary documentation on Extract, Transform and Load (ETL) activities including data cleansing and testing.
Perform data migration audit, reconciliation and exception reporting.
Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.
Work across multiple functional work streams to understand data usage and implications for data migration. Develop and communicate best practices, processes, and standards for effectively carrying out data migration activities.
Lead initiatives for data integrity and governance.
Perform source data identification and analysis in order to manage source to target data mapping.
Managing master and transactional data, including creation, updates, and deletion.
Assist the ERP Programme Technical Lead planning and executing the Oracle ERP implementation programme.
Assist/coach/teach a junior Data Migration Engineer as required.
Provide expert knowledge and leadership in solving complex data migration challenges.
Responsible for team management, scheduling and coordinating resources for all data ETL (Extract, Transform and Load), mapping and cleansing activities.
Manage/Develop migration dress rehearsals, migration cutover plan and post go-live support.
Engage with the Solution Architect to ensure the alignment of the broad architecture viewpoint.
Ensure data migration solutions meet the strategic, financial, reporting and operational requirements of the business.
Responsible for ensuring good data quality, both pre and post migration.
Produce all necessary data migration documentation including overarching strategy, data mapping specifications, data quality metrics and test plans.
Accountable for all data migration artefacts and other deliverables, including migration activity design and rehearsals.
Ensure all deliverables are aligned to all relevant governance requirements, including Design Authorities.
Lead/Participate in programme workshops, meetings and formal events.
Produce robust yet simple data migration routines that are both logical and maintainable.
Produce robust test plans that validate the quality of the migrated data.
Ensure the data migration meets the strategic, financial, reporting and operational requirements.
Ensure successful handover to BAU team. Provide input in to ERP Programme communications.
Accountable for meeting ERP Programme standards.
Experience of leading the data migration stream during a full cycle Oracle Cloud ERP project (with projects, procurement and financials).
Preferably strong Oracle fusion FBDI, OTBI and ADFdi skills Experience of data migration, including data cleansing and data transformation using SQL Scripts.
Strong SQL Server skills including SQL, stored procedures and functions.
SSIS beneficial too.
Strong logical understanding of relational data concepts.
Good general development skills including windows permissions file shares and scheduled jobs.
Experienced in working with both software vendors and system integrators.
Experience of working through all phases in the Project lifecycle.
Strong analytical and problem solving skills with diligent attention to detail and quality of output