Oracle Data Warehouse & ETL Developer

GD Resources LLC

Albany, NY • 39m ago • On-site

Senior

On-site

  1. Select offer
  2. Add resume
  3. Analyze
  4. Improve
  5. Apply
  6. Auto-send · soon

Match your resume with similar open roles

Upload your resume to automatically match with active openings similar to this role.

PDF up to 10 MB

Your resume is private & secure

Or go to the original job offer
0

Quick Facts

  • Role: Oracle Data Warehouse & ETL Developer (Systems Developer)
  • Duration: 24 months
  • Location: Albany, NY

Description

Work on an Oracle Data Warehouse/Business Intelligence team to design, model, construct, load, and validate tables using the enterprise data warehouse architecture. Collaborate with business analysts and customers on mappings and ETL logical design, and perform unit testing plus production support activities. Implement complex PL/SQL and stored procedures/triggers using OWB and ODI.

Responsibilities

  • Expand the current data warehouse in coordination with a team of developers
  • Design/model, construct, load, and validate data warehouse tables
  • Build and test ETL mappings (source-to-target) and perform capacity planning
  • Perform unit testing and fix identified bugs
  • Develop complex PL/SQL code for a data warehouse environment
  • Resolve load issues, answer load inquiries, and perform second-level testing and code fixes
  • Support infrastructure upgrades/enhancements (including Oracle upgrades)
  • Write complex stored procedures/triggers using OWB and ODI

Requirements

  • 84+ months experience reverse engineering Oracle Warehouse Builder (OWB) ETL and developing replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality
  • 84+ months experience developing in an Oracle Data Warehouse using PL/SQL
  • 84+ months experience with dimensional and relational data modeling, data normalization/denormalization, and data extraction/manipulation (child welfare environment)
  • 84+ months experience with advanced ETL techniques (bulk select, bulk insert, arrays, dynamic SQL) and incremental ETL development
  • 84+ months experience developing and testing ODI/OWB mappings (source-to-target) and storage capacity planning
  • 84+ months experience with SDLC activities including requirement gathering, development, testing, debugging, deployment, documentation, and production support (including load issue resolution)
  • 84+ months experience working in Unix/Linux with shell scripting and sftp protocols
  • Experience building database schemas, tables, views, indexes, and stored procedures
  • Bachelor’s degree

Benefits

Not specified in the posting.

See similar jobs

Explore similar jobs and use your resume score to choose where to apply next

See more

Unlock Full Resume Report