Oracle OIC Technical Consultant

Oracle OIC Technical Consultant

Company: Automus
Location: Hyderabad, Telangana
Experience: 1 to 3 Years
Employment Type: Full-Time
Work Model: Hybrid

Notice Period: Immediate to 30 Days

About Automus:

Automus is looking for a motivated and technically skilled Oracle OIC Technical Consultant to join our growing team in Hyderabad. This is an excellent opportunity for professionals with 1 to 3 years of experience who are looking to build their career in Oracle Cloud integration and reporting technologies. The ideal candidate will have hands-on or project exposure to Oracle Integration Cloud (OIC), PL/SQL, BI Publisher (BIP), and Oracle Transactional Business Intelligence (OTBI).

Job Summary:

As an Oracle OIC Technical Consultant, you will work with functional and technical teams to design, develop, test, and support integrations and reporting solutions across Oracle Cloud applications and external systems.

You will be involved in developing integrations using OIC, writing SQL/PL/SQL, creating reports using BIP and OTBI, troubleshooting technical issues, and supporting implementation and enhancement projects.

Key Responsibilities:

• Develop, configure, test, and maintain integrations using Oracle Integration Cloud (OIC).
• Understand business and technical requirements and translate them into scalable technical solutions.
• Design integrations between Oracle Cloud applications and third-party/external systems.
• Work with REST, SOAP, FTP/SFTP, and other integration technologies.
• Develop and maintain OIC integrations, orchestrations, mappings, connections, lookups, and error-handling mechanisms.
• Write and optimize SQL and PL/SQL queries, procedures, functions, and packages as required.
• Develop and maintain BI Publisher (BIP) reports, data models, templates, and extracts.
• Create and support OTBI analyses, dashboards, and reports.
• Perform integration testing, unit testing, system testing, and support UAT activities.
• Troubleshoot integration failures and technical issues and provide root-cause analysis.
• Monitor integrations and ensure timely resolution of errors and failures.
• Support data migration and data extraction activities where required.
• Prepare technical design documents, integration specifications, test cases, and technical documentation.
• Collaborate with functional consultants, business users, and other technical teams.
• Support production deployments, enhancements, and post-production issues.
• Stay updated with Oracle Cloud and OIC quarterly releases and new capabilities.

Required Skills & Qualifications:

• 1 to 3 years of experience in Oracle Cloud technical development/integration.
• Hands-on or project experience with Oracle Integration Cloud (OIC).
• Strong knowledge of SQL and PL/SQL.
• Experience with BI Publisher (BIP) reporting.
• Exposure to Oracle Transactional Business Intelligence (OTBI).
• Understanding of REST and SOAP web services.
• Knowledge of XML, JSON, XSLT, XPath, and data mappings.
• Understanding of integration patterns and error-handling mechanisms.
• Good analytical and problem-solving skills.
• Strong communication and collaboration skills.
• Bachelors degree in computer science, Information Technology, Engineering, or a related field.

Good to Have:

• Experience integrating Oracle Fusion Cloud applications using OIC.
• Exposure to Oracle Fusion ERP, SCM, HCM, or CX applications.
• Knowledge of Oracle ERP Cloud APIs and web services.
• Experience with FBDI and file-based integrations.
• Exposure to Oracle ATP/ADW or other Oracle Cloud databases.
• Knowledge of JavaScript or Groovy is an added advantage.
• Familiarity with OIC monitoring, tracking, and error recovery.
• Experience with Oracle Cloud security and authentication mechanisms.
• Oracle Integration Cloud certification is an added advantage.

What We Offer

• Full-time opportunity with a hybrid work model.
• Opportunity to work on Oracle Cloud integration and technology projects.
• Exposure to OIC, PL/SQL, BIP, and OTBI across real-world business scenarios.
• Learning and career-growth opportunities in Oracle Cloud technologies.
• Collaborative and dynamic work environment.
• Opportunity to work alongside experienced Oracle professionals.

Join Automus

If you are passionate about Oracle Cloud technologies and integration and looking to develop your expertise in OIC, PL/SQL, BIP, and OTBI, this is an excellent opportunity to grow your career with Automus.

Location: Hyderabad, Telangana
Experience: 13 Years
Employment Type: Full-Time
Work Model: Hybrid

Note: Referrals / updated profiles can be shared to the email ID: [email removed]