Job Title: Oracle Data Consultant Duration: 11 Months Location: Remote
Reason for this request:
Team does not have someone who can focus on extracting the data from ERP and details to the Data Lake team.
Mainly looking for a technical person to join their team and work with them on their focus request and create a pipeline between ERP and data lake.
Internal task (Day to Day):
Join stand up in the morning and talk about tasks for the day. (Timelines, tasks)
Go back and work on that and work with others in the team
Very planned day
Interaction level with the team:
Sync up meetings with ERP/Data warehouse team.
To ensure contractor knows source and target systems for the day/week.
The successful engineer in this should be comfortable with Oracle EBS to work in the areas mentioned below: FINANCE
Provide solutions and technical advice, work directly with business users/ System Analysts / stakeholders / DBA.
Work on General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets functional areas
Perform application system administration functions specific to application setup, configuration and maintenance.
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.
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.
Develop reports in oracle BI publisher/Xml publisher like and register them as concurrent Programs as required
Convert oracle Seeded reports in Reports to XML reports as needed or recommended.
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.
Develop technical solutions with APIs, Advanced PL/SQL, Oracle Forms/Reports, Open Interfaces, UNIX and OAF.
Work in EBS/applications INTEGRATIONS using SOA – Work with stakeholders (database administrators and functional team) to troubleshoot application, integration and database related issues
Create Packages and Stored Procedures.
Prepare the Unit Test Plans and involved in Testing.
Prepare reconciliation scripts for post data migration.
Prepare migrating and deployment documents (MD70, MD120).
Create Concurrent Programs to call shell script.
Customize report templates xml publisher reports.
Analyze formal test results to discover and resolve defects, bugs, errors, configuration issues, and interoperability flaws.
Create Oracle Alert triggers.
Work on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
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.
Involve in Deployment Code Plan before cutover, validating all the Integration Endpoints, Recon Reports and also generating the reports through Excel Macros.
Create test data in TEST Environment based on the scenarios given to test functionality & for defect management.
Work with the reporting team to ensure that correct data is presented in the reports & get signoff from business.
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
Perform application system administration functions specific to application setup, configuration and maintenance.
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.
Develop and maintain technical documentation, including solution designs, architectural diagrams, and data models for cloud-based deployments.
Provide technical expertise, and guidance, in the development and implementation of integration solutions.
Develop reports in oracle BI publisher/Xml publisher like and register them as Concurrent Programs as required
Convert oracle Seeded reports in Reports to XML reports as needed or recommended.
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.
Develop technical solutions with APIs, Advanced PL/SQL, Oracle Forms/Reports, Open Interfaces, UNIX and OAF.
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.
Prepare the Unit Test Plans and involved in Testing.
Prepare reconciliation scripts for post data migration.
Prepare migrating and deployment documents (MD70, MD120).
Create Concurrent Programs to call shell script.
Customize report templates xml publisher reports.
Analyze formal test results to discover and resolve defects, bugs, errors, configuration issues, and interoperability flaws. s) Create Oracle Alert triggers.
Work on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
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.
Involve in Deployment Code Plan before cutover, validating all the Integration Endpoints, Recon Reports and also generating the reports through Excel Macros.
Create test data in TEST Environment based on the scenarios given to test functionality & for defect management.
Work with the reporting team to ensure that correct data is presented in the reports & get signoff from business.
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 CC OTH 00503055 2023 TR
Perform application system administration functions specific to application setup, configuration and maintenance.
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.
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.
Develop reports in oracle BI publisher/Xml publisher like and register them as Concurrent Programs as required
Convert oracle Seeded reports in Reports to XML reports as needed or recommended.
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.
Develop technical solutions with APIs, Advanced PL/SQL, Oracle Forms/Reports, Open Interfaces, UNIX and OAF.
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.
Prepare the Unit Test Plans and involved in Testing.
Prepare reconciliation scripts for post data migration.
Prepare migrating and deployment documents (MD70, MD120).
Create Concurrent Programs to call shell script.
Customize report templates xml publisher reports.
Analyze formal test results to discover and resolve defects, bugs, errors, configuration issues, and interoperability flaws. s) Create Oracle Alert triggers.
Work on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
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.
Involve in Deployment Code Plan before cutover, validating all the Integration Endpoints, Recon Reports and also generating the reports through Excel Macros.
Create test data in TEST Environment based on the scenarios given to test functionality & for defect management.
Work with the reporting team to ensure that correct data is presented in the reports & get signoff from business.
ORACLE OAF JSP CONSULTANT
Work closely with functional teams to understand business requirements and translate them into technical solutions.
Design and develop custom pages, forms, and extensions within Oracle EBS using OAF.
Develop custom OAF pages to meet specific project requirements.
Work on integrating JSP Components into EBS applications.
CC OTH 00503055 2023 TR
Integrate and call JSP pages from within Oracle Application Framework (OAF)
Handle the deployment of OAF customizations and JSP pages to ensure seamless integration and functionality
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $94.00/hr.
