Sr. Oracle PL/SQL Consultant with OBIEE

Sligo Software Solutions Inc.; Village of Menands (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

Sligo Software Solutions Inc. is seeking a Sr. Oracle PL/SQL Consultant with OBIEE for the NY Department of Health project in Menands, NY. The role focuses on data warehousing, complex SQL, and reporting in a .NET/Oracle environment.

The candidate will develop and optimize SQL queries, support data mappings, and collaborate with business staff to deliver accurate reports. This is an onsite role with a 30-month duration, requiring extensive experience and strong documentation skills.

Qualifications

• 12+ years of experience in software development lifecycle and hands-on Oracle PL/SQL
• OBIEE development and reporting experience with data warehouse environments
• Proficient in writing and optimizing complex SQL queries
• Ability to elicit and document business requirements and translate them into technical specs
• Experience creating technical documentation and user guides for reporting solutions

Responsibilities

• Develop, test and optimize Oracle SQL queries against Production NYWIC databases
• Maintain a library of reusable SQL queries for recurring requests
• Collaborate with DOH staff to understand NYWIC data structures for reporting needs
• Develop ad-hoc queries in NYWIC Datamart OBIEE ecosystem following guidelines
• Create data mappings and knowledge base with NYWIC Datamart team and vendors
• Participate in regression testing and user acceptance testing
• Provide support during UAT and assist with test scripts and scenarios
• Coordinate with ITS and program managers to follow standard policies and procedures

Skills

Oracle PL/SQL

OBIEE

SQL

Requirements gathering

Documentation

Education

Bachelor's Degree in Information Technology related field

Tools

OBIEE

Job description

Greetings from Sligo Software Solutions, Inc. !!

This is Dasharatham from SLIGO. We have an urgent requirement for Sr. Oracle PL/SQL Consultant with OBIEE position with our client.

Title

Sr. Oracle PL/SQL Consultant with OBIEE

Location

Menands, New York

Duration

30 Months

Client

NY State - Department of Health

Job ID

SLG - 26 - 12420

Respond by

09/24/26 5:00 PM

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.

Duties

• 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

Mandatory Requirements

• Experience (12+ Years)
• Is involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software.

Requirements

• This is an 100% Onsite.
• 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.
• 84 months of experience creating software documentation including functional specifications and technical specifications.
• 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance.
• 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.
• R sum
• Copy of Candidate Identification (i.e., Driver s License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)