PL/SQL Developer

Qualifications Must have: • Bachelor's Degree in IT or Related course. • Minimum 3 years of experience in Oracle PL/SQL programming/development. (Non-negotiable) • Must have experience in monitoring and supporting the client’s database using SQL Developer and UNIX. (Non-negotiable) • Must have experience in monitoring Oracle Batch Processes (Morning and Night Batch Processing) using UC4 AppworX and Oracle Data Integrator Facilitates reports using SQL Server Reporting Services (SSRS) (Non-negotiable) • Must have 3 years of experience in PL/SQL language and Oracle E-business Suite R12 (Non-negotiable) • Must have experience in SQL Developer, SQL * Plus, and MySQL database (Non-negotiable) • Must have experience in Web Development using PHP, MySQL, CSS, Bootstrap/Java Script (Non-negotiable) • Must have experience in Software Development Life Cycle (Non-negotiable) • Must have excellent communication skills. (Non-negotiable) TECHNICAL SKILLS: (Non-negotiable) Oracle RMS Oracle SIM Oracle WMS Oracle RPM Bi-Publisher UNIX/LINUX Apache Oracle Forms and Reports SAP Oracle 12g Oracle PL/SQL Job Description The Programmer Analyst is responsible for the development of simple to medium complexity application design, programs and related facilities according to approved business specifications, regulatory and company standards. Provides high level assessment for application system change requirements and technical inputs for user requirements during the preparation of impact document and business case documents Collaborates with the Business Analyst to provide design inputs and estimates in the preparation of requirements document. Documents system design and program specification in technical design document. Writes programs and codes based on approved technical design document. Develop prototypes as needed Conducts unit testing on written codes to ensure program perform per design at the unit level. Coordinates with vendor or conducts own investigation and resolution of errors reported during SIT and UAT. Maintain the systems once they are up and running in production, and perform production fixes or application enhancements as needed. Performs the above function in compliance with software development lifecycle standards of the company. Creating summaries or reports that can be used by the leads during presentations. Communicating with the client regarding changes request and sub-leading in supporting applications. Creating Deployment manuals and conduct actual deployment in Production Environment. Providing support and conduct Knowledge Transfer to other members as an SME of the system. Analyzing, Modifying and developing existing PL/SQL packages based on change requests. Handling and providing technical support and respond to inquiries about E-Business Suite System. Creating and executing Unit tests and System tests for the Programs developed.