Oracle Data Migration Functional Analyst

About Sopra Steria

Sopra Steria, a major Tech player in Europe with 56,000 employees in nearly 30 countries, is recognized for its consulting, digital services and software development. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group provides end-to-end solutions to make large companies and organizations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a fully collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. In 2023, the Group generated revenues of €5.8 billion.

The world is how we shape it.

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 years

B.Tech

UK Shift

At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.

All of our positions are open to people with disabilities.