Maganti IT Resources LLC
Government & Public SectorDirect SmartRecruiters career site

DW ETL Developer - Rensselaer, NY - 24 Months- # K18511/240745

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

Skills & highlights for this role

  • US work authorization
  • Oracle PL/SQL
  • ETL development
  • Oracle Warehouse Builder
  • Informatica
  • data mart design

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: DW ETL Developer - Rensselaer, NY - 24 Months- # K18511/240745
  • Location: Rensselaer, NY
  • Duration: 24 Months

A Data Warehouse/Business Intelligence Developer resource is needed for the OCFS Data Warehouse/CONNECTIONS Reporting Module. The DW is sourced from the agency's major child welfare case management related systems: CONNECTIONS, CCRS, and WMS. The Data Warehouse effort consists of multiple sub-projects.

The efforts over the next 18 month period will include priorities including: ODS Support; ACS Support; management of Federal data transfers; load monitoring; AFCARS support; data warehouse and data moat purge; JJ mart for AFCARS; AFCARS FTP receive files; CONNECTIONS Quarterly Build changes; Infrastructure upgrades and enhancements (Cognos and Oracle upgrades); and more.

The OCFS Data Warehouse is a long term, ongoing effort to meet the data sharing and reporting needs of OCFS, the federal government, and local districts and voluntary agencies.

The first deliverables were deployed in 2000, and the warehouse continues to grow in terms of data volume, functionality, and customers on a continual basis, with heightening reliance on the availability of up to date child welfare data for local operational needs. The DW effort consists of many sub-projects, each with its own schedule and deliverables.

Approximately 10 sub-projects are currently in progress, with another 50 or so in the queue.

This request is for a Oracle Data Warehouse/Business Intelligence Developer and is required to design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture in support of these Data Warehouse projects. In addition, this resource will be responsible for managing the Data Warehouse daily processing operations (Operational Data Store) and job schedules.

If this resource is not procured, the Data Warehouse project will be left with insufficient Oracle Developers to address the workload over the next 24 months, leaving CONNECTIONS and other state and federal reporting needs unmet.

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 Operational Data Store 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 below 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 in an Oracle Data Warehouse as a developer performing development work.
  • 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 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.

Please note that our client does allow Skype/remote interviews. However they reserve the right to require an in-person interview.

About the Company

Candidate willing to work on our W2 payroll will be considered most.

Candidates eligible to work at USA with valid visa should apply.

Third Party Vendors Please do not submit your candidates.

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 DW ETL Developer - Rensselaer, NY - 24 Months- # K18511/240745 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 DW ETL Developer - Rensselaer, NY - 24 Months- # K18511/240745 job at Maganti IT Resources LLC located?

This DW ETL Developer - Rensselaer, NY - 24 Months- # K18511/240745 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 DW ETL Developer - Rensselaer, NY - 24 Months- # K18511/240745 at Maganti IT Resources LLC?

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

How do I apply for the DW ETL Developer - Rensselaer, NY - 24 Months- # K18511/240745 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.