PUNE · FULLTIME
INTERNAL Oracle Technical Consultant (Reporting, Integration, ERP)
Jade Global
Pune · onsite · Posted 13d ago
Sourced from
Not disclosed4–7 yrsfulltimePune
Your match
?
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
Key Responsibilities
- Integration & Data Migration:
- Design, develop, and maintain cloud-to-cloud and cloud-to-on-premise integrations using Oracle Integration Cloud (OIC).
- Build scalable interfaces utilizing REST/SOAP APIs, FBDI (File-Based Data Import), and ADFdi templates for inbound/outbound batch and real-time processing.
- Configure custom ESS (Enterprise Scheduler Service) jobs to automate technical tasks, data loads, and interface processing.
- Monitor OIC instances, diagnose interface errors, handle payload failures, and maintain technical documentation.
- Reporting & Analytics:
- Design and maintain operational reports, layouts, and data models using BI Publisher (BIP), OTBI (Oracle Transactional Business Intelligence), and FRS (Financial Reporting Studio).
- Write, optimize, and test complex SQL queries and PL/SQL procedures against Oracle SaaS/PaaS database structures.
- Develop custom BI Publisher templates (e.g., eText, RTF, XSL-FO) for invoices, purchase orders, payment files, and compliance outputs.
- Technical Delivery & Support:
- Translate functional specifications into Low-Level Technical Design (LLD) documents (e.g., RICEFW objects).
- Assist with quarterly Oracle Cloud release patch analysis, regression testing, and interface validation.
- Troubleshoot production issues, identify root causes, and resolve ticket escalations adhering to established SLAs.
- Education: Bachelor's degree in Computer Science, Information Systems, Software Engineering, or equivalent practical experience.
- Experience: 4–7+ years of hands-on experience as an Oracle Technical Consultant, with at least 2 full-lifecycle Oracle Cloud ERP implementations.
- Oracle ERP Modules: Deep technical familiarity with Oracle Cloud ERP (Financials, Procurement, SCM) data models and standard APIs.
- Integrations Platform: Hands-on experience with Oracle Integration Cloud (OIC), SOA Suite, and web services protocols (REST, SOAP, JSON, XML).
- Reporting Architecture: Advanced skills in Oracle BI Publisher, OTBI, SQL, and PL/SQL.
- Data Load Tools: Hands-on usage of FBDI, ADFdi, and Oracle WebCenter Content (UCM) APIs.
- Strong problem-solving and analytical skills with high attention to performance tuning.
- Excellent written and verbal communication skills to collaborate effectively with functional teams and external stakeholders.
Sourced from foundit
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02
Skills
adfdiOTBIJSONCloud ErpPLSQLXMLSQLREST APIBi PublisherFbdiSOAPOracle Integration Cloud OIC
Section · Company
About Jade Global
Jade Global
IT Services & Consulting
1.2k+
employees
2003
23 years old
Pune, Maharashtra
India
About
Jade Global offers top-of-the-range technology with deep domain expertise. They deliver IT services, outsourcing, digital solutions, consulting and business services to clients across the globe.
Industries
IT Services & Consulting
Employee ratings
381 reviews
3.4/ 5
Culture
3.4
Career growth
2.9
Work-life
3.4
Employees rate it well for
Work Life Balance53Work Culture50Senior Management45Salary39Job Security31
Find them on