Long Term and Stable position.
One of our clients in Albany, NY is seeking an Oracle Data Warehouse Architect .

This position is for an Oracle Data Warehouse/Business Intelligence Developer and is required to design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture in support of these Data Warehouse projects.  In addition, the consultant will be responsible for managing the Data Warehouse daily processing operations and job schedules

Mandatory Requirements:

1.        Five years experience working with oracle, with a thorough understanding of the architecture and processes of the oracle server, including Oracle 9i and/or Oracle 10g or higher.

2.        Three years experience as an oracle database administrator in a production database environment.

3.        Three years experience in monitoring and tuning the general performance of the oracle database.

4.        Three years experience writing SQL-PL/SQL, stored procedures and triggers.

5.        Three years experience in identifying business rules and database design.

6.         One year experience in the transition of systems, including the transfer of knowledge and mentoring.

7.         Three years experience in the design and implementation of data warehousing and data mart activities in multiple, large scale database environment.

8.        Three years experience in designing strategies for migrating data from hierarchical to relational database structures, and integrating these strategies on multiple platforms.

Desirable Experience Preferred for This Position:

1. Excellent communication and interpersonal skills.  Superior knowledge of the English language and elevated ability to understand and be understood.

2.    Four or more years demonstrated experience working:

1.        In a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts.

2.        Using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.

3.        Building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.

3. Three or more years demonstrated experience:

1.        In an Oracle Data Warehouse as a developer performing development work.

2.        Using PL/SQL

3.        .Developing and testing maps in Oracle Warehouse Builder (OWB), data versioning techniques.

4.  Exceptional problem solving skills and superior ability to think and resolve technical issues under pressure.