Senior Oracle Programmer ( Only Consultant working with NYC DSS/HRA)

Innovee Consulting LLC; New York (NY); On-site; USD 140,000 - 170,000; Full time

Job summary

Innovee Consulting LLC in Brooklyn, NY seeks a Senior Oracle Programmer to design, develop and deploy Oracle-based data solutions within a large data warehouse environment. You will specify system designs, create data models, and lead OBIEE 12c reporting initiatives, including RPD deployment and security considerations.

You will collaborate with managers, senior programmers, and analysts to implement features, test scripts, and deliver business-facing documentation and dashboards for

Qualifications

• Strong analytical skills with the ability to translate requirements into technical specifications.
• Excellent English communication, both written and spoken.
• Experience leading design and implementation of software solutions.
• Ability to plan tests and evaluate large data sets.

Responsibilities

• Develop system design specifications.
• Develops and prepares documents for general design of solutions meeting system and security requirements.
• Develops specifications for databases, security, and software configurations.
• Develops structured diagrams for data and logical models.
• Develops business-friendly descriptions for database elements and their usage in legacy systems.
• Confer with staff and users to identify and document system requirements.
• Read documents from data warehouse sources and create change requests.
• Perform system design/development.
• Test programming scripts and analyze resulting data.
• Design reports, screen layouts, and user instructions to support business requirements.
• Architect, analyze, design, develop, administer, deploy all layers of RPD.
• Provide assistance to technical support staff for usability issues.
• Frequent contact with customers and legacy system developers to clarify new features or resolve problems.
• Perform testing/evaluation.
• Test systems and changes during release.
• Assist in QA and testing strategy and risks.

Skills

Analytical thinking

English communication

Leadership in design specs

Test planning

Tools

OBIEE 12c

Oracle Portal

RPD Design

Dashboard development

Job description

Duration: Long Term

Only Consultant working with NYC DSS/HRA

• Develops and prepares documents for the general design of solutions that meet system and security requirements, including the selection of alternative approaches.


• Develops specifications for databases, security, and software configurations.


• Develops structured diagrams for data and logical models.


• Develop system documentation


• Develops business-friendly descriptions for database elements and explanations of the use of the elements in the legacy systems.


• Confer with staff and users to identify and document system requirements.


• Read documents belong to sources used in data warehouse and create change request.


• Perform System Design/Development


• Work with staff (e.g, managers, senior programmers, support staff, product manager) to plan program implementation, enhancements and changes


• Test programing scripts and test and analyze resulting data.


• Design reports, screen layouts, and user instructions to support the requirements of the business.


• Architect, analyze, design, develop, administer, deploy all layers of RPD.


• Provide assistance to technical support staff in the resolution of usability and business-related issues.


• Frequently contact customers and legacy system developers as required to clarify the intent of a new feature or to resolve a problem


• Perform Testing/Evaluation


• Tests programs and systems.


• Test system changes during release.


• Assist in quality assurance and defining testing strategy and risks.

Role: Senior Oracle Programmer

Location: Brooklyn, NY

Duration: Long Term

Only Consultant working with NYC DSS/HRA

Responsibilities

• Develop system design specifications


• Develops and prepares documents for the general design of solutions that meet system and security requirements, including the selection of alternative approaches.


• Develops specifications for databases, security, and software configurations.


• Develops structured diagrams for data and logical models.


• Develop system documentation


• Develops business-friendly descriptions for database elements and explanations of the use of the elements in the legacy systems.


• Confer with staff and users to identify and document system requirements.


• Read documents belong to sources used in data warehouse and create change request.


• Perform System Design/Development


• Work with staff (e.g, managers, senior programmers, support staff, product manager) to plan program implementation, enhancements and changes


• Test programing scripts and test and analyze resulting data.


• Design reports, screen layouts, and user instructions to support the requirements of the business.


• Architect, analyze, design, develop, administer, deploy all layers of RPD.


• Provide assistance to technical support staff in the resolution of usability and business-related issues.


• Frequently contact customers and legacy system developers as required to clarify the intent of a new feature or to resolve a problem


• Perform Testing/Evaluation


• Tests programs and systems.


• Test system changes during release.


• Assist in quality assurance and defining testing strategy and risks.

Required Skills

A minimum of 4 years of experience with the following skill sets:

• Developing test plans and analyzing and testing large volumes of data


• Using business knowledge to guide a technical team.


• Experience with the NYS Welfare Management System and/or NYS Medicaid Claims Processing System and/or NYCWAY in a technical/analytical capacity


• Excellent analytical and testing skills and the ability to communicate complex technical concepts in clear, non- technical oral and written English


• Leading the design of program specifications and the implementation of software solutions, requirement analysis, design, snowflake data modeling, interactive Dashboard design and complex ad hoc queries and report.


• the OBIEE Analysis, Agent and Dashboards, including RPD Design and Deployment, Catalog Management and security.


• Working in a large three tier data warehouse environment


• Design and extension of data marts, metadata, and data models. Participate in the intake of data from both internal and outside sources.


• Expert knowledge of OBIEE 12c, Oracle Portal, Report server and development.