IT Specialist PL/SQL Oracle 11G ETL Oracle Warehouse ODI Criminal Justice processing XML

Profile

HBITS-03-11989
Provide a list of the day to day tasks to be performed by the Selected Candidate: This individual will be expected to provide expertise and participate in the following activities: Manages ETL solutions for medium to large scale data warehouse projects.
IT experience in 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 leadership 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.
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 experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects including: procedures, functions, triggers, and packages
84 months experience working with Oracle 11G or later.
84 months experience writing technical specifications including ETL source to target mapping documents
84 months experience developing ETL/E-LT objects including Interfaces, Packages, Scenarios and Procedures and load strategies for relational, Type 1, 2, and 3 slowly changing dimensions using Oracle Data Integrator.
48 months experience as a technical team lead responsible for data warehouse ETL components architecture.
48 months experience using Oracle Data Integrator or Oracle Warehouse Builder to migrate data from various sources and targets including databases, flat files, and XML files.
36 months experience developing, implementing and integrating systems related to Criminal Justice processing at the state or federal level using Criminal Justice terminology and nomenclatures.
****
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 - PoliceCrossing.com