ETL Developer (Oracle ODI) 8+ yrs Exp

ACS -

Albany, NY, United States

about 1 month ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Computing Platforms Information Systems Data Governance Extract Transform Load (ETL) Data Warehousing Oracle Data Service Integrator Oracle Databases Oracle (Applications) Software Architecture SQL Stored Procedures SQL Databases Systems Integration

+1 more

Enterprise Data Management

Job description

Job Summary The candidate will be responsible for designing, developing, implementing, and supporting enterprise data integration solutions using Oracle Data Integrator (ODI) to …

5 hours ago
Apply easily +

Requirements

Experience designing, developing, and maintaining ETL/ELT solutions using Oracle Data Integrator (ODI), including mappings, packages, scenarios, procedures, and related integration components.
Experience preparing comprehensive technical documentation, including ETL source-to-target mapping specifications, use cases, software architecture documents, ETL design specifications, and implementation documentation.
Experience developing, optimizing, and troubleshooting SQL and PL/SQL code, including tables, views, indexes, stored procedures, functions, triggers, and packages within Oracle Database 12c or later.
Experience implementing and supporting Oracle Data Integrator (ODI) 12c or later in enterprise data integration and data warehousing environments.
Experience serving as a technical team lead, providing architectural guidance, technical oversight, and leadership for data warehouse and ETL platform design, development, and implementation.
Experience designing, developing, implementing, and integrating Criminal Justice information systems at the state or federal level, with knowledge of Criminal Justice business processes, terminology, data standards, and system integration requirements.