Oracle Techno functional Consultant

Kaygen, Inc.; Los Angeles (CA); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Free Healthcare Insurance

Vision and Dental Insurance

401(k) Retirement Plan

Free Life Insurance

Sick Time Off

Job summary

Kaygen, Inc. is seeking an Oracle Cloud Developer / Oracle Fusion techno-functional specialist for a hybrid role in Los Angeles, CA. The position involves end-to-end data migration for Oracle Fusion modules and requires a strong background in SQL, PL/SQL, and ETL tools.

Ideal candidates should have over 4 years of experience with Oracle Fusion ERP Cloud, along with excellent collaboration skills. Benefits include free healthcare and a 401(k) retirement plan.

Qualifications

• 4+ years in Oracle Fusion ERP Cloud data migration.
• Proven experience in at least one full-cycle Fusion implementation.
• Strong knowledge of SQL, PL/SQL, and data migration methodologies.

Responsibilities

• Perform data extraction, cleansing, transformation, and loading (ETL) for Oracle Fusion modules.
• Prepare and maintain data mapping documents.
• Validate migrated data for accuracy and completeness.

Skills

SQL

PL/SQL

ETL tools

Oracle Integration Cloud (OIC)

Data mapping and reconciliation

Tools

FBDI

HDL

ADFDI

Job description

KAYGEN is an emerging leader in providing top talent for technology-based staffing services. We specialize in high-volume contingent staffing, direct hire staffing, and project-based solutions for companies worldwide, ranging from startups to Fortune 500 and Managed Service Providers (MSP).

We are looking for an Oracle Cloud Developer / Oracle Fusion techno-functional specialist. Please share your resume with rate and availability.

Location: Los Angeles, CA • Onsite: Hybrid (3 days per week) • Duration: 6–12 months • Must be local to Los Angeles, CA.

Responsibilities

• 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

• 4+ years in Oracle Fusion ERP Cloud data migration; proven experience in at least one full-cycle Fusion implementation.
• Strong knowledge of SQL, PL/SQL, Oracle tables/data structures, ETL tools, and data migration methodologies.
• Proficiency with FBDI, HDL, ADFDI, ETL tools, OIC, and integration platforms.
• Ability to identify and resolve data quality issues; strong troubleshooting skills.
• 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.

Benefits

• Free Healthcare Insurance
• Vision and Dental Insurance
• 401(k) Retirement Plan
• Free Life Insurance
• Sick Time Off