What are the responsibilities and job description for the Oracle Fusion Data Migration Consultant position at Falcon Smart IT (FalconSmartIT)?
Job Title: Oracle Fusion Data Migration Consultant
Location: Los Angeles, CA (Locals only) Hybrid ( 3 days every week )
Job Type: Contract
Job description:
· End-to-end migration execution : Perform data extraction, cleansing, transformation, and loading (ETL) for Oracle Fusion modules such as Finance, Projects, Inventory, Order Management, Procurement, and HCM
· Data mapping & reconciliation : Prepare and maintain data mapping documents, reconcile source and target data, and resolve discrepancies
· Validation & testing : Validate migrated data for accuracy and completeness; support mock runs, testing, cutover, and go-live activities
· Scripting & automation : Develop and execute SQL/PL/SQL scripts for migration tasks; use ETL tools like FBDI, HDL, ADFDI, and Oracle Integration Cloud (OIC)
· Coordination : Work closely with functional, technical, and business teams to gather requirements, validate templates, and resolve data quality issues
· Documentation : Help develop migration documentation, status reports, and reconciliation reports
· Integration & system design : Design and implement system integrations using OIC or other middleware; ensure data integrity across systems
Required Skills & Experience:
· Experience : 4 years in Oracle Fusion ERP Cloud data migration; proven experience in at least one full-cycle Fusion implementation
· Technical skills : Strong knowledge of SQL, PL/SQL, Oracle tables/data structures, ETL tools, and data migration methodologies
· Tools : Proficiency with FBDI, HDL, ADFDI, ETL tools, OIC, and integration platforms
· Analytical & problem-solving : Ability to identify and resolve data quality issues; strong troubleshooting skills
· Communication : Excellent coordination and collaboration skills with cross-functional teams
Preferred Skills:
· Certifications in Oracle Fusion ERP Cloud and SAP
· Experience with additional SAP and Oracle modules (Finance, SCM, Procurement, HCM)
· Familiarity with data governance, data quality, and reconciliation best practices