Oracle Data Warehouse & ETL Developer (OWB to ODI Migration Specialist)

Albany, GA - USA

Monthly Salary: Not Disclosed

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Title : Oracle Data Warehouse & ETL Developer (OWB to ODI Migration Specialist)13 years exp

Location: Albany NY (Hybrid)

We are currently seeking candidates who meet the following qualifications

Qualifications:

Experience analyzing and reverse-engineering legacy Oracle Warehouse Builder (OWB) ETL workflows and designing replacement processes in Oracle Data Integrator (ODI) while preserving existing business functionality and data integrity.
Strong background in Data Modeling (Dimensional and Relational) including normalization and de-normalization techniques process optimization data extraction data cleansing and data transformation within a child welfare domain environment.
Hands-on experience working within an Oracle Data Warehouse environment performing development using PL/SQL.
Proficient in advanced ETL methodologies including bulk collect bulk insert array processing dynamic SQL and the design and implementation of detailed incremental load processes.
Experience developing and testing ODI mappings performing comprehensive source-to-target mapping analysis conducting storage capacity planning and building robust ETL solutions using Oracle Data Integrator.
Full lifecycle experience across the Software Development Life Cycle (SDLC) including requirements gathering development unit testing debugging deployment documentation and production support. Experience resolving data load issues handling load inquiries performing second-level issue analysis implementing code fixes and supporting infrastructure and Oracle database upgrades.
Experience working in UNIX/Linux environments including development of Unix shell scripts and managing secure file transfers using SFTP protocols.
Experience designing and building database objects such as schemas tables views indexes and stored procedures.
Bachelors Degree.

If you meet these qualifications please submit your application via link provided in LinkedIn.
Kindly do not call the general line to submit your application.

Job Title : Oracle Data Warehouse & ETL Developer (OWB to ODI Migration Specialist)13 years exp Location: Albany NY (Hybrid) We are currently seeking candidates who meet the following qualifications Qualifications: Experience analyzing and reverse-engineering legacy Oracle Warehouse Builder (OWB) E...