Avenues International, Inc.
Avenues International, Inc.

ETL ODI Developer - 24 Months - Albany, NY 12223 (3 days Onsite per week)

Hybrid in Albany, NY, US • Posted 5 hours ago • Updated 5 hours ago
Contract Corp To Corp
Contract W2
Contract Independent
No Travel Required
Hybrid
$70 - $75/hr
Fitment

Dice Job Match Score™

⏳ Almost there, hang tight...

Job Details

Skills

  • Data Cleansing
  • Data Extraction
  • Data Manipulation
  • Data Modeling
  • Data Warehouse
  • Extract
  • Transform
  • Load
  • Linux
  • OWB
  • Oracle
  • Oracle Data Integrator
  • Oracle Warehouse Builder
  • PL/SQL
  • Stored Procedures
  • Unix
  • SQL
  • Shell Scripting
  • Software Development Methodology
  • Requirements Elicitation
  • Production Support
  • Normalization
  • database schemas
  • indexes
  • de-normalization

Summary

Hi ,

We are looking to hire suitable candidates for HBITS-07-14630 - ETL ODI Developer opportunity with one of our clients in Albany, NY 12223.

We are a prime vendor to the New York State and work on their HBITS: Hourly-Based IT Services (New York Statewide) requirements.

Position Name: ETL ODI Developer

Job ID: HBITS-07-14630

Duration: 24 Months
Location: Albany, NY 12223 (3 days Onsite per week)

Primary Skills:

  • 84 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
  • 84 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment.
  • 84 months experience working in an Oracle Data Warehouse performing development work using PL/SQL.
  • 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
  • 84 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI).
  • 84 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).
  • 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols.
  • 84 months experience in building database schemas, tables, views, indexes, and stored procedures.

Thanks & Regards

Adarsh Shukla

Human Resources Manager

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: avenj001
  • Position Id: HBITS-07-14630
  • Posted 5 hours 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

•

Yesterday

Easy Apply

Contract

Depends on Experience

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

Albany, New York

•

Yesterday

Easy Apply

Contract

Depends on Experience

Data Modeler - Passport copy Mandatory

Albany, New York

•

3d ago

Easy Apply

Full-time, Third Party

55 - 63

Data Modeler - Passport copy Mandatory

Albany, New York

•

3d ago

Easy Apply

Full-time, Third Party

55 - 63

Search all similar jobs