Job Description
#HIRING for a *Lead Oracle EBS/Data Engineer*!
- 100% Remote
- EST-PST Hours
- 8+ years of experience working with ERP applications and data
- Lead level Data Engineering skills and ability to build pipelines
- STRONG familiarity with Oracle EBS and the following product lines: Finance, Manufacturing, Supply Chain Management
- Ability to design and develop custom pages, forms, and extensions within Oracle EBS using OAF.
- Ability to integrate and call JSP pages from within Oracle Application Framework (OAF)
Pay rate: $85-$105/HR
* LONG TERM CONTRACT
- Medical, Dental, Vision, 401k benefits available for use starting Day 1
- Description:*
Our client, an eCommerce Tech Giant, is looking for a Sr. ERP Consultant/Data Engineer who can work as the middle-man between their ERP and Data Lake teams. They need someone who can extract the data from their ERP applications and pass along to the Data Lake team. They are looking for a technical consultant who can create a data pipeline between their ERP and Data Lake.
They are looking to develop dashboards that can be used by the manufacturing, finance, and supply chain teams. This person will be working on an ERP team within the Robotics org that has business users from each of the previously mentioned domains. On top or strong ability to work hands on with Data, this person needs to have a very strong understanding of Oracle EBS. Below are the desired required skills and abilities for each of the product lines:
FINANCE
- Provide solutions and technical advice, work directly with business users/ System Analysts / stakeholders / DBA.
- Work on General Ledger, Accounts Payable, Accounts Receivable, Cash
MANUFACTURING (MFG)
- Provide solutions and technical advice, work directly with business users/ System Analysts / stakeholders / DBA.
- Work on BOM, WIP, Costing, Quality & Planning functional areas
Supply Chain Management (SCM)
- Provide solutions and technical advice, work directly with business users/ System Analysts / stakeholders / DBA.
- Work on INV, PO, OM, Shipping, Receiving & Planning functional areas
ORACLE OAF & JSP
a) Work closely with functional teams to understand business requirements and translate them into technical solutions.
b) Design and develop custom pages, forms, and extensions within Oracle EBS using OAF.
c) Develop custom OAF pages to meet specific project requirements.
d) Work on integrating JSP Components into EBS applications.
e) Integrate and call JSP pages from within Oracle Application Framework (OAF)
f) Handle the deployment of OAF customizations and JSP pages to ensure seamless integration and functionality
Perform application system administration functions specific to application setup, configuration and maintenance.
d) Oversee small projects and/or tasks / or technical object development and phases of larger projects. Responsible for coordinating activities of teams, schedules, and resources for assigned tasks or projects.
e) Develop and maintain technical documentation, including solution designs, architectural diagrams, and data models for cloud-based deployments. f) Provide technical expertise, and guidance, in the development and implementation of integration solutions.
g) Develop reports in oracle BI publisher/Xml publisher like and register them as concurrent Programs as required
h) Convert oracle Seeded reports in Reports to XML reports as needed or recommended.
i) Design and develop various PLSQL programs and register them as concurrent programs to fetch the data and write to Comma Separated files (CSV) in the predefined Server location. Utilize UTL_FILE Utility for writing data to the file in middle tier.
j) Develop technical solutions with APIs, Advanced PL/SQL, Oracle Forms/Reports, Open Interfaces, UNIX and OAF.
k) Work in EBS/applications INTEGRATIONS using SOA – Work with stakeholders (database administrators and functional team) to troubleshoot application, integration and database related issues
l) Create Packages and Stored Procedures.
m) Prepare the Unit Test Plans and involved in Testing.
n) Prepare reconciliation scripts for post data migration.
o) Prepare migrating and deployment documents (MD70, MD120).
p) Create Concurrent Programs to call shell script.
q) Customize report templates xml publisher reports.
r) Analyze formal test results to discover and resolve defects, bugs, errors, configuration issues, and interoperability flaws. s) Create Oracle Alert triggers.
t) Work on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
u) Utilize FND_LOAD for data migration of various system administration objects, between various instances such as Menus, Custom Responsibilities and Programs, Value Sets and others.
v) Prepare Functional Specification (MD050), Technical Design (MD070), setup and UTP Documents
w) Post deployment support as required.
x) Involve in Deployment Code Plan before cutover, validating all the Integration Endpoints, Recon Reports and also generating the reports through Excel Macros.
y) Create test data in TEST Environment based on the scenarios given to test functionality & for defect management.
z) Work with the reporting team to ensure that correct data is presented in the reports & get signoff from business.
*Skills:*
Oracle EBS, Pl/SQL, Oracle, Supply chain, AWS, oracle financials, Oracle manufacturing, Data
- Additional Skills & Qualifications:*
- Strong experience working with ERP systems and applications
- Familiarity with AWS is a nice to have
- Experience with Data Visualization
- Ability to create Data pipelines
- Experience Level:*
Expert Level
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Job Tags
Contract work,