Systems Developer
Albany, NY
Contracted
Experienced
“Join GD Resources for dynamic opportunities in business management and IT, where innovation meets excellence.”
About the Company:
GD Resources is a Veteran Women-Owned Business Management and Information Technology company committed to excellence. GD Resources provides dynamic opportunities for veterans and professionals alike to contribute to innovative projects and drive success in a collaborative and supportive environment. Join us to make a difference, advance your career, and grow with a company that values integrity, diversity, and continuous improvement.
Disclaimer: Applicants must be located within a commutable distance to the job site. Please do not apply if you are not within reasonable commuting range, relocation is not available for this position. Thank you for understanding.
Title: Systems Developer
HBITS Task Order: HBITS-06-14111
Agency: Office of Children and Family Services (OCFS)
Location: Albany, NY (Hybrid – 50% remote)
Rate: Depends on experience
Position Overview:
Project is part of the New York HBITS initiative supporting Child Care state and federal reporting through the OCFS Oracle Data Warehouse. The Systems Developer will enhance ETL processes and reporting related to CCFS and FAMS systems.
Responsibilities:
Qualifications:
Required Documents:
About the Company:
GD Resources is a Veteran Women-Owned Business Management and Information Technology company committed to excellence. GD Resources provides dynamic opportunities for veterans and professionals alike to contribute to innovative projects and drive success in a collaborative and supportive environment. Join us to make a difference, advance your career, and grow with a company that values integrity, diversity, and continuous improvement.
Disclaimer: Applicants must be located within a commutable distance to the job site. Please do not apply if you are not within reasonable commuting range, relocation is not available for this position. Thank you for understanding.
Title: Systems Developer
HBITS Task Order: HBITS-06-14111
Agency: Office of Children and Family Services (OCFS)
Location: Albany, NY (Hybrid – 50% remote)
Rate: Depends on experience
Position Overview:
Project is part of the New York HBITS initiative supporting Child Care state and federal reporting through the OCFS Oracle Data Warehouse. The Systems Developer will enhance ETL processes and reporting related to CCFS and FAMS systems.
Responsibilities:
- Build and expand Oracle-based Data Warehouse
- Design and validate dimensional and relational data models
- Collaborate on ETL mappings using ODI/OWB
- Write complex PL/SQL code, stored procedures, and triggers
- Test and resolve infrastructure and performance issues
- Handle Unix/Linux scripting for automation
- Assist in database schema development and management
- Participate in weekly knowledge transfer and documentation
- Support SDLC lifecycle activities
- Work with project managers and technical leads on enhancements
Qualifications:
- 7+ years of PL/SQL development in Oracle DW
- 7+ years in ETL techniques using OWB/ODI
- 7+ years of dimensional modeling and data cleansing
- 7+ years writing/testing ETL and source-to-target mappings
- 7+ years of full SDLC support
- 7+ years Unix/Linux scripting experience
- 7+ years building and optimizing database structures
- Bachelor’s degree
Required Documents:
- Resume
- Valid ID (Driver’s License, Green Card, Visa, Passport)
- Relevant degrees/certifications
Apply for this position
Required*