Oracle Consultant

Noida, Uttar Pradesh, India
Dec 02, 2024
Nov 12, 2025
Remote
Full-Time
8 Years
Job Description

As an Oracle Consultant, you will be responsible for providing specialized expertise in Oracle Cloud ERP implementations, integrations, and customizations. You will work remotely with cross-functional teams to design, implement, and optimize Oracle solutions, focusing on cloud-based integrations, data conversions, and custom reporting. This role offers an opportunity to work on cutting-edge Oracle technologies while contributing to large-scale, impactful projects across various industries.

Key Responsibilities

  • Design and implement integrations using Oracle Integration Cloud (OIC) and Visual Builder Cloud Service (VBCS) for seamless data flow across enterprise systems.
  • Work with SOAP, RESTful web services, and Oracle adapters (File/FTP, DB, REST, SOAP) to ensure smooth integration between Oracle Cloud ERP and other systems.
  • Develop customizations using Oracle PaaS solutions, including VBCS, DBCS/ATP, and Visual Builder Studio for web and mobile apps.
  • Lead or contribute to at least two successful Cloud ERP implementations using Oracle Cloud ERP modules.
  • Collaborate on cloud configurations, setup, and customizations through Application Composer and Page Composer.
  • Conduct thorough testing and validation of integrations and customizations to ensure performance and functionality meet business needs.
  • Execute data conversion tasks using FBDI/HDL templates, ensuring smooth migration and integration of large datasets into Oracle Cloud ERP.
  • Implement complex integrations involving REST and SOAP web services, ensuring secure and efficient data exchange across platforms.
  • Develop and customize BIP (BI Publisher) reports to meet specific business requirements.
  • Create and manage custom ESS (Enterprise Scheduler Service) jobs to automate processes and enhance system performance.
  • Implement security protocols for web services, including WS-Security, to safeguard sensitive business data during integrations.
  • Troubleshoot and resolve any integration or configuration issues, providing effective solutions to meet deadlines.
  • Collaborate with business analysts, functional teams, and technical architects to define integration requirements and customize solutions.
  • Provide post-implementation support and troubleshooting, ensuring smooth operations post-deployment.

Required Skills and Experience

  • Hands-on experience with Oracle Integration Cloud (OIC) and Visual Builder Cloud Service (VBCS).
  • Proficiency in building integrations through REST and SOAP web services.
  • Strong experience with FBDI (File-Based Data Import) and HDL (HCM Data Loader) for data conversions and integrations.
  • Familiarity with PaaS (Platform-as-a-Service) technologies, including OCI (Oracle Cloud Infrastructure) and DBCS/ATP (Autonomous Transaction Processing) databases.
  • Knowledge of cloud storage and security models in Oracle Cloud, particularly in relation to integration.
  • At least two implementation projects in Oracle Cloud ERP, including hands-on experience with cloud configurations, setup, and customizations using Application Composer and Page Composer.
  • Expertise in working with various Oracle integration adapters, including File/FTP Adapter, DB Adapter, REST Adapter, SOAP Adapter, and Oracle ERP Cloud Adapter.
  • Strong knowledge of WS Security, PL/SQL, and concepts of Java, JavaScript, and Regular Expressions.
  • Experience in developing BIP Reports and creating custom ESS Jobs in Oracle Cloud environments.

Nice to Have Skills

  • Familiarity with Oracle ERP modules (Financials, Procurement, HCM, etc.) and their integration patterns in the cloud.
  • Knowledge of other Oracle cloud services and tools, including Oracle Autonomous Database and Oracle SOA Suite.
  • Experience with Agile methodologies and project management tools like Jira.

Why Join Insight Global?

  1. Innovative Projects. Work on enterprise-level Oracle Cloud implementations, helping leading businesses optimize their ERP systems.
  2. Collaborative Team. Join a team of experts where you will have opportunities to share your expertise and collaborate with industry professionals.
  3. Career Growth. Insight Global supports your career development with opportunities for training, certifications, and leadership roles in future projects.
  4. Remote Flexibility. Enjoy the flexibility of working from anywhere in India while contributing to a global client base.