Sr. Oracle Developer

Indigo Beam; United States; Remote; USD 96,000 - 165,000; Full time

Job summary

Indigo Beam Consulting is seeking a Sr. Oracle Developer for a fully remote engagement of 3+ months with a path to W2 full-time employment.

The role focuses on Oracle EBS customization, data migration, and integration, leveraging OAF, PL/SQL, APEX, and XML Publisher to deliver robust enterprise solutions. The candidate will work across modules like EAM, Order Management, Purchasing, Install Base, and Inventory, ensuring performance and maintainability while collaborating with business

Qualifications

• Deep knowledge of OAF components including ViewObjects, ApplicationModules, EntityObjects and ControllerUpdates.
• Proficient in PL/SQL, SQL, Java, Oracle Forms, Reports, WorkflowBuilder, JDeveloper.
• Experience with Oracle Database and related tools for performance tuning.
• Knowledge of different versions of Oracle EBS (R12 and beyond) and their features.

Responsibilities

• Customization and Development: Develop and customize Oracle EBS modules using OAF components, PL/SQL, APEX, Reports, and XML Publisher.
• Integration: Implement integrations with third-party applications using APIs, FTP, and Web Services.
• Data Management: Data migration and conversion tasks, involving data extraction and transformation.
• Support and Maintenance: Provide ongoing support for existing EBS applications and resolve issues as they arise.
• Performance Tuning: Identify and resolve performance issues in EBS applications and optimize PL/SQL code and SQL queries.
• Documentation and Training: Train end-users on new features and custom applications.

Skills

OAF components

PL/SQL

SQL

Java

Oracle Forms

Reports

Workflow Builder

JDeveloper

APEX

XML Publisher

Oracle EBS

Tools

APEX

XML Publisher

Oracle Workflow Builder

JDeveloper

Job description

Indigo Beam Consulting provides a common-sense approach to solving business problems through technology.

Born out of Bluware Inc. which has been in business for twenty-seven years, Indigo Beam was conceived as a full-service business consulting company that deeply cares about creating technology solutions that are in harmony with the environments in which they exist.

We believe that for a technology solution to be sustainable, it must be congruent with the business processes it serves, indigenously maintainable, and cognizant of the unique traits of the organization which it calls home.

Job Description

This is a remote position.

Position: Sr.OracleDeveloper

Contract: 3+months,withpossibilitytobecomeaFTE(W2)

KeyResponsibilities

CustomizationandDevelopment:

• DevelopandcustomizeOracleEBSmodulesusingOAFcomponents,PL/SQL,APEXapplicationplatform,Reports,andXMLPublisher.
• CreatecustomworkflowsandapprovalprocessesusingOracleWorkflowBuilder.
• FamiliarwithAIMmethodology
• ExperiencewithJdeveloper
  

Integration:

• Implementintegrationswiththird-partyapplicationsusingAPIs,FTP,andWebServices
• DevelopCustomWebADIsolutionstoretrieveandloaddatausingexcel.

DataManagement:

• Managedatamigrationandconversiontasks,ofteninvolvingdataextractionandtransformation.
• WriteSQLscriptstoqueryandmanipulatedatawithinOracledatabases.
  

SupportandMaintenance:

• ProvideongoingsupportforexistingEBSapplicationsandresolveissuesastheyarise.
• Conductsystemtestingandvalidationfornewfeaturesandenhancements.

PerformanceTuning:

• IdentifyandresolveperformanceissuesinEBSapplications.
• OptimizePL/SQLcodeandSQLqueriesforbetterperformance.

DocumentationandTraining:

• Trainend-usersonnewfeaturesandcustomapplications.

OracleModules:

• EnterpriseAssetManagement,OrderManagement,Purchasing,InstallBase,Inventory,inOracleE-BusinessSuiteR12.2
  

Requirements

Requirements

Requirements:

• DeepknowledgeofOAFcomponentsincludingViewObjects,ApplicationModules,EntityObjectsandControllerUpdates
  
• ProficientinPL/SQL,SQL,Java,OracleForms,Reports,WorkflowBuilder,JDeveloper
  
• ExperiencewithOracleDatabaseandrelatedtoolsforperformancetuning.
  
• KnowledgeofdifferentversionsofOracleEBS(R12andbeyond)andtheirspecificfeatures.
  

SoftSkills

• Stronganalyticalskillstodiagnoseandsolveissues.
• Abilitytocollaboratewithfunctionalteamsandstakeholderstogatherrequirementsandcommunicatetechnicalconcepts.
• GuidejuniordevelopersandprovideknowledgetransfersessionsonbestpracticesinOracledevelopmenttools.
• Excellentwrittenandoralcommunication,InterpersonalandAnalyticalskills