Job Description: Senior Oracle Fusion Technical Consultant (ERP/Reporting)
Location: Kolkata and Noida
Job Type: Full-time
Experience: 2- 5+ Years in Oracle Fusion
Job Summary
We are seeking an experienced Oracle Fusion ERP Technical Consultant to join our team. The ideal candidate will have hands-on experience in full-cycle Oracle Cloud ERP implementations, specializing in reporting (OTBI/BIP), Data Integration, and complex PL/SQL development. You will be responsible for designing and developing technical solutions to meet business requirements, ensuring data accuracy, and bridging the gap between functional requirements and technical execution.
Key Responsibilities
- ERP Implementation: Actively participate in the full-cycle implementation of Oracle Fusion Cloud ERP (Finance/SCM modules), including requirement gathering, design, development, testing, and go-live support.
- Reporting & Analytics (BIP/OTBI):
- Design, develop, and maintain complex BI Publisher (BIP) reports using RTF, Excel, and E-Text templates.
- Create advanced OTBI reports and dashboards across Finance/SCM modules.
- Optimize BIP/OTBI report performance to ensure quick data retrieval.
- Data Integration & Conversion:
- Develop data conversion and migration scripts using FBDI (File-Based Data Import) and ADFdi (Application Development Framework Desktop Integration).
- Design inbound/outbound integrations using Oracle Integration Cloud (OIC) or REST/SOAP APIs.
- PL/SQL & Technical Development:
- Write advanced PL/SQL procedures, functions, and packages for data transformation and reporting within BIP reports.
- Troubleshoot and fix data discrepancies, performing root cause analysis.
- Technical Documentation: Prepare and maintain technical design documents (TDD) and low-level design documents (LLD) based on business requirements.
Required Skills & Experience
- Mandatory: 3-5+ years of hands-on experience with Oracle Fusion Cloud ERP modules.
- Mandatory: Expert knowledge in BI Publisher (BIP) and OTBI.
- Mandatory: Proficient in SQL, PL/SQL.
- Mandatory: Expertise in Fusion data integration tools: FBDI, HDL, and ADFdi.
- Experience in designing RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
- Understanding of Oracle Fusion security roles and data access rules.
- Excellent analytical, problem-solving, and communication skills.
Preferred Qualifications
- Oracle Cloud Application Certification.
- Experience with BICC (BI Cloud Connector) data extracts.
- Familiarity with OIC (Oracle Integration Cloud) and Groovy scripting.
Education
- Bachelor's/Master's degree in Computer Science, Information Technology, or related field.
