
Oracle Data Warehouse & ETL Developer
GD Resources LLC
Albany, NY • 39m ago • On-site
Senior
On-site
Match your resume with similar open roles
Upload your resume to automatically match with active openings similar to this role.
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
Senior Oracle Data Warehouse / ETL Developer
Unicorn Technologies LLC
Senior
Technology
Albany, NY · Hybrid
$121k - $121k/yr
1 days ago

Oracle Developer | Data Warehouse & Data Engineering
Experis Manpower Group
Senior
Technology
Warsaw, Poland · On-site
N/A
15 days ago

Projektant Programista ds. Utrzymania Hurtowni Danych (f/m/x)
B2Bnetwork
Mid
Technology
Wrocław, Poland · On-site
N/A
14 days ago
Oracle Database Developer
Britenet
Senior
Technology
Warsaw, Poland · Remote
N/A
17 days ago
Oracle Database Developer
Britenet
Senior
Technology
Warsaw, Maz, Poland · Remote
N/A
16 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.
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
17 days ago

Oracle Database Developer (k/m)
Lumicode Sp. z o.o. (Pentacomp Group)
Senior
Technology
Warsaw, Poland · Remote
229k zł - 270k zł/yr
16 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
16 days ago

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