Responsibilities
· Accountable for planning, designing & implementing application architecture and integration requirements for business applications for the group.
· Develop PL/SQL database objects, SQL scripts, interfaces, reports, and forms using standard tools including Oracle Forms, Report Builder, Oracle Application Framework, BI Publisher/Smart View/ FRS
· Ability to design ETL unit test cases and debug ETL Mappings Expertise in developing Load Plans, Scheduling Jobs Ability to design data quality and reconciliation framework
· Hands-on experience in complex SQL, PL/SQL, report development experience with Oracle Fusion tables, views, and setups, Fusion APIs, FBDI, ADF DI Loads, BIP, and OTBI Reports
· Work with a functional consultant in reviewing business requirement documents (BRD) and translating into technical specifications to independently develop, modify and maintain complex software products
· Leads design/code reviews, architecture design, and infrastructure reviews for larger projects.
· Analyse business needs utilizing a structured requirements process (gathering, analyzing, documenting, and managing changes) on the technical/integration requirement.
· Owner of all integration project lifecycle of the organization's business applications, including management of scope and business requirements technical specifications, testing, user application training (UAT), implementation, deployment, and post-go-live end-to-end efficient application support.
· Experience in creating and consuming SOAP/REST Webservices using JSON, and XML,
· Knowledge of JavaScript, HTML, and CSS (SCSS) would be an added advantage.
· Hands-on, expertise in the Oracle ODI toolset, knowledge of ODI Master and work repository, knowledge of data modeling and ETL design.
· Manage enhancements, integration solutions, and support across the organization to ensure ultimate efficient operations.
· Work with senior and department leadership to identify and implement business process improvements. Proactively and consistently identify and manage project-related issues, and risks, and mitigate scope changes, ensuring that all project objectives are attained.
Desired Candidate Profile
Requirements
· Bachelors/master’s degree in computer science or a related field.
· Solid experience on platform cloud components to Oracle Fusion, EBS, and install base including OACS, OICS, SOACS, DBCS, – including PaaS for SaaS.
· 8+ years’ experience as a technical consultant in the software industry.
· Good In debugging skills with the integrations of custom tools.
· Candidate should have at least a minimum 2 end to end implementation projects.
· Hands-on, expertise in the Oracle ODI toolset and Oracle PL/SQL, knowledge of ODI Master and work repository, knowledge of data modeling and ETL design.
· Directly interacts with the internal team, vendors, and business users and manages customer expectations.
· Requires a minimum of eight (6) years of software application development and maintenance experience using Java technologies, leading detailed business requirements and specification activities. Elicit requirements via interviews, document analysis, workshops, surveys, business process reviews, use cases, scenarios, business analysis, tasks, and workflow analysis.
· Strong knowledge of Oracle Internet Directory (OID), Oracle Access Manager OAM), and Oracle cloud applications - ERP Cloud, EPM Cloud, PaaS, and IaaS technologies.
· Hands-on experience in SQL, PL/SQL, Interfaces, Integration, and report development experience with OTBI
· Hands-on experience with Oracle Fusion tables, views, and setups.
· Work with senior and department leadership to identify and implement business process improvements.
· Proactively and consistently identify and manage project-related issues, and risks, and mitigate scope changes, ensuring that all project objectives are attained.
Oracle – fusion technical developer (all modules)