Oracle Fusion Technical Lead Consultant

De Novo Solutions; Chennai District; On-site; INR 3,000,000 - 6,000,000; Full time

Benefits offered by this job

Term Life Insurance

Mediclaim

Accident insurance

Oracle Cloud training

Job summary

De Novo Solutions in Chennai, India, seeks an Oracle Fusion Technical Lead Consultant to design, develop, and deliver Oracle Cloud data migration, integration and reporting across client programmes. The role focuses on OIC, HDL, FBDI, OTBI, FRS, BIP and OAX/OAS with strong stakeholder management and cross-teams collaboration.

You will guide architectural decisions, build reusable assets, and mentor junior consultants while ensuring delivery quality.

Qualifications

• Bachelor's degree in computer science, information technology, or related field.
• 7–10 years of Oracle Fusion technical experience in enterprise environments.
• Experience delivering Oracle Cloud programmes in a consulting setting.
• Strong understanding of Oracle Cloud integrations and reporting tools.

Responsibilities

• Design and delivery of enterprise integration solutions across Oracle Cloud platforms.
• Develop and validate data migration and integration designs with HDL, FBDI, and UCM.
• Create OTBI, FRS, BIP reports and dashboards for business users.
• Support junior consultants and contribute to reusable templates and playbooks.
• Ensure security, RBAC, and governance in Fusion environments.

Skills

Oracle Fusion Technical

Integration architecture

Stakeholder management

Consulting experience

Data migration

Reporting design

Team leadership

Education

Bachelor's degree in computer science / IT

Tools

OIC

HDL

FBDI

OTBI

FRS

BIP

OAX/OAS

UCM

SFTP

Job description

Role

We are seeking an Oracle Fusion Technical Lead Consultant who contributes to the design, development, and delivery of Oracle Cloud data migration, Integration and Reporting across multiple client and internal programmes.

This role requires strong expertise in Oracle Integration Cloud (OIC), HCM Data Loader (HDL) and File-Based Data Import (FBDI), Oracle Transactional Business Intelligence (OTBI), Financial Reporting Studio (FRS), Oracle Business Intelligence Publisher (BIP), Oracle Analytics Cloud (OAX/OAS), and associated Oracle technologies, combined with good communication and stakeholder management skills to work effectively across delivery environments.

As the Oracle Fusion Technical Consultant, you will contribute to all technical standards and design decisions, support junior consultants, and help ensure delivery quality across projects.

You will also contribute to building reusable assets and the long-term technical capability of the organisation. This role requires working in a customer-facing capacity and requires stakeholder management, including client and cross-functional teams. Strong experience working in distributed teams across time zones is essential.

Integration Architecture & Solution Design

• Contribute to the design and delivery of enterprise integration solutions
• Support integration architecture decisions across Oracle Cloud platforms
• Design REST, SOAP, file-based, and event-driven integrations
• Contribute to reusable integration frameworks and templates
• Support integration error handling, logging, and monitoring strategies
• Ensure integrations follow best practices and architectural standards
• Provide guidance on complex integration challenges

Data Migration

• Contribute to the design and delivery of data migration solutions
• Support migration architecture decisions across Oracle Cloud platforms
• Contribute to data migration approach and scope documentation
• Support data mapping, transformation, and cleansing activities

Reporting Architecture & Solution Design

• Contribute to the design and delivery of enterprise reporting solutions
• Support reporting architecture decisions across Oracle Cloud platforms
• Design OTBI analyses, dashboards, and subject area models
• Develop FRS reports and management packs for financial reporting
• Build and maintain BIP report templates (RTF, Excel, PDF)
• Contribute to Oracle Analytics Cloud (OAX/OAS) datasets, workbooks, and dashboards
• Contribute to reusable reporting frameworks and templates
• Support reporting error handling, scheduling, and distribution strategies
• Ensure reports follow best practices and architectural standards

Oracle Integration Cloud Development – Design, Build, Test and Support delivery of:

• REST and SOAP integrations
• Orchestration integrations
• File-based integrations (HDL / FBDI / UCM / SFTP)
• Event-driven integrations
• API-based integrations
• Integration monitoring and troubleshooting

Ensure strong implementation of:

• Error handling
• Retry mechanisms
• Logging frameworks
• Performance optimisation

Oracle Fusion Security – Mandatory understanding and hands-on experience in Oracle Fusion Security, including:

• Role-based access control (RBAC)
• User provisioning and role assignment
• Job roles, abstract roles, and custom roles
• Data Security Policies
• Function Security Policies
• Security Console configuration and troubleshooting
• Understanding of security inheritance and access control within Oracle Fusion

Technical Leadership & Capability Development

• Support and share knowledge with junior consultants
• Provide technical acumen across multiple concurrent programmes
• Follow and contribute to integration and migration design standards
• Contribute to reusable migration/integration patterns and accelerators
• Contribute to internal documentation and playbooks
• Participate in knowledge sharing across distributed teams
• Conduct peer reviews and technical quality assurance

Skills & Experience:

Essential:

• 7-10 years Oracle Fusion Technical experience
• Proven experience delivering at least two Oracle Cloud programmes.
• Experience working in a consulting environment
• Strong understanding of:
• Oracle APIs
• Business objects
• Oracle integration use casesxx

Technical Experience (Integration):

• Oracle Integration Cloud (OIC)
• REST and SOAP API integrations
• File-based integrations
• Event-driven integration patterns
• Integration troubleshooting
• Oracle Fusion integrations (HCM / ERP)
• Integration monitoring and logging
• Integration architecture design
• Integration testing frameworks

Development experience:

• JSON and XML

Technical Experience: (Migration):

• Oracle HCM Data Loader (HDL)
• File-Based Data Import (FBDI)
• Oracle Fusion data migrations (HCM / ERP)
• Data mapping and transformation
• Data cleansing and quality assessment
• Migration reconciliation and validation
• UCM upload and management
• Migration troubleshooting and error resolution

Development Experience:

• Excel and CSV data manipulation
• SQL and data querying
• XML and JSON data formats
• Git version control
• Migration testing and reconciliation frameworks

Technical Experience: Reporting:

• Oracle Transactional Business Intelligence (OTBI)
• Financial Reporting Studio (FRS)
• Oracle Business Intelligence Publisher (BIP)
• Oracle Analytics Cloud (OAX / OAS)
• Oracle Fusion reporting (HCM / ERP)
• Report performance tuning and troubleshooting
• Security and data access configuration
• Report scheduling and distribution

Development Experience:

• SQL and data querying
• RTF and XML template design
• Excel-based reporting
• Git version control
• Reporting testing frameworks

Desirable:

• Oracle Cloud HCM or ERP Certification
• Oracle Cloud Infrastructure Certification
• Experience with Oracle Redwood / Visual Builder
• Experience with OCI services
• Experience designing reusable integration frameworks
• Experience building integration standards
• Experience working in large enterprise programmes
• Experience leading distributed global teams
• Develop integrations across: (atleast any two of the below)
• Oracle HCM Cloud
• Oracle ERP Cloud
• Payroll integrations
• HR and Finance business processes
• Oracle Cloud Infrastructure Integration Services
• Experience supporting integration architectures using: (Desirable/Good to have)
• OCI API Gateway
• OCI Object Storage
• OCI Functions
• OCI Events
• OCI Security principles

Person Specification:

• Ethical Conduct: Commitment to ethical standards, integrity, and compliance with relevant regulations and organizational policies.
• Teamwork: Strong interpersonal skills and a track record of working effectively within cross-functional teams, including stakeholders.
• Customer Service Orientation: Focus on meeting internal and external customer needs, providing responsive support, and building positive relationships with stakeholders. High level of adaptability and flexibility, with the ability to build strong long-lasting client relationships.
• Continuous Learning: Willingness to learn and develop new skills, stay updated on industry trends, and pursue professional development opportunities to enable growth. A growth mindset with a commitment to continuous improvement; for yourself, your team, and your clients.
• Consulting Skills:Strong consulting skills are essential for effectively communicating with clients, understanding their needs, providing recommendations, and guiding them through the implementation process. This includes active listening, problem-solving, and client relationship management.
• Analytical & Problem-Solving: Tailoring solutions to business goals, processes, and constraints.

Qualifications

Bachelor’s degree in computer science, Information Technology, or related field.

Compensation & Benefits

Salary – Best in Industry
Benefits – Term Life / Mediclaim / Accident insurance
Training – Certified training in Oracle Cloudas required by your role.