Job Details

Software Analyst Oracle PL/SQL functional specifications and technical specifications test script

Location
Albany, NY, United States

Posted on
Oct 08, 2022

Apply for this job






Profile

HBITS-04-12374
Day-to-day tasks may include but are not limited to: Develop, test and execute Oracle SQL queries against the Finance 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 new NYWIC Finance module, 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
Software Analyst
Studies the software application domain, prepares software requirements, and specification documents. Liaises between the software users and the software developers. Conveys the demands of software users to the developers. Skills include: working knowledge of software technology; computer programming experience/expertise; general business knowledge; problem solving/reduction skills; interpersonal relation skills; flexibility and adaptability.
Expert: 84 months: 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
84 months 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.
****
Local:
518-218-1700
Map
& visit our office
Corporate - Albany NY
435 New Karner Rd, Ste 202
Albany NY 12205
Chicago
63E Lake Street, Ste 201
Chicago, IL 60601
Florida
17258 SE 121st Ave
Summerfield, FL 34491
© 2018 MVP Consulting Plus. All Rights Reserved.

Company info

Sign Up Now - SQLCrossing.com

Similar Jobs:
Senior SQL Developer (100% Remote)
Location : Albany, NY
Description If you have a desire to make a difference and have a 'real' impact, we want to talk to you! The Senior Software Engineer codes software applications based on business requirements. The Senior Software Engineer work a...
HBITS-04-12811 Daily tasks will include: Gather and validate of BI and reporting requirements Document requirements & solutions Perform Data profiling on the source systems Design and review star schema dimensional model to s...
HBITS-04-12801 Daily tasks will include: Gather and validate of BI and reporting requirements Document requirements & solutions Perform Data profiling on the source systems Design and review star schema dimensional model to s...
I like the volume of jobs on EmploymentCrossing. The quality of jobs is also good. Plus, they get refreshed very often. Great work!
Roberto D - Seattle, WA
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
SQLCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
SQLCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2025 SQLCrossing - All rights reserved. 168 192