
Senior Oracle Data Warehouse / ETL Developer
Unicorn Technologies LLC
Albany, NY • 1h ago • Hybrid
Senior
Hybrid
120,640 - 120,640 USD/yr
Match your resume with similar open roles
Upload your resume to automatically match with active openings similar to this role.
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
Oracle Developer | Data Warehouse & Data Engineering
Experis Manpower Group
Senior
Technology
Warsaw, Poland · On-site
N/A
14 days ago
Oracle Database Developer
Britenet
Senior
Technology
Warsaw, Poland · Remote
N/A
16 days ago

Projektant Programista ds. Utrzymania Hurtowni Danych (f/m/x)
B2Bnetwork
Mid
Technology
Wrocław, Poland · On-site
N/A
13 days ago
Projektant Programista ds. Utrzymania Hurtowni Danych (Oracle, SQL, PL/SQL, Ab Initio)
Upvanta sp. z o.o.
Mid
Technology
Wrocław, DL, Poland · On-site
N/A
16 days ago
Oracle Database Developer
Britenet
Senior
Technology
Warsaw, Maz, Poland · Remote
N/A
15 days ago
Tailor Resume to fit the Job Offer
Use AI to find out how well the skills on your resume fit this job description.

Senior DWH/ETL Developer
BlueSoft
Senior
Technology
Warsaw, Maz, Poland · Remote
N/A
13 days ago

Oracle Database Developer (k/m)
Lumicode Sp. z o.o. (Pentacomp Group)
Senior
Technology
Warsaw, Poland · Remote
229k zł - 270k zł/yr
15 days ago

Specjalista ds. Baz Danych (Oracle)
Lumicode Sp. z o.o. (Pentacomp Group)
Senior
Technology
Warsaw, MA, Poland · Remote
229k zł - 270k zł/yr
15 days ago

Senior Database Developer (Oracle / PL/SQL / ETL) (f/m/x)
B2Bnetwork
Senior
Technology
Remote
N/A
16 days ago
Unlock Full Resume Report
ATS Pass
Missing keywords
Tailored AI suggestions
Job match analysis
Interview-focused insights