Oracle ODI / ETL / Data Warehouse Lead

Maagsoft Inc.

Albany, NY, United States

29 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

6 years minimum

Compensation

$142,032.0 - $149,287.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Extract Transform Load (ETL) Data Mapping Data Warehousing Oracle Data Service Integrator Oracle Databases Oracle (Applications) Software Architecture PL-SQL SQL Databases Systems Integration Information Technology

Job description

The Office of the New York State Attorney General’s (OAG) Information Technology Bureau (ITB) is seeking an experienced technology manager to serve as Director of Enterprise Artifi…

5 days ago +

Requirements

72 months experience developing ETL/E-LT objects including Mapping, Packages, Scenarios and Procedures using Oracle Data Integrator. 72 months experience writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents and implementation documents. 72 months experience in writing and tuning SQL scripts including: tables, view s, indexes, and complex PL/SQL objects including: procedures, functions, triggers, and packages in Oracle database 12c or higher. 72 months experience working with Oracle Data Integrator 12c or later. 60 months experience as a technical team lead responsible for data warehouse and ETL platform architecture. 24 months experience developing, implementing, and integrating systems related to Criminal Justice processing at the state or federal level using Criminal Justice terminology and nomenclatures. Required Documentation: Resume Copy of Candidate Identification (i.e., Driver’s License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)