Maganti IT Resources LLC
Government & Public SectorDirect SmartRecruiters career site

Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645

Location
Rensselaer, NY · On-site
Job type
Contract
Level
Mid-level
Education
Bachelor's degree
Listed
Today

Skills & highlights for this role

  • Oracle PL/SQL
  • ETL development
  • data warehouse design
  • Oracle Warehouse Builder or Informatica

Also useful

  • Cognos
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Maganti IT Resources LLC role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

About the role

Title: Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645

Location: Rensselaer, NY

Duration: 24 Months

2-3 references required.

About the role

The Division of Juvenile Justice and Opportunities for Youth (DJJOY) Juvenile Justice Information System (JJIS) is a web-based application using.Net technology. It tracks juvenile justice youth through detention facilities into OCFS placement where they go through Intake, Residential, and CMSO (community multi-service organizations) programs and services, and also provides an automated financial/billing module.

JJIS moved into Phase 4 development in April 2010. The first three phases included a full system re-write (deployed in July 2007) based on the legacy system developed in the 1970's, plus many functional enhancements. Phase 4 is defined by the priority system enhancements required to support program improvements in DJJOY facilities as required by the federal Department of Justice (DOJ) settlement agreement, as well as many additional functionality enhancements to support case management and other operational processes throughout OCFS' juvenile justice system.

Examples of priority work to be completed in JJIS Phase 4 include, but are not limited to: a comprehensive youth interventions/counseling module to include individual and group interventions, single working diagnosis, and psychotropic medications tracking support; Imaging; Unusual Incident Report (UIR) system re-write and integration; Treatment Team form automation; transitional planning support; additional restraint reporting from the Automated Restraint Tracking System (ARTS, which is integrated with JJIS); HIPAA compliance; and more.

This request is for an Oracle Data Warehouse Developer with report development experience. The person in this position will work on DJJOY data modeling/design, ETL, and validation within the OCFS enterprise data warehouse architecture. In addition, this person will assist with Cognos report development, including creating packages, cubes and reports, and applying security. This position is needed in order to meet the vast data/report requirements for DJJOY and related to the DOJ system enhancements.

Duties include but are not limited to

  • Work in coordination with a team of developers to expand the current Data Warehouse.
  • Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
  • Perform unit testing and correct all identified bugs.
  • Perform complex PL/SQL coding in a Data Warehouse environment.
  • Assist with responding to Juvenile Justice data requests.
  • The individual in this position will work under the direction of a Technical Lead & Project Manager.
  • Perform writing of complex stored procedures/triggers in an Oracle database utilizing PL/SQL

Qualifications & Requirements

Candidates should have at least 60 months experience, and following should apply:

  • Experience in a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts.
  • Experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
  • Experience building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.
  • Experience using PL/SQL
  • Experience developing and testing maps in Oracle Warehouse Builder (OWB) or Informatica, including data versioning techniques.
  • Problem solving skills and ability to think and resolve technical issues under pressure
  • Bachelor's Degree. Proof of Education for all candidates are to be submitted with all responses..

Additional Information

  • Please note that our client does allow Skype/remote interviews. However they reserve the right to require an in-person interview.
  • Please respond with updated resume and covering letter with few sentences how you meet each Requested Qualification referring your earlier projects
  • 3 references are must with the resume.
Read the original posting

From Maganti IT Resources LLC's careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645 role at Maganti IT Resources LLC, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645 job at Maganti IT Resources LLC located?

This Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645 position at Maganti IT Resources LLC is located in Rensselaer, NY (On-site). Always check Maganti IT Resources LLC's application page for specific state eligibility or relocation policies.

What qualifications are required for Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645 at Maganti IT Resources LLC?

For the Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645 role, Maganti IT Resources LLC highlights a bachelor's degree; experience with Oracle PL/SQL, ETL development, data warehouse design, Oracle Warehouse Builder or Informatica. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645 position at Maganti IT Resources LLC?

This listing links directly to Maganti IT Resources LLC's SmartRecruiters application page. You can apply directly on Maganti IT Resources LLC's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.