Oracle PLSQL Developer-W2 Only-Albany, NY-Hybrid

iSite Technologies Corp.; City of Albany (NY); On-site; USD 95,000 - 125,000; Full time

Job summary

iSite Technologies Corp. in New York seeks an experienced IT analyst to support NYWIC data initiatives. You will develop, test and optimize Oracle SQL queries against the Production NYWIC schema, and build reusable query libraries for recurring requests.

You will collaborate with DOH staff, NYWIC Datamart team and the application vendor to map data, review regression tests, support UAT, and ensure compliance with policies.

Qualifications

• Experience creating software documentation (functional and technical specs).
• Experience preparing or facilitating testing scenarios and test scripts.
• Experience creating user guides or training materials.
• Experience using OBIEE with end-user interaction.
• Bachelor's degree in an IT-related field.
• Experience analyzing/improving Oracle SQL queries for performance.
• Experience writing SQL queries and PL/SQL stored procedures.
• Experience eliciting business requirements from staff.
• Experience troubleshooting Oracle reports with business users.

Responsibilities

• Develop, test and execute Oracle SQL queries against the Production NYWIC schema for validation and data analysis.
• Maintain a library of SQL queries for recurring requests with varying parameters.
• Assist DOH staff in understanding NYWIC data structures for new reports.
• Assist in developing ad-hoc queries in NYWIC Datamart OBIEE with guidelines and vendor guidance.
• Collaborate with NYWIC Datamart team, staff and vendor to map data between NYWIC and Datamart.
• Participate in review and documentation of regression test scripts for UAT.
• Provide general support for user acceptance testing efforts.
• Work with ITS and Program managers to ensure adherence to policies and procedures.

Skills

Software documentation

Testing scenarios

User documentation

OBIEE usage

Oracle SQL

Oracle PL/SQL

Requirements gathering

Oracle reports troubleshooting

Education

Bachelor's Degree in Information Technology

Job description

Day-to-Day Tasks

• 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

Required Qualifications

• 84 months of experience creating software documentation including functional specifications and technical specifications
• 48 months of experience preparing or facilitating the creation of testing scenarios and test scripts
• 36 months of experience creating user documentation such as user guides or training presentations
• 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end user experience
• Bachelor's Degree in an Information Technology related field, from an accredited institution.
• 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance
• 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL
• 84 months of experience meeting with business staff to elicit business requirements
• 84 months of experience working with business staff or end users to analyze or troubleshoot Oracle reports