Sr Engineer, Data Integrations & Analytics
TITLE: Sr Engineer, Data Integrations & Analytics
Location: Onsite in Irvine, CA
Salary:$107K-180K plus a 10% bonus paid out quarterly.
Benefits include (Medical, dental, and vision insurance, Paid time off, Tuition Reimbursement, 401K , Paid time to volunteer in your local community)
The primary role of the Sr Engineer, Data Integrations & Analytics, is to work within our Accounting & Finance team to develop and support technical aspects of Oracle Fusion Cloud (ERP/EPM/EDM) such as OIC Integrations, ESS Jobs, Configurations, Rest & Soap calls, API’s, FBDI Loads, BIP reports, and BICC. You’ll be responsible for all aspects of designing technical solutions, debugging and resolving data issues as well as developing solutions based on specifications. This position will monitor and tune performance of interfaces between Oracle Fusion Cloud and external applications (Workday, Epic, Concur, etc.). You will help provide production support for Fusion Cloud (ERP/EPM/EDM) and responsible for ensuring SDLC procedures are followed when making changes to the system. You will work directly with business users to support and design solutions involving writing technical specifications and requirements for integrations, enhancements, and creating custom reports.The Sr Engineer, Data Integrations & Analytics should have a positive attitude and excellent communication skills and be committed to achieving predetermined goals and deadlines while working within the policies of the Accounting Department.
Responsibilities
• Design, build, and maintain our ETL (Extract, Transform, Load) processes.
• Manage the end to end process of implementing automation solutions using Oracle Integration Cloud (OIC).
• Work with customers to ensure that specifications are appropriately detailed to allow proper workflow design.
• Develop and document the design of the automated workflow.
• Help maintain quality and organization of platform code and data.
• Participating in functional testing working with the business to document changes to current business practices and assist in process re-engineering and change management planning efforts.
• Participate in meetings as required.
• Other duties as assigned.
Qualifications
• 5+ years technical experience with Oracle Cloud Fusion ERP & EPM products.
• 5+ years technical experience with API, FBDI loads, BIP, BICC, ESS job configuration.
• 3+ years experience designing and developing integrations in OIC to Oracle ERP Cloud including making REST and SOAP calls, FBDI File Uploads, and extracting ERP Cloud data using BIP reports.
• 3+ years’ experience performing integrations between OIC and 3rd party applications both inbound and outbound – File based, web service and XML based.
• Extensive experience in SQL/PLSQL, Logical SQL Queries and Performance Tuning.
• Solid exposure to varied cloud databases such as Snowflake, Oracle Autonomous DW (ADW), etc.
• Education: Bachelor’s Degree in Computer Science, Computer Engineering, MIS or related field.
Preferred
• Experience working with ERP systems data such as Oracle EBS/Fusion (Purchasing, Order Management, and/or Financials modules)
• Experience in a multi-regional healthcare, retail, or dental company.
Knowledge/Skills/Abilities
• Knowledge in XSD, WSDL, SOAP, XSLT and REST.
• Experience with Python scripting, Groovy Scripting, SQL, PL/SQL, Java, XML, JDeveloper, Oracle BI Publisher, APEX, Visual Builder Cloud Service, OIC, FBDI, ADFDi, Cloud Framework native to Oracle Fusion Application.
• Expertise in data integration, data quality, and performance optimization will be essential in supporting our organization’s data-driven decision-making efforts.
• Advanced skills in analyzing, designing, developing, implementing and maintaining application code in a variety of contexts.
• Demonstrated experience in application development, complex code development, application testing and component design.
• Extensive experience working with process owners and business analysts to analyze, standardize and optimize business processes, translate requirements into functional/technical designs, and build robust technical solutions.
• Strong understanding of technology and architecture concepts.
• Self-motivated, reliable individual capable of working independently as well as part of a team.
Interested candidates email your resume to alex@amtexenterprises.com & shabu@amtexenterprises.com
To apply for this job email your details to alex@amtexenterprises.com