Programmer Analyst - PL/SQL

tagui, National Capital Region
Posted 5 days ago
Logo Nityo Infotech Services Philippines
Company:
Nityo Infotech Services Philippines
Company Description:
Nityo Infotech Corporation is the fastest-growing global IT Services & Solutions Company; headquartered in New Jersey, USA. Our services span from Application Management Outsourcing, Packaged Application Services, Remote Infrastructure Management, Product Development, and Support to higher value-added offerings, including Managed Platform and Product Engineering Services.
Contract Type:
Full Time
Experience Required:
3 to 4 years
Education Level:
Bachelor’s Degree
Number of vacancies:
4

Job Description

KNOWLEDGE / SKILLS / EXPERIENCE IN THE FOLLOWING:
• Experience in the field of Information Technology (IT) focused in Oracle PL/SQL
• Experience in monitoring and supporting the client’s database using SQL Developer and UNIX
• 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)
• More than 2 years of experience in PL/SQL language and Oracle E-business Suite R12
• Experience in Jenkins Migration Tool
• Experience in SQL Developer, SQL * Plus, and MySQL database
• Experience in Web Development using PHP, MySQL, CSS, Bootstrap and Java Script
• Knowledge and Experience in Software Development Life Cycle

TECHNICAL SKILLS:
• Oracle RMS
• Oracle SIM
• Oracle WMS
• Oracle RPM
• Bi-Publisher
• UNIX/LINUX
• Apache
• Oracle Forms and Reports
• SAP
• Oracle 12g
• Oracle PL/SQL

RESPONSIBILITIES:
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.