Oracle PL/SQL Developer-OBIEE
Interview: Virtual Interview
Work model: Up to 50 % telecommuting, 50% Office per week in Albany, New York
--- Project Description ---
The NYWIC (New York Women, Infants, and Children) system is a statewide
application that supports the administration of New York's WIC nutrition program,
which provides nutritional assistance and health services to eligible women, infants,
and children.
The Division of Nutrition relies on custom applications to support the delivery of
these programs. The NYWIC MIS-EBT project provides a .NET/Oracle-based
platform that enables efficient program operations and ongoing enhancements to
meet evolving business needs.
Within this environment, the DataMart team is responsible for the design,
development, and ongoing maintenance of the enterprise data warehouse and
reporting layer supporting the NYWIC application. The team includes Software
Analysts, Data Modelers, Informatica Developers, Software Developers, and OBIEE
Developers who work collaboratively to deliver and sustain data solutions.The team
continuously implements enhancements and updates to the DataMart as the core
application evolves, ensuring accurate, reliable, and timely reporting for business
users, program administrators, and regulatory stakeholders.
--- Day-to-Day Tasks ---
1. Develop, test and execute Oracle SQL queries against the schema of the
Production NYWIC database upon request, for program validation and data analysis
2. Develop and maintain a library of SQL queries that can be executed on a recurring
basis with different parameters, for similar requests
3. Assist DOH program staff in understanding NYWIC data structures within the
NYWIC modules, for developing new report requirements
4. 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
5. 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
6. Participate in review and/or documentation of regression test scripts for user
acceptance testing
7. Provide general support for user acceptance testing efforts
8. 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
Never miss an opportunity! Create an alert based on the job you applied for.
