Plsql Developer

Consultant will be responsible for delivering end to end projects, specifically working for an existing client of National Account Services. Projects will include project management, development, business analysis and configuration. Associate will work as project manager to own all phases of project delivery related to the HCM domains of payroll & other benefits, including the creation of functional/technical design specifications, carrying out impact and gap analysis, requirements gathering from client and vendor, develop SQL (Structured Query Language), perform Unit Testing, UAT (User acceptance testing), write test cases, create test matrix etc.

Exposure to Project management, Stakeholder management, Scope management.

Should have good understanding of HCM (Human Capital Management) domain, Payroll and Benefits

• Requirements gathering from client and vendor.
• Should be able to provide effective Impact and Gap analysis based on requirement received.
• Creation of contingency plan and providing alternative solution to client and vendor
• Strong communication (written and verbal).
• Should have worked in Agile and Waterfall model.
• Should have good understanding of SDLC (Software Development Life Cycle) phases and work structure.
• Should be able to develop/ design complex SQL (Structured Query Language) query.
• Should be able to understand the bug tracking flow STLC (Software Testing Life Cycle).
• Should be able to perform the Unit Testing, UAT (User acceptance testing), write test cases, create test matrix.
• Should schedule meeting with client and vendor for walkthrough of Functional Requirement Document (FRD), Business Requirement Document (BRD), Functional/Technical Design Specifications and Test Matrix.
• Manage and Communicate Development status, Logic hurdles, test progress, product quality and defect entry/closure progress, through participation in Daily standup meetings.
• Should be able to understand SFTP (secure file transfer protocol)/MFT (Managed file transfer) setup and complete the configuration.
• Should be able to triage the issue quickly and provide solutions.
• Exposure to performing CR (Change Request) management process through Gap analysis, Impact analysis.

Essential Duties and Responsibilities:

• Implement Interfaces as a liaison between ADP and Client/Vendor system.
• Understand the 5 Project Management process groups of Initiating, Planning, Executing, Monitoring & Controlling and Closing.
• Extensive working experience in writing SQL queries with various types of joins for data validation.
• Good experience with MS Excel (V-Lookup, H-Lookup, Pivot).
• Writing FRD (Functional Requirement Document), BRD (Business Requirement Document), SRS (software requirements specification) etc.
• Writing Test cases and Creating Test Matrix, Understanding of RTM (Requirements Traceability Matrix).
• Should be able to handle stakeholders (Internal and External) communication in a very clear and precise manner.
• Should be able to create contingency plan.
• Should have good knowledge and understanding about SFTP (secure file transfer protocol)/MFT (Managed file transfer)/ FTP (File Transfer Protocol).
• Should be able to jump any quick calls and provide solutions.
• Should have worked in handling data, preparing reports using excel or any other data tool.

Desired Skills

• Excellent analytical and problem-solving skills.
• Excellent team player and interpersonal skills.
• Excellent communication and presentation skills.
• Ability to coordinate with others team members to accomplish objectives.
• Ability to prioritize the job and meet the deadlines/SLAs (Service Level Agreement).
• Ability to meet deadlines and attention to detail.
• MS Office tools.
• Should be able to create Root Cause Analysis.
• Should be able to work independently as Project Manager.

Eligibility Criteria:

• Education: Bachelor's Degree in Engineering/Technology, BCA, BCS, B.Sc. Computer Science or equivalent.
• Experience: Minimum 2 to 5 years of experience.
• Strong knowledge on HCM product (HR, Payroll) functionality.
• Strong knowledge of PL/SQL and RDBMS (Relational Database Management System) concepts and Manual Testing.
• Strong communication skills.
• Analytical and Agile mindset.