IT Specialist (Oracle, ODI, SSIS, MQ Series, SOA, SQL, Web Services, XML, XSLT, MS Visio, LoadRunner, Subversion (SVN), MS SQL Server)

MVP Consulting

Albany, NY

JOB DETAILS
SKILLS
Analysis Skills, Booking Arrests, Business Solutions, Computer Programming, Consulting, Criminal Justice, Data Management, Database Design, Database Extract Transform and Load (ETL), Enterprise Data Integration, Failover, High Tech Industry, IBM WebSphere MQ (Message Queue), Information Technology & Information Systems, LoadRunner, MSXML (Microsoft XML) XSLT Processor, Microsoft SQL Server, Microsoft Visio, Oracle, Oracle Data Integrator, Oracle Database, People Management, Performance Testing, Problem Solving Skills, Requirements Management, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Service-Oriented Architecture (fka Distributed Object Architecture), Software Design, Subversion, Team Lead/Manager, Team Player, Technical Leadership, Technical Writing, Web Services, XML (EXtensible Markup Language)
LOCATION
Albany, NY
POSTED
4 days ago
HBITS: HBITS-08-14852

NYS ITS - Senior, IT Specialist

30 month contract

Interview: Virtual Interview

Work model: Not specified

--- Project Description ---
The candidate will be responsible for designing, developing,
implementing, and supporting enterprise data integration
solutions using Oracle Data Integrator (ODI) to meet business
and operational needs.

--- Day-to-Day Tasks ---
1. Manages ETL solutions for data warehouse projects.
2. Perform ETL application analysis, design, development and
implementation, including: data analysis, data access, data
structures, data manipulation, data reporting solutions,
database, and technical and user documentation.
3. Act as the primary ETL technical liaison working with technical
infrastructure teams to resolve problems and implement
solutions to technical issues impacting application
performance.
4. Work with the Infrastructure team to execute activities such as
performance test planning and execution failure failover
planning and execution, endurance testing and deployment
planning and testing.
5. Perform oversight of development activities which may
include data analysis, data access, data structures, data
manipulation, preparing logical database models, testing and
implementation.
6. Prepare, and/or review technical documentation such as
designs, schemas, etc., as appropriate.
7. Provide technical guidance to team of developers.

IT Specialist
Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Senior60 - 84 Months: Candidate is able to work independently, without assistance and provides guidance to others.  May have an advanced education.

--- Required Qualifications ---
• 72 months experience developing ETL/E-LT objects including
Mapping, Packages, Scenarios and Procedures using Oracle Data
Integrator.
• 72 months experience writing technical specifications including
ETL source to target mapping documents, use cases, software
architecture documents, ETL design documents and
implementation documents.
• 72 months experience in writing and tuning SQL scripts including:
tables, views, indexes, and complex PL/SQL objects including:
procedures, functions, triggers, and packages in Oracle database
12c or higher.
• 72 months experience working with Oracle Data Integrator 12c or
later.
• 60 months experience as a technical team lead responsible for
data warehouse and ETL platform architecture.
• 24 months experience developing, implementing, and integrating
systems related to Criminal Justice processing at the state or
federal level using Criminal Justice terminology and
nomenclatures.

MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.

About the Company

M

MVP Consulting