> Markdown version of [/jobs/ext/1282907-oracle-odi-etl-data-warehouse-lead](https://www.wearedevelopers.com/jobs/ext/1282907-oracle-odi-etl-data-warehouse-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Oracle ODI / ETL / Data Warehouse Lead

- **Company:** Maagsoft Inc.
- **Location:** Albany, NY, United States
- **Experience:** Expert
- **Salary:** $142,032.0 - $149,287.0
- **Contract:** Permanent contract
- **Skills:** Extract Transform Load (ETL), Data Mapping, Data Warehousing, Oracle Data Service Integrator, Oracle Databases, Oracle (Applications), Software Architecture, PL-SQL, SQL Databases, Systems Integration, Information Technology
- **Published:** July 15, 2026
- **Apply:** https://www.careerjet.com/jobad/usf217f7dbef95afe824764777c83bdd1a

## About the Role

72 months experience developing ETL/E-LT objects including Mapping, Packages, Scenarios and Procedures using Oracle Data Integrator.
72 months experience writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents and implementation documents.
72 months experience in writing and tuning SQL scripts including: tables, view s, indexes, and complex PL/SQL objects including: procedures, functions, triggers, and packages in Oracle database 12c or higher.
72 months experience working with Oracle Data Integrator 12c or later.
60 months experience as a technical team lead responsible for data warehouse and ETL platform architecture.
24 months experience developing, implementing, and integrating systems related to Criminal Justice processing at the state or federal level using Criminal Justice terminology and nomenclatures.
Required Documentation:
Resume
Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable)
Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)

## Description

The Office of the New York State Attorney General's (OAG) Information Technology Bureau (ITB) is seeking an experienced technology manager to serve as Director of Enterprise Artifi…

 + 5 days ago
+


## Related Videos

- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Web-based Information Visualization](https://www.wearedevelopers.com/videos/84-web-based-information-visualization)
- [TiDB, One Layer at a Time: How Distributed SQL Became an Agentic AI Backbone](https://www.wearedevelopers.com/videos/100117-tidb-one-layer-at-a-time-how-distributed-sql-became-an-agentic-ai-backbone)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)
- [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)