Oracle Data Migration Functional Analyst @ SBS

Oracle Techno-Functional Consultant (EBS R12 & Fusion Financials)

Job Description

Role Summary

The Oracle Techno-Functional Consultant will be responsible for implementing, configuring, and customizing Oracle Financials modules in both EBS R12 and Oracle Fusion Financials. The consultant should have strong data migration experience, along with expertise in technical development and functional configurations to support business requirements. This role involves collaboration with business users, data analysis, integrations, and troubleshooting complex issues.

Key Responsibilities

Functional Responsibilities

1. Work closely with finance teams to understand business requirements and translate them into Oracle ERP solutions.
2. Configure, test, and implement Oracle Financial modules, including GL, AP, AR, in both EBS R12 and Fusion Financials.
3. Perform gap analysis and recommend solutions to optimize financial processes.
4. Provide functional support for end-users and assist in UAT, training, and documentation.
5. Work with business users to define Chart of Accounts (COA), Multi-Currency, Ledger Setup, and Reporting requirements.
6. Support month-end and year-end financial closing processes.

Technical Responsibilities

1. Perform data migration from EBS R12 to Fusion Financials, ensuring accuracy and consistency in financial data.
2. Develop custom reports, using PL/SQL, and FBDI/ADFDI tools.
3. Design and implement integrations between EBS, Fusion Financials, and third-party systems using Oracle Integration Cloud (OIC)
4. Write and optimize SQL queries, stored procedures, and performance tuning for Oracle databases.
5. Troubleshoot and resolve technical issues related to data migration, reporting, and integrations.
6. Develop and maintain custom forms, personalization, and extensions for EBS R12.
7. Work on Incident, Problem, and Change Management within ITIL frameworks.

Required Skills & Qualifications

Experience & Technical Skills

1. Experience: 5-10 years of hands-on experience in Oracle Financials, with expertise in both EBS R12 and Fusion Financials.
2. Financial Modules: Strong experience in GL, AP, AR.
3. Data Migration Expertise: Experience in data extraction, transformation, and FBDI, ADFDI, SQL Loader, and API-based migration strategies.
4. Technical Development: Expertise in PL/SQL
5. Integrations: Hands-on experience integrating Oracle ERP with third-party applications and external financial systems.
6. Customization & Reports: Ability to develop custom reports, dashboards, and analytics in Oracle ERP using BI tools.

Soft Skills & Certifications

1. Strong analytical and problem-solving skills to resolve complex financial and technical challenges.
2. Excellent communication skills to interact with business users, finance teams, and IT stakeholders.
3. Ability to work independently and manage the financial system implementations.

Preferred Certifications: Oracle Cloud Financials Certification / Oracle EBS R12 Financials Certification.

Total Experience Expected: 04-06 yearsQualifications

B.Tech