Hastree Technologies is a next-generation global leader in the IT industry, enabling 100+ clients from countries such as India, the U.S., Australia, Canada, and across Europe to navigate their digital transformation. Established in 2019, we expertly guide our clients throughout their digital journeys. We achieve this by offering unmatched solutions that prioritize and execute revolutionary changes, employing innovative strategies, and fostering a culture of continuous learning to deliver exceptional customer experiences.

Salesforce developer

Location : Remote

Experience- 3 to 5 Years.

Notice period- Immediate joiner.

Freelancer allowed ( 7 to 8 hours per day)

We are seeking a skilled Oracle Integration & BI Consultant to design, develop, and support Oracle Integration Cloud (OIC) solutions, BI Publisher (BIP) reports, OTBI reports, and REST API integrations. The ideal candidate will have a strong background in PLSQL, SQL, and Oracle Cloud applications to support business intelligence and integration needs.

Responsibilities:

• Develop and implement integrations using Oracle Integration Cloud (OIC) to connect Oracle Cloud applications with third-party systems.
• Design, develop, and optimize BIP and OTBI reports based on business requirements.
• Write and optimize complex PLSQL and SQL queries for data extraction, transformation, and reporting.
• Work with REST APIs to develop secure integrations between Oracle Cloud and external applications.
• Perform troubleshooting, debugging, and performance tuning for integrations and reports.
• Collaborate with functional and technical teams to understand reporting and integration requirements.
• Maintain documentation for integrations, reports, and system processes.

Required Skills & Qualifications:

• Experience: 3-7 years of hands-on experience in Oracle Integration Cloud (OIC), PLSQL, SQL, BI Publisher (BIP), OTBI, and REST APIs.
• Strong understanding of Oracle Cloud ERP, HCM, and SCM data structures.
• Experience in designing and troubleshooting REST APIs and SOAP web services for Oracle Cloud applications.
• Expertise in BIP template design, OTBI subject areas, and BI reporting.
• Proficiency in PLSQL programming, database tuning, and performance optimization.