Senior Oracle PL/SQL & OBIEE Analyst

Trigyn Technologies Limited.; Village of Menands (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

TRIGYN TECHNOLOGIES, INC. in Menands, NY seeks an Oracle PL/SQL Developer for a direct government client project. You will develop and test SQL queries, build reusable query libraries, and assist staff with data structures and ad-hoc queries within OBIEE.

The role requires extensive PL/SQL experience, ELT-style collaboration with business units, and delivering documentation and testing support throughout the software lifecycle. On-site with strong governance adherence.

Qualifications

• Involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 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
• 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.

Responsibilities

• Develop, test and execute Oracle SQL queries against the schema of production 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 program staff in understanding data structures within the NYWIC modules, for developing new report requirements
• Assist program staff in developing new ad-hoc queries within the Datamart OBIEE system, using defined user guidelines and additional guidance from the Datamart team as needed
• Work with Datamart team members, program staff, and the application vendor as needed to develop a knowledgebase of system data mappings between the 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.

Skills

Oracle PL/SQL

SQL queries

Requirements gathering

Documentation

Education

Bachelor’s Degree in Information Technology related field

Tools

OBIEE

Job description

TRIGYN TECHNOLOGIES, INC. in Menands, NY seeks an Oracle PL/SQL Developer for a direct government client project. You will develop and test SQL queries, build reusable query libraries, and assist staff with data structures and ad-hoc queries within OBIEE.

The role requires extensive PL/SQL experience, ELT-style collaboration with business units, and delivering documentation and testing support throughout the software lifecycle. On-site with strong governance adherence.