Assistant Manager – Oracle EBS Techno-Functional

Indian Institutes of Public Health (IIPHs); Amos; On-site; CAD 13,000 - 22,000; Full time

Job summary

Public Health Foundation of India (PHFI) seeks an experienced Oracle EBS Functional Technical Specialist (FTS) to support, maintain, and upgrade Oracle EBS R12.2 environments. You will handle requirements analysis, design documents, testing, and end-to-end deployments across Financials, HRMS, Payroll, and OTL modules.

Strong tech/functional expertise in SQL/PLSQL, BI Publisher, WebADI, Forms & Reports, and integration via REST APIs is essential; NGO/Development sector experience is preferred;

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Engineering or related discipline.
• Oracle certifications preferred.
• 5–7 years of experience.
• NGO/Development sector organizations experience preferred.

Responsibilities

• Provide techno-functional support for Oracle EBS R12/R12.2.x environments.
• End to end testing of modules during upgrades.
• Gather business requirements and prepare functional/technical design documents.
• Develop and support BI Publisher reports and Oracle Reports.
• Integrate Oracle EBS with third-party applications via APIs and Open Interfaces.
• Coordinate change/release management and application migrations.

Tools

Oracle Financials (AP AR GL FA SLA)

Oracle HRMS

Oracle Payroll

Oracle Time & Labor (OTL)

SQL and PL/SQL

BI Publisher

Oracle Workflow

WebADI

Oracle Forms & Reports

SQL Loader

Jira and ServiceNow

Job description

The Public Health Foundation of India (PHFI) is working towards building a healthier India. It is helping to address the limited institutional and systems capacity in India by strengthening education and training, advancing research and technology and facilitating policy and practice in the area of Public Health. PHFI is headquartered in New Delhi with national presence through its constituent units of regional Indian Institutes of Public Health (IIPHs) and Centers of Applied Research in core public health themes. The Foundation, established in 2006 as a public private initiative, is governed by an independent board comprising of senior government officials, eminent Indian and International academic and leaders, civil society representatives and corporate leaders. For more information, please visit the website www.phfi.org.

Job Summary

We are seeking an experienced Oracle EBS Functional Technical Specialist (FTS) to support, maintain, and enhance Oracle EBS R12.2 applications. The role involves application support, troubleshooting, business requirement analysis, reports and customizations, integrations, and system enhancements. The candidate should have strong functional and technical expertise in Oracle Financials, HRMS, Payroll, OTL, SQL/PLSQL, BI Publisher, Oracle Workflow, WebADI, Forms & Reports, and Oracle EBS R12.2.x.

Deliverables

• Provide techno-functional support for Oracle E-Business Suite (EBS) R12/R12.2.x environments.
• Expertise in Handling the Oracle Database for Technical related skills.
• Knowledge and Support experience on Oracle Financials, Projects (Billing & Accounting) HRMS, Payroll, and OTL modules as a Functional role.
• End to End Testing of all mentioned modules process flow in Oracle EBS during Upgrade.
• Gather business requirements and prepare functional and technical design documents.
• Development, Retro-fitment and Deployment Exposures on CEMLI / RICE components in Oracle EBS as per standard practices.
• Analyze, design, develop, test, and deploy Oracle EBS customizations and enhancements.
• Develop and support Reports, Interfaces, Conversions, Extensions, Workflows, and RESTAPIs (RICEFW).
• Create / Maintain Documentation of all Technical / Functional related changes in Oracle Application
• Create and maintain BI Publisher reports, XML Publisher reports, and Oracle Reports.
• Develop SQL and PL/SQL packages (Complex, Medium & Simple) procedures, functions, triggers, and data-fix scripts.
• Design and maintain Oracle Forms, Concurrent Programs, Value Sets, and Flexfields.
• Integrate Oracle EBS with third-party applications using APIs and Open Interfaces.
• Support payroll processing, payroll costing, reconciliations, and statutory compliance activities.
• Configure payroll elements, balances, Fast Formula, and payroll workflows.
• Support employee lifecycle processes including hiring, transfers, promotions, and terminations.
• Configure and support OTL timecard rules, approval workflows, and payroll integration.
• Manage Procure-to-Pay (P2P) and Invoice-to-Pay business processes.
• Support supplier management, invoice validation, payment processing, PPR, and PPP activities.
• Perform AP, AR, GL, Fixed Assets, Cash Management, and SLA support activities.
• Troubleshoot production issues and provide timely resolution to business users.
• Perform query optimization and database performance tuning.
• Support User Acceptance Testing (UAT), SIT, and Production deployments.
• Coordinate change management, release management, and application migrations.
• Execute Oracle EBS cloning, patching, and environment refresh activities.
• Support Oracle Database administration activities and database upgrades.
• Assist in Oracle EBS R12/R12.2 upgrade projects and pre & post-upgrade validation.
• Monitor application performance and proactively identify improvement opportunities.
• Work with cross-functional teams to deliver business process improvements.
• Create technical documentation, solution designs, SOPs, and knowledge-base articles.
• Manage incidents, service requests, and problem tickets through ServiceNow and Jira.
• Ensure compliance with organizational policies, audit requirements, and security standards.
• Provide end-user training and knowledge transfer for Oracle EBS processes.
• Support month-end, quarter-end, and year-end financial and payroll processing activities.

Qualification

Essential

• Bachelor’s degree in Computer Science, Information Technology, Engineering or related discipline. Oracle certifications preferred.

Experience

Essential

• Required 5-7 Years of experience.
• Oracle EBS Upgrade Projects (R12.2.x)
• Oracle Database Upgrade to 19c
• Oracle Projects (PA)
• HRMS and Payroll Implementations
• OTL-Payroll and OTL-Projects Integration
• NGO/Development Sector Organizations

Skills & Competencies

• Oracle Financials (AP, AR, GL, FA, SLA)
• Oracle HRMS
• Oracle Payroll
• Oracle Time & Labor (OTL)
• SQL and PL/SQL
• BI Publisher
• Oracle Workflow
• WebADI
• Oracle Forms & Reports
• SQL Loader
• Jira and ServiceNow

Last Date of Receipt of Applications

07 November 2026.

Remarks

• Candidates are requested to refer PHFI website for position description & process for applying. Please note only those applications will be considered which are received as per instruction written on PHFI website.
• Candidates should have an excellent academic record, good communication skills, a commitment to high quality graduate / post-graduate education.
• Mere eligibility will not entitle any candidate for being called for interview.
• Persons employed in Government/Semi-Government Organization or Educational Institutions in India must apply through proper channel.
• PHFI reserves the right to fill or not to fill any or all available positions.
• The requirements of minimum qualification and/or experience may be relaxed in the case of candidates with outstanding credentials.
• No correspondence will be entertained from candidates regarding any delays, conduct & result of interview and reasons for not being called for interview.

PHFI reserves the sole right to alter/modify/cancel the entire selection process or the position or the vacancy or to disqualify any candidature at any stage of the selection process.

Women are encouraged to apply!