Programmer Analyst - PLSQL (Client-site with relocation package)

At Umpisa Inc., our mission is to make the Philippines be known globally as a tech hub. Umpisa Inc. is a progressive technology services company that partners with select industries, clients and people to work on pioneering and industry-changing solutions via digital transformation, modern software development and venture building. We create a set of world-class and impactful products and solutions to help organizations and individuals live better lives. We offer demanding, challenging and rewarding careers in software development, product development, emerging technologies, and more for the right candidates. Essential Skills: Aligns with our values: Excellence, Integrity, Professionalism, People Success, Customer Success, Fun, Innovation and Diversity Strong communication skills Strong problem solving and analytical skills Excellent problem-solving ability Would like to work as part of a self-organizing Scrum team in a scaled agile framework Must be a self-starter and loves to collaborate with the team and client Knowledge/Experience in ff: 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 required: 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. Created summaries or reports that can be used by the leads during presentations. Communicated with the client regarding changes request and sub-leading in supporting applications. Created Deployment manuals and conduct actual deployment in Production Environment. Provided support and conduct Knowledge Transfer to other members as an SME of the system. Analyzed, Modified and developed existing PL/SQL packages based on change requests. Handled and provided technical support and respond to inquiries about E-Business Suite System. Created and executed Unit tests and System tests for the Programs developed.