Senior Oracle Data Warehouse / ETL Developer

Unicorn Technologies LLC

Albany, NY • 1h ago • Hybrid

Senior

Hybrid

120,640 - 120,640 USD/yr

  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

Potential salary for Senior Oracle Data Warehouse / ETL Developer role

Improve your resume now

$120,640 – $120,640/year

Quick Facts

  • Role: Senior Oracle Data Warehouse / ETL Developer
  • Work style: Hybrid
  • Interview type: Webcasting

Description

Work on an Oracle Data Warehouse/Business Intelligence team to design/model, construct, load, and validate warehouse tables. Develop and maintain ETL processes using Oracle Warehouse Builder (OWB) and replacement Oracle Data Integrator (ODI) mappings, including complex PL/SQL coding and stored procedures/triggers. Own unit testing, bug fixes, load issue resolutions, and 2nd-level testing, including infrastructure upgrades and enhancements.

Responsibilities

  • Coordinate with a development team to expand the enterprise Data Warehouse
  • Perform analysis and logical design for ETL mappings with Business Analysts and customers
  • Conduct unit testing, identify bugs, and apply code fixes
  • Resolve load issues and respond to load inquiries; perform 2nd-level testing
  • Write complex PL/SQL in a Data Warehouse environment
  • Build complex stored procedures/triggers using OWB and ODI
  • Support infrastructure upgrades and enhancements

Requirements

  • 84+ months experience developing and reverse engineering Oracle Warehouse Builder (OWB) ETL processes and building replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality
  • 84+ months experience with dimensional and relational data modeling (normalization/denormalization), data extraction, data cleansing, and data manipulation (child welfare environment)
  • 84+ months experience performing Oracle Data Warehouse development using PL/SQL
  • 84+ months experience with advanced ETL techniques: bulk select, bulk insert, arrays, dynamic SQL, and incremental ETL
  • 84+ months experience developing and testing ODI maps, performing source-to-target mappings, storage capacity planning, and developing ETL in ODI
  • 84+ months experience across the SDLC: requirements gathering, development, testing, debugging, deployment, documentation, and production support (including load issue resolutions and Oracle upgrades)
  • 84+ months experience in UNIX/Linux with Unix shell scripting and SFTP protocols
  • 84+ months experience building database schemas, tables, views, indexes, and stored procedures
  • Bachelor’s degree
  • Provide a detailed description of how you meet mandatory/requested qualifications, including prior employers with start/end dates and references

Benefits

  • Rate: $58/hr on C2C

See similar jobs

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

See more

Unlock Full Resume Report