> Markdown version of [/jobs/ext/1219854-it-specialist-etl-developer-albany-ny-onsite](https://www.wearedevelopers.com/jobs/ext/1219854-it-specialist-etl-developer-albany-ny-onsite). 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).

---

# IT Specialist (ETL Developer) - Albany, NY - Onsite

- **Company:** TechniPros, LLC
- **Location:** Albany, NY, United States
- **Experience:** Expert
- **Salary:** $80,000.0 - $120,000.0
- **Contract:** Permanent contract
- **Skills:** Business Analytics Applications, Data Analysis, Application Performance Management, Extract Transform Load (ETL), Data Mapping, Data Structures, Data Warehousing, Oracle Data Service Integrator, Oracle Databases, Software Architecture, PL-SQL, SQL Databases, Systems Integration, Performance Testing, Database Optimization, Tools for Reporting
- **Published:** July 9, 2026
- **Apply:** https://www.careerjet.com/jobad/usa5293f545b97e56fa816da8774bcc8d9

## About the Role

* 72 months of hands-on experience developing ETL/ELT solutions using Oracle Data Integrator (ODI).
 * Strong experience developing Mappings, Packages, Scenarios, and Procedures in ODI.
 * 72 months of experience creating ETL technical documentation including:
 * Source-to-Target Mapping Documents
 * ETL Design Documents
 * Technical Specifications
 * Use Cases
 * Software Architecture Documents
 * Implementation Documents
 * 72 months of experience writing and tuning SQL and PL/SQL.
 * Extensive experience with:
 * Oracle Database 12c or higher
 * Tables
 * Views
 * Indexes
 * Procedures
 * Functions
 * Triggers
 * Packages
 * 72 months of experience working with Oracle Data Integrator (ODI) 12c or later.
 * 60 months of experience serving as a Technical Team Lead for Data Warehouse and ETL platform architecture.
 * Experience in enterprise Data Warehouse architecture and ETL best practices.
 * Strong knowledge of database performance tuning and optimization.

Preferred Qualifications:

 * Experience developing, implementing, and integrating Criminal Justice systems.
 * Familiarity with State or Federal Criminal Justice business processes.
 * Knowledge of Criminal Justice terminology and nomenclature.
 * Experience working within large government or public sector environments.
 * Experience supporting enterprise-scale data warehouse platforms.

Soft Skills:

 * Excellent analytical and problem-solving skills.
 * Strong verbal and written communication skills.
 * Ability to collaborate effectively with cross-functional teams.
 * Strong documentation and technical writing abilities.
 * Leadership and mentoring skills.
 * Ability to manage multiple priorities in a fast-paced environment.

## Description

We are seeking an experienced IT Specialist (ETL Developer) to support enterprise data warehouse initiatives by designing, developing, implementing, and maintaining robust ETL/ELT solutions. The ideal candidate will possess strong expertise in Oracle Data Integrator (ODI), Oracle Database 12c+, PL/SQL, and data warehouse architecture. This role also requires technical leadership experience and familiarity with Criminal Justice systems., * Manage and maintain ETL/ELT solutions for enterprise data warehouse projects.

 * Perform ETL application analysis, design, development, testing, implementation, and support.
 * Develop and maintain data integration processes, data structures, and reporting solutions.
 * Analyze source data and prepare logical and physical data models.
 * Design and implement efficient ETL workflows using Oracle Data Integrator (ODI).
 * Serve as the primary ETL technical liaison with infrastructure teams to resolve application performance and technical issues.
 * Coordinate performance testing, failover planning, endurance testing, deployment planning, and implementation activities.
 * Provide oversight for ETL development activities, including data analysis, testing, and deployment.
 * Prepare, review, and maintain technical documentation including solution designs, schemas, architecture documents, and implementation guides.
 * Provide technical leadership and mentorship to ETL developers and project team members., Essential Duties and Responsibilities: - Oversee and interface with the developers to design, develop, test and implement critical functionality and POCs. - Work with clients to …
 + 7 days ago


## Related Videos

- [Web-based Information Visualization](https://www.wearedevelopers.com/videos/84-web-based-information-visualization)
- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)
- [Why Your AI Agent Keeps Hallucinating Your Data: Building Deterministic Context Layers](https://www.wearedevelopers.com/videos/2055-why-your-ai-agent-keeps-hallucinating-your-data-building-deterministic-context-layers)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [The Best Job Search Websites of 2025](https://www.wearedevelopers.com/magazine/368-the-best-job-search-websites-of-2025)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)