PL / SQL Developer w/ OBIEEE - HBITS-08-15016

Greycell Labs Inc; City of Albany (NY); On-site; USD 100,000 - 130,000; Full time

Job summary

Greycell Labs Inc on-site position for a PL/SQL Developer with OBIEE experience in Albany's NY area. The role focuses on Oracle SQL, reports, and data warehouse development within the NYWIC project.

The project emphasizes collaboration with the Department of Health and other stakeholders, delivering robust data solutions and documentation. A Bachelor's degree in IT is required, and visa sponsorship is not available.

Qualifications

• 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.

Responsibilities

• Design, develop, and maintain the NYWIC DataMart and reporting layer.
• Collaborate with software analysts, data modelers, and ETL developers to deliver data solutions.
• Elicit requirements from business users and translate them into technical specifications.

Skills

PL/SQL

Requirements elicitation

Reports analysis

Documentation

SQL tuning

Testing scenarios

User guides

Education

Bachelor’s Degree in IT

Tools

OBIEE

Oracle Reports

Oracle DB

Job description

Job Title: ON-SITE - PL / SQL Developer w/ OBIEEE - HBITS-08-15016

Location: Menands, NY 12204

Duration: 30 Months

Job Description

• 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.

Agency: Department of Health

Project: Special Supplemental Nutrition Program for Women, Infants, and Children (WIC)

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

Note

Sorry we do not Sponsor Visa