Oracle PLSQL Developer-W2 Only-Albany

Isite Technologies Inc

New York, NY, United States

7 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Data Analysis Software Documentation Databases Data Mart Data Structures Oracle Business Intelligence Enterprise Edition Oracle SQL Developer Regression Testing SQL Stored Procedures SQL Databases Test Scripts Database Performance

+2 more

Information Technology Oracle Reports

Job 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
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

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