HBITS 08-14852 IT Specialist - Senior

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

This individual will be expected to participate in the following activities:

• Manages ETL solutions for data warehouse projects.
• 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.
• Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
• 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.
• Perform oversight of development activities which may include data analysis, data access, data structures, data manipulation, preparing logical database models, testing and implementation.
• Prepare, and/or review technical documentation such as designs, schemas, etc., as appropriate.
• 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.

Senior

60 - 84 Months: Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.

Requested 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.