Job Description :
Under the direction of the Manager, the ETL Developer (the “Consultant”) will:

Collaborate with development staff, system users, business analysts and others to gather requirements for system changes and enhancements;
Perform analysis necessary to understand the requirements for system changes and enhancements and any factors related to fulfilling these requirements;
Design solutions to satisfy requirements for system changes and enhancements;
Identify, analyze and resolve production issues;
Develop, remediate, enhance and refactor program code and Oracle Warehouse Builder objects to implement design solutions and to enhance code readability, efficiency and maintainability;
Design test plans to confirm that the requirements of system changes and enhancements are being met. Regression, unit and integration testing should be included in the design, as required;
Create and maintain documentation, as needed. Documentation will be required for:
Program units and objects,
Processes,
Environment setup and configuration,
Solutions identified to resolve problems,
Test plans,
Business requirements, and
Design documents;
Report to the Manager on the status of tasks and any issues encountered in applications;
Work with the Database Administration team to maintain the new data warehouse security model, conforming to the Security Guide and the Technical Reference Manual;
Provide technical guidance, mentoring, and support to other programmers; and
Other related duties as identified by the Manager

Minimum Qualifications to Propose

The Consultant must possess the following minimum qualifications:

Five years’ experience developing and maintaining a data interchange system interfacing with a commercial off-the-shelf financial system, such as PeopleSoft or Oracle Applications;
Five years’ experience working with Oracle Security including users, roles, object and system privileges, application contexts, Virtual Private Database and associated policies;
One years’ experience working with an ETL tool such as Oracle Warehouse Builder or Oracle Data Integrator; and
Five years’ experience working with Oracle Business Intelligence such as OBIEE, Discoverer, or Oracle Reports.