Oracle PL SQL Developer

Position Title: Oracle Pl Sql Developer


Location: Alpharetta, GA - Hybrid - Locals only


Interview Mode: Video Call & Client round F2F


Approximate Duration: 6+ Months


Visa: All except H1b, opt and cpt

Responsibilities:


Must-have skills for this role:


1. Oracle Apps Developer


2. PL SQL


3. Oracle SOA

Years of experience required for each skill: 8 / 9+ years.

Primary job Duties/Responsibilities:


1. Extensive experience in the effective implementation and support of On-Prem Oracle Inventory and On-Prem PDH applications, utilizing advanced methodologies to ensure optimal performance and compliance.


2. Responsibility for developing components such as Reports, Interfaces, Conversions, and Enhancements within Oracle and PDH applications.


3. Strong proficiency in Oracle SQL and PL/SQL programming, encompassing:


- Efficient use of implicit and explicit cursors for data retrieval.


- Development of intricate stored procedures and functions for business logic.


- Creation and management of triggers for data validation and business rules.


- Experience in performance tuning.


4. Experience in bot automation such as power automate to streamline processes and enhance operational efficiency. Eagerness to learn and adapt to emerging technologies, particularly in automation.


5. Collaboration with end users to gather and analyze business requirements, delivering timely solutions.


6. Expertise in integrations, particularly with Oracle SOA, BPEL, PLSQL and other middleware technologies.


7. Conducting thorough code reviews for monthly release components to maintain high-quality standards.


Experience in code repositories such as Github and Code cloud.


8. Providing support for production migrations ensuring that SOX compliance and auditing requirements are met. This includes coordinating releases,


providing off-hours support for migrations and ensuring testing & sign-off. Jira experience is desirable.


9. Tracking bugs and identifying process issues, with a focus on implementing long-term resolutions.


10. Collaboration with cross-functional teams to ensure effective data flow integration with ERP and down-stream systems.


11. Basic understanding of STEP STIBO desirable.

Nice-to-have skills:


1. Oracle PDH
2. STIBO