Lead Oracle EBS/Data Engineer

2 weeks ago

Detroit MI United States TEKsystems Full time

#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.

  • Lead Oracle EBS/Data Engineer

    2 weeks ago

    Detroit, MI, United States TEKsystems Careers Full time

    HIRING for a *Lead Oracle EBS/Data Engineer*! * 100% Remote * 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,...

  • Lead Oracle EBS/Data Engineer

    2 weeks ago

    Detroit, MI, United States TEKsystems Careers Full time

    #HIRING for a *Lead Oracle EBS/Data Engineer*! 100% RemoteEST-PST Hours8+ years of experience working with ERP applications and dataLead level Data Engineering skills and ability to build pipelinesSTRONG familiarity with Oracle EBS and the following product lines: Finance, Manufacturing, Supply Chain ManagementAbility to design and develop custom pages,...

  • Lead Oracle EBS/Data Engineer

    2 weeks ago

    Detroit, United States TEKsystems Careers Full time

    #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...

  • Lead Oracle EBS/Data Engineer

    2 weeks ago

    Detroit, United States TEKsystems Full time

    #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,...

  • Senior Oracle EBS Project Manager

    3 months ago

    United, United States Conspicuous Full time

    Job DescriptionJob DescriptionSenior Oracle EBS Project Manager - Remote with 25% travel (USA) - Up to $175k base + benefits/bonus USD - Global Manufacturing CompanyTom.Sharpless@Conspicuous.comIn a nutshell what my client are seeking? An experienced Oracle EBS PM who has strong manufacturing industry experienceThis role is 25% program management and 75%...

  • Techno -Functional EDI Analyst

    2 weeks ago

    Detroit, United States Refactor Talent Full time

    Senior IT Application Engineer (EDI Analyst) onsite in Detroit, Michigan***Third party candidates will not be considered***Overview:Join our team in Detroit as an experienced EDI Analyst to support and enhance our Oracle EBS system. Leverage your technical and functional expertise in Oracle Applications, EDI processes, and data structures to ensure seamless...

  • Techno -Functional EDI Analyst

    2 weeks ago

    Detroit, United States Refactor Talent Full time

    Senior IT Application Engineer (EDI Analyst) onsite in Detroit, Michigan***Third party candidates will not be considered***Overview:Join our team in Detroit as an experienced EDI Analyst to support and enhance our Oracle EBS system. Leverage your technical and functional expertise in Oracle Applications, EDI processes, and data structures to ensure seamless...

  • Oracle Application Database Administrator

    2 weeks ago

    Chicago, IL, United States TEKsystems Full time

    **Candidates must reside in or around Chicago, IL as this is an exciting opportunity based out of Downtown Chicago. Please do not apply if you are not local**Description:Project: The applicant will be assisting in implementing the Oracle advanced security features, and tuning the Oracle RAC configuration. Job SummaryThe Oracle Applications DBA's role is...

  • Oracle Fusion Administrator

    4 weeks ago

    Detroit, United States Infojini Inc Full time

    Job DescriptionJob DescriptionJob Description: Client is seeking qualified candidates who will utilize their knowledge, skills, and abilities to serve as an onsite Oracle Fusion Administrator responsible for leading the implementation, upgrades, performance, enhancements, and support of the system.Key Responsibilities: Work with 3rd-party integrator for...

  • Manager, Oracle Tax Implementation

    3 months ago

    Grand Rapids, MI, United States Deloitte Full time

    Position Summary Oracle is one of the leading ERP technologies that is revolutionizing how tax is managed and how tax departments around the globe operate. If you are someone who thrives in navigating the growing tax landscape through a technology lens and partnering with passionate professionals to help companies achieve their tax objectives; then we...

  • Oracle Fusion Administrator

    4 weeks ago

    Detroit, United States Infojini Inc Full time

    Job Description:Client is seeking qualified candidates who will utilize their knowledge, skills, and abilities to serve as an onsiteOracle Fusion Administrator responsible for leading the implementation, upgrades, performance, enhancements, and support of the system.Key Responsibilities:Work with 3rd-party integrator for Oracle Fusion Cloud implementation...

  • Oracle Fusion Administrator

    4 weeks ago

    Detroit, United States Infojini Inc Full time

    Job Description:Client is seeking qualified candidates who will utilize their knowledge, skills, and abilities to serve as an onsiteOracle Fusion Administrator responsible for leading the implementation, upgrades, performance, enhancements, and support of the system.Key Responsibilities:Work with 3rd-party integrator for Oracle Fusion Cloud implementation...

  • PowerBI Data Modeler

    23 hours ago

    Brea, CA, United States Sunrise Systems, Inc Full time

    Our client, a leading medical devices company, is looking for a *PowerBI Data Modeler / Developer.* This is for an initial duration of *5 months *and is located in *Brea, CA.**Hybrid:* 1-2 days in office on average*Duration:* 5 Months*In this role, you will have the opportunity to:*· Be part of a team of highly skilled technical analysts, software engineers...

  • Senior Consultant for Oracle Planning Cloud Solutions

    2 weeks ago

    United States Infosys Full time

    Company Overview: Infosys is a global leader in next-generation digital services and consulting, empowering clients in over 50 countries to navigate their digital transformation. Position Summary: We are seeking a Senior Consultant with expertise in Oracle ERP Cloud Implementation, specifically in Supply Planning Cloud, Demand Planning Cloud, or...

  • Oracle Case Management Lead

    3 weeks ago

    Detroit, United States Mastech Digital Full time

    Role: Oracle Case Management LeadLocation: Remote plus 25% travel to Detroit, MichiganDuration: 8+ MonthsCollaborate with client to assess their case management processes for all disciplinary actions, identify future-state needs, and recommend Oracle Case Management solutions to address client requirements; key focus areas include:Standardize and streamline...

  • Oracle Case Management Lead

    3 weeks ago

    Detroit, United States SSi People Full time

    Job Responsibilities:Oracle Case Management LeadCollaborate with client to assess their case management processes for all disciplinary actions, identify future-state needs, and recommend Oracle Case Management solutions to address client requirements; key focus areas include:Standardize and streamline the case management process; eliminate redundanciesEnable...

  • Oracle Case Management Lead

    3 weeks ago

    Detroit, United States Mastech Digital Full time

    Role: Oracle Case Management LeadLocation: Remote plus 25% travel to Detroit, MichiganDuration: 8+ MonthsCollaborate with client to assess their case management processes for all disciplinary actions, identify future-state needs, and recommend Oracle Case Management solutions to address client requirements; key focus areas include:Standardize and streamline...

  • Oracle Case Management Lead

    1 week ago

    Detroit, United States SSi People Full time

    Job Responsibilities:Oracle Case Management LeadCollaborate with client to assess their case management processes for all disciplinary actions, identify future-state needs, and recommend Oracle Case Management solutions to address client requirements; key focus areas include:Standardize and streamline the case management process; eliminate redundanciesEnable...

  • Oracle Case Management Lead

    3 weeks ago

    Detroit, United States Mastech Digital Full time

    Job Title: Oracle Case Management Lead Location: Detroit, Michigan- (Up to 25% travel onsite)Contract : 9 months (with possibility of extension)Job Description:Collaborate with client to assess their case management processes for all disciplinary actions, identify future-state needs, and recommend Oracle Case Management solutions to address client...

  • Oracle Case Management Lead

    3 weeks ago

    Detroit, United States Mastech Digital Full time

    Job Title: Oracle Case Management Lead Location: Detroit, Michigan- (Up to 25% travel onsite)Contract : 9 months (with possibility of extension)Job Description:Collaborate with client to assess their case management processes for all disciplinary actions, identify future-state needs, and recommend Oracle Case Management solutions to address client...