Data Warehouse Oracle Developer

Over 80% of this job's responsibilities include designing and developing/coding of computer systems. This position will perform full Data Warehouse life-cycle systems development and will work with clients to understand requirements and translate to appropriate technical solution. This role will also architect Data Warehouses/Marts by providing technical infrastructure designs, data mappings/flows, and report dissemination mechanisms. Additionally, this role will design and implement data models for database applications using Oracle Designer as well as create and manage database objects including tables, indexes, procedures etc. In this position, you will develop and test programs using SQL, PL-SQL and SQL-Loader for database applications. You will also manage unit, system and integration testing for accuracy and performance. This position will require you to develop and generate standard and ad hoc reporting capabilities from new and existing data sources in a Data Warehouse environment. You may also develop and modify queries, programs and stored procedures to support standard and ad-hoc reporting. This opportunity will need you to analyze source data of different types and design programs for data integration, cleansing and transformation in Oracle and perform data loading and manipulation in Oracle.

Applicants must have a BS in Information Systems or equivalent with experience in Data Warehousing or Business Intelligence (BI) and expertise in Oracle (8i and/or 9i) relational database system (5 Years or more), including database design, SQL, PL/SQL, SQL*Loader. Candidates must have experience in at least 1 reporting/OLAP tool (Oracle Express, Cognos, or Brio). Incumbents must also have experience in data modeling, life-cycle development methodology and user-training as well as knowledge of Oracle Designer/2000 or other data modeling tools. Applicants must have experience in UNIX programming and shell scripting and demonstrated ability to implement business rules using Oracle procedures, functions and triggers. Candidates should also have demonstrated ability to respond to changing priorities, multiple tasks and demands within short timeframes with good client handling skills. Ability to work independently as well as in a team environment is a must.