Job Title: Oracle EBS Technical with JAVA Consultant @ Hyderabad, TS/ REMOTE
Position Overview:
Oracle EBS R12 Technical & with hands on experience in Java needed to work on building Integrations with our building Integrations with Oracle Order Management, Accounts Payable, Accounts Receivable and General Ledger modules. Strong technical experience in PL/SQL and building Interfaces to import Sales Orders and AP Invoices from externa sources is required. Should have moderate knowledge of process flows in the Oracle Order Management, Accounts Payable, Purchase Order and General Ledger.
We have a Java based Application from which integration to Oracle EBS will have to built every time the application is sold to customers that use Oracle EBS.
Position Responsibilities:
Developed and modified database procedures/functions, triggers, packages to enhance and improve functionality using PL/SQL.
Developed SQL*Loader control programs and PL/SQL validation procedures to data from non-oracle sources into Oracle EBS environment.
Developed a PL/SQL package procedure to perform business rule validations based on Business requirement.
Designed and developed functions/ stored procedures/packages/triggers using PL/SQL.
Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL to import the data into staging tables.
Worked on fixing multiple Performance issues due to by introducing new Indexes and modifying PL/SQL join conditions.
Work on Data integration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions etc.
Involved in fine tuning on the SQL and PL/SQL objects, making the programs to execute faster and more efficiently.
Developed custom program to import Sales Orders to Oracle Order Management tables using PL/SQL packages/procedures or standard APIs.
Developed custom program to import Accounts Payable invoice to Oracle Accounts Payable tables using PL/SQL packages/procedures