I-Link Solutions
I-Link Solutions

HBITS-07-14630 - Oracle Warehouse Builder

Albany, NY, US • Posted 1 day ago • Updated 14 hours ago
Contract Corp To Corp
Contract Independent
Contract W2
No Travel Required
Able to Sponsor
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

  • Oracle Warehouse Builder
  • ODI
  • Data Modeling
  • PL/SQL
  • ETL

Summary

Job Description

  1. Work in coordination with a team of developers to expand the current Data Warehouse.
  2. Design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.
  3. Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
  4. Perform unit testing and correct all identified bugs.
  5. Perform complex PL/SQL coding in a Data Warehouse environment.
  6. Responsible for load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements
  7. Perform writing of complex stored procedures/triggers in an Oracle database utilizing OWB and ODI
  8. The individual in this position will work under the direction of a Technical Lead & Project Manager.

Mandatory Qualifications

184 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
284 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment
384 months experience working in an Oracle Data Warehouse performing development work using PL/SQL
484 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
584 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)
684 months experience in SDLC including: requirement gathering, development, testing, debugging, deployment, documentation and production support, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades).
784 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols
884 months experience in building database schemas, tables, views, indexes, and stored procedures
9Bachelor''''s Degree
  


Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10202797
  • Position Id: 8908263
  • Posted 1 day ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

ETL Developer w/ Oracle Data Integrator & OWB - HBITS-07-14629

Albany, New York

•

6d ago

Easy Apply

Contract

Depends on Experience

ETL Developer w/ Oracle Data Integrator & OWB - HBITS-07-14630

Albany, New York

•

6d ago

Easy Apply

Contract

Depends on Experience

Data Modeler - Passport copy Mandatory

Albany, New York

•

8d ago

Easy Apply

Full-time, Third Party

55 - 63

Data Modeler - Passport copy Mandatory

Albany, New York

•

8d ago

Easy Apply

Full-time, Third Party

55 - 63

Search all similar jobs