Job Description :
The purpose of this role is:
Design, develop and implement logic to extract, transform & load data from transactional applications into the DW using Oracle Data Integrator (ODI) and PL/SQL
Partner with Database Administrators and DW developers to achieve great performance
Help DW end users understand and query data to accomplish their business purposes

Position Outcomes
Respond promptly and effectively to resolve incidents
Gather requirements for a change by meeting with customers and listening actively
Meet your time and cost estimates when implementing a change
Demonstrate the knowledge, skills and abilities described above
Fulfill customer requirements using Oracle Data Integrator and PL/SQL

Additional Requirements:
At least 5 years DW design and development experience; 3 years Information Systems experience
Familiarity with Oracle Application Express
Practical knowledge of lifecycle database design, 3NF and dimensional design concepts
Proficiency in PL/SQL coding, troubleshooting, and performance tuning
Experience with Oracle (preferably version 11)
Knowledge of Unix Scripting and job scheduling
Knowledge of ETL tools –Oracle Data Integrator Enterprise Edition preferred
Familiarity with Oracle Business Intelligence Enterprise Edition a plus but not required