Software Developer at i-Link Solutions in Menands,, NY
- Company: i-Link Solutions
- Location: Menands,, NY
- Posted: Sep 18, 2026
- Type: Full-time
- Experience: 7+ years
Overview
Description Develop, test and execute Oracle SQL queries against the schema of the Production NYWIC database upon request, for program validation and data analysis Develop and maintain a library of SQL queries that can be executed on a recurring basis with different parameters, for similar requests
Job description
- Description
Responsibilities
- Develop, test and execute Oracle SQL queries against the schema of the Production NYWIC database upon request, for program validation and data analysis
- Develop and maintain a library of SQL queries that can be executed on a recurring basis with different parameters, for similar requests
- Assist DOH program staff in understanding NYWIC data structures within the NYWIC modules, for developing new report requirements
- Assist DOH program staff in developing new ad-hoc queries within the NYWIC Datamart OBIEE system, using defined user guidelines and additional guidance from the NYWIC Datamart team as needed
- Work with NYWIC Datamart team members, program staff, and the NYWIC application vendor as needed to develop a knowledgebase of system data mappings between the NYWIC application and the Datamart, for program assistance
- Participate in review and/or documentation of regression test scripts for user acceptance testing
- Provide general support for user acceptance testing efforts
- Work closely with ITS and Program managers to ensure adherence to standard policies and procedures
Requirements
- 1 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL
- 2 84 months of experience meeting with business staff to elicit business requirements
- 3 84 months of experience working with business staff or end users to analyze or troubleshoot Oracle reports
- 4 84 months of experience creating software documentation including functional specifications and technical specifications
- 5 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance
- 6 48 months of experience preparing or facilitating the creation of testing scenarios and test scripts
- 7 36 months of experience creating user documentation such as user guides or training presentations
- 8 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end user experience
- 9 Bachelor's Degree in an Information Technology related field, from an accredited institution.
Skills
Required
- Oracle PL/SQL
- SQL queries and stored procedures
- Testing scenarios and test scripts
- Data analysis
- Troubleshooting Oracle reports