What are the responsibilities and job description for the Oracle ODI/ETL Developer position at V Group Inc.?
Direct End Client: Information Technology Services (ITS)
Job Title: IT Specialist
Duration: 30 Months
Location: Albany, NY
Hours Per Week: 40
Interview Type: Webcasting
Ceipal ID: SNY_ORAC852_PT
Job Code: HBITS-08-14852
Scope of Project:
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.
Responsibilities:
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.
Required/Preferred Skills:
- 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.