Senior Oracle Technical Consultant

Job Description

Technical Development & Ricew Objects

• Design and develop technical components including reports, interfaces, conversions, and enhancements (RICEW objects).
• Develop custom reports using BI Publisher, OTBI, Financial Reporting Studio (FRS), Smart View, and HCM extracts.
• Perform page customizations using Sandbox, Redwood, APEX, VCBS, and PCS frameworks.

Integration & Data Management (Oic)

• Design and develop integrations using Oracle Integration Cloud (OIC).
• Build and manage data integrations between Oracle Fusion and third-party systems using REST/SOAP APIs, FBDI, HDL, and HSDL.
• Support data migration, conversion, and automation processes.
• Ensure data accuracy, integrity, and consistency across systems.

Reporting & Analytics (Otbi & Bi Publisher)

• Develop advanced OTBI reports, dashboards, and real-time operational insights.
• Create interactive dashboards and optimize performance and usability.
• Design BI Publisher data models, templates, and bursting reports.
• Customize subject areas and reporting data models.

Hcm Technical Development

• Develop and manage HCM Extracts for reporting and integrations.
• Utilize Oracle HCM Data Loader (HDL) for data migration and maintenance.
• Design and implement Fast Formulas to support HR and payroll business rules.
• Support payroll, benefits, and HR reporting requirements.

Testing, Documentation & Deployment

• Prepare technical design documents, test plans, and user guides.
• Conduct unit testing and system testing; support UAT with business users.
• Ensure smooth deployment and transition of technical solutions into production.

Troubleshooting & Support

• Provide technical analysis and troubleshooting for Oracle Fusion ERP modules (Finance, SCM, HCM).
• Resolve system performance, integration, security, and data issues.
• Collaborate with IT and business teams to ensure timely issue resolution.

Compliance & Best Practices

• Ensure all technical solutions adhere to Oracle best practices and IT governance standards.
• Maintain system security, performance, and scalability.
• Support audits and compliance requirements where applicable.

Stakeholder Collaboration

• Work closely with functional consultants and business users to translate requirements into technical specifications.
• Provide technical guidance and recommendations for system improvements.
• Support cross-functional collaboration across IT, Finance, and HR teams.
• Job requirements
• Qualifications & Certifications & Experience (mandatory & Preferred)
• Bachelor’s degree in Computer Science, Information Technology, or related field.
• Minimum of 6–8 years technical experience in Oracle Cloud.
• Strong hands-on experience with Oracle Integration Cloud (OIC), OTBI reporting and dashboards, BI Publisher.

SKILLS & COMPETENCIES (Technical, Behavioral, and Soft)

• Oracle Integration Cloud (OIC) development and integration design
• OTBI advanced reporting and dashboard development
• BI Publisher (data models, templates, bursting)
• Financial Reporting Studio (FRS) and Smart View
• HCM technical tools (HCM Extracts, HDL, Fast Formulas)
• SQL, data analysis, XML, and XSLT
• REST & SOAP APIs and file-based integrations (FBDI, HDL)
• Oracle SaaS customization tools (Sandbox, Redwood, APEX, VCBS, PCS)

Behavioural Competencies

• Customer Focus - Understands customer challenges and takes initiative to resolve them effectively.
• Accountability and Ownership - Manages projects with minimal supervision and ensures quality results.
• Agility and Adaptability - Manages change smoothly and supports others during transitions.
• Collaboration & Influence - Builds networks across functions and resolves conflicts constructively.
• Result Orientation - Sets clear goals and works proactively to achieve high performance.