About the Job:
Ora Apps is seeking an Oracle (HR/Payroll) Technical Analyst that has excellent communication and documentation skills for one of our highly regarded client. NOT A CONTRACT POSITION.
*** Requires Green Card or U.S. Citizenship.
Required Skills:
* Six to 7 years experience with Oracle Applications (Oracle HR, Payroll, OAB).
* Good understanding of HRMS related table and API*s.
* At least Six (6) years experience with Oracle HRMS system.
* At least Six (6) years experience with Oracle Report Writer and Discoverer.
* At least Six (6) years experience with Oracle PL/SQL.
* Experience with custom applications running on Oracle.
* Experience in SQL, PL/SQL and Performance tuning
* Experience working with end users.
* Use of PL/SQL to integrate data sets.
* Development of complex Oracle reports that utilize the following: multiple queries, multiple groups and levels of repeating frames, calls to PL/SQL packages, procedures and functions, formula and summary columns, materialized views, format triggers and layout customization, lexical parameters, export to Excel, and report registration in Oracle Applications.
* Experience with Oracle Discoverer 10g.
* Experience with Oracle XML Publisher.
* Experience with Toad or SQL Developer.
Responsibilities:
* Oracle Developer (HR/Payroll) will create, modify, and troubleshoot complex Oracle Forms, stored procedures using PL/SQL and complex Oracle Reports.
* Integrate customizations of HR and Payroll with Oracle Apps (E-Business Suite, HRMS/Payroll, Project Accounting).
* Oracle Developer (HR/Payroll) will create scripts to deploy customizations into production.
* Develop reports using Discoverer 10g (including EUL and Views)
* Provide mentoring for employee resources
* Oracle Developer (HR/Payroll) will analyze AIM documentation accuracy and technical function |