Job Description
Job Title: Data Lead - Oracle ERP Data Governance
Contract: 3 Years
Location: Chicago, IL (Remote)
Knowledge, Skills and Abilities: - Experience in migrating master data and transactional data from On-Premise Oracle E-Business and Oracle PeopleSoft to Oracle Fusion Cloud.
- Expertise in Data Migration of Master data and transactional data including Extraction, Cleansing, Transformation, Loading and Validation from Legacy systems to Oracle Fusion Cloud.
- Experience with Data Migration activities for Master Data such as COA, Employee, Suppliers, Assets etc., and Transactional and Historical data.
- Experience with Oracle Data Migration and integration processes including preparation of migration strategy, conversion plan, timing of data loads, object dependencies, sequencing of tasks.
- Experience in using ADFdi, FBDI, ETL and SQL and any third party tools used for data migration.
- Ability to work with large scale ERP program system integrators for timely completion of each phase
- Experience in working with Oracle Financials, Procurement, Assets, Projects, Grants HCM and Time and Labor Cloud modules.
- Specialized in Payroll data conversion, reconciliation.
- Excellent oral and written communication skills.
- Extensive interaction with functional and technical leads,business users, and SMEs.
- This data lead will be responsible for the orchestration of On-Premise Oracle E-Business and Oracle PeopleSoft data migration activities to Oracle Fusion Cloud to meet business requirements. The Data Lead is accountable for the following responsibilities:
- Developing data governance policy, plans, and procedures with solid experience in developing data cleansing strategies, action plans, reconciliation plans and scripts.
- Good experience in understanding data models, data integrity and normalization rules, data extraction, load and transformation scripts.
- Functional experience to understand the business context of data in Oracle E-Business Financials and Procurement, and Oracle PeopleSoft HCM and Payroll and migrating the on-premises data to relevant Oracle Fusion Cloud Services.
- Determining the validity of the values of the data elements and reviewing and validating data relationships.
- Coordinating with data owners to validate cleansed data.
- Determining data migration requirements.
- Defining roles and responsibilities for the data migration activities.
- Establish policies, procedures around data governance including data retention, data archival and purging.
- Reviewing and providing comments and suggestions on the data management plan, data migration plan, checklist, timeline, and conversion report delivered.
- Documenting migration activity timelines for mock conversions and production deployment.
- Developing a data migration checklist and sign-off process to ensure completion of planned activities.
- Mapping the data in the format provided in conversion templates. This includes mapping the current account codes to the future account codes etc.
- Assisting with determining data migration security controls.
- Developing unit and end-to-end integration migration test plans (including testing for data extraction, transformation, data loading, and data validation).
- Solid experience with data transformation and data load testing and related tools and technologies.
- Validating data of multiple mock conversions and the full migration coordinating with unit and end-to-end integration testing to ensure the flow of data from the source applications to the target applications is accurate.
- Documenting the end-to-end data migration test results and lessons learned report.
Job Tags
Contract work, Remote job,