Vacancy expired!
NTT DATA, Inc., a top 10 global IT services company, has an immediate need for a Oracle PL/SQL Software Analyst to support our State Government client in Albany, NY 12207ROLE Oracle PL/SQL Software AnalystINDUSTRY State Government DURATION 18+ month Contract, probable extension LOCATION Albany, NY 12207 2 days onsite and 3 days remote PROJECT - WIC (Special Supplemental Nutrition Program for Women, Infants and Children)Selected candidate will function in a software analyst role, providing data analysis support and UAT support for the NYWIC Management Information System, which is in the maintenance phase.NYWIC is a State-hosted, vendor-maintained web application that is used to deliver nutritional benefits to New York s women, infants and children in need; also used for vendor management, investigation case management, research and reporting to USDA.Responsibilities:
- 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
- 7 years (84+ mon) 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.
- 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.
- 7 years (84 m) of experience creating SQL queries and stored procedures using Oracle PL/SQL
- 7 years (84 m) of experience meeting with business staff to elicit business requirements
- 7 years (84 m) of experience working with business staff or end users to analyze or troubleshoot Oracle reports
- 7 years (84 m) creating software documentation including functional specifications and technical specifications
- 4 years (48 m) of experience preparing or facilitating the creation of testing scenarios and test scripts
- 3 years (36 m) of experience creating user documentation such as user guides or training presentations
- 3 years (36 m) 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.
Vacancy expired!