Oracle Forms & Reports Developer

• Strong Knowledge in Oracle Forms and Reports
• Should be familiar with various triggers, events , canvas, master child forms, record groups , build-ins, properties etc., in Forms and reports
• Strong Knowledge in SQL / PLSQL concepts
• Strong in Analytical and Aggregate functions
• Strong in writing Procedure / Function / Packages
• Strong knowledge in the user of Cursors / Collections / Exception handling
• Strong in Datatypes, Constrainsts , index
• Having exposure to JavaScript and ReactJS will be an added advantage

•  Be a team player and strive for the success of the team and the client
• Preparation of Technical Design documents
• Work independently and progress the build of a CEMLI/RICE object from a technical design document
• Capable of working in a fast paced, dynamic, team-oriented environment
• Understanding functional documents of FIN (GL, Fixed Assets, Cash management, AP/AR) and SCM (procurement, Inventory, Order Management).

• Minimum a Bachelor’s degree.
• Oracle Apps Technical with 5+ years of Experience in development, testing and deployment of RICE components and financial modules
• Good Experience on Oracle Forms & Reports, XML / BI Publisher Reporting Tools, Interfaces (outbound /Inbound) and Workflow.
• Must have a strong experience and knowledge of Oracle E-Business Suite
• Must have strong technical experience on PL/SQL, XML Publisher reports, Java, Oracle Applications Framework (OAF)
• Knowledge on ADF
• Must be able to work independently with business users and external users and responsible for design, development, Testing support, production deployment and production support.
• Excellent organization and communication skills

Job Description – Developer (ETL + Database)

 Develop, document & Support ETL mappings, Database structures & BI reports.

 Perform unit testing of developments done by him/her.

 Participate in UAT process and ensure quick resolution of any UAT issue.

 Manage different environments and be responsible for proper deployment of code in all client

environments.

 Prepare release documents.

 Prepare and Maintain project documents as advised by Team Leads.

Skill-sets:

 3+ years of Hands on experience on ETL Pentaho Spoon Talend & MS SQL Server, Oracle & SYBASE Database tools.

 Ability to write complex SQL and database procedures.

 Good knowledge and understanding regarding Data warehouse Concepts, ETL Concepts, ETL

Loading Strategies, Data archiving, Data Reconciliation, ETL error handling etc.

 Problem Solving.

 Good communication skills – written and verbal.

 Self-motivated, team player, action and result oriented.

 Ability to successfully work under tight project schedule

Key Responsibilities & Job Duties

● To provide functional support for our ERP

Finance applications (Oracle eBusiness Suite)

○ Assist users in case of question

○ Manage functional requests

● Train users to keep the right level of skill

○ To organize audits of the use of systems

○ Detect and collect issues

○ Implement action plan and coordinate actions

● To manage enhancements in accordance with the procedures which apply in the department

○ Collect enhancements from users

○ Challenge the user requirements

● Define priorities

○ Write functional specifications and coordinate developments with the technical team

● Test and train the users

○ Regularly communicate to the users the status of the enhancement

○ Report activity to the management

○ Collaborate with functional support in other zones to share information

○ Optionally, may manage some projects

Key Technical & Functional Competencies
● Functional competencies

○ Strong Business processes: Finance

● Technical competencies

○ Good Knowledge of Oracle SQL

○ Strong Oracle eBusiness Suite

Modules: AP, AR, GL, FA (At least at a professional for two Modules)

○ Basic knowledge of Oracle eBusiness Suite Modules: INV, PO, OE, WSH is preferable

3+ years of industry experience designing, building and supporting cloud-native systems in production with a solid grasp on good software engineering practices such as code reviews, a deep focus on quality, and documentation

• Demonstrable backend development expertise using Java (JDK 8+, 11 preferred)
• Proven Experience writing reactive, event-driven, asynchronous code using Vert.x
• Fair understanding of networks, security, system resilience & clustering • Experience with MongoDB & ELK stack
• Experience building & consuming RESTful APIs • Experience writing Unit & Integration tests with JUnit5 / Jupiter
• Ability to troubleshoot and effectively resolve issues across services and multiple levels of a complex technical stack that includes microservices, container & virtualized environments, and message & event streams, in a timely manner.
• A desire to learn and apply best practices in software development
• Good communication, and the ability to work remotely with minimal supervision

Nice to have skills:

• Oracle database experience a plus
• Experience with Apache Kafka (or Java Messaging Services in general) & Nifi
• Experience with containers & orchestration – Docker, Docker Swarm, Kubernetes
• Experience with CI / CD – Jenkins, Nexus, AWS and / or Azure Cloud infra

Onsite Opportunity for Oracle Fusion HCM Functional (TalentManagement/ CoreHR) Consultant’s – UAE. Exp.- 8+Years, Very strong in Fusion TalentManagement/ CoreHR. Atleast 2 e2e Implementation in Fusion TalentManagement/ CoreHR. Excellent Communication. Joining time: Max. 10 Days. Kindly contact Ramesh- 782, 938, 2777, rbguddanur AT appstec-me DOT com