Back to Jobs
Recently postedTechnology

Oracle Data Warehouse / ETL Developer (ODI) - HBITS-08-15117

GreyCell Labs, IncAlbany, NY🇺🇸United States

Quick overview

Work modeOn-site
LocationAlbany, NY, United States
OraclePL/SQLSQLShellETLLinux

Job description

Job Title: ON-SITE - Oracle Data Warehouse / ETL Developer (ODI) - HBITS-08-15117

Location: Albany, NY

Duration: 24 Months

Job Description:

  • 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

  • Bachelor’s Degree

________________________________________________________________

Agency: Office of Children & Family Services

Project: OCFS Data Warehouse

Detailed Job Description: This position is for a systems developer with experience working on a Oracle Data Warehouse/Business Intelligence team. The developer will design/model, construct, load and validate the tables through the enterprise Data Warehouse architecture.

Note: Sorry we do not Sponsor Visa
Max: SEVEN 32.800.2838

Aryan: - SEVEN 32.444.8990

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs