ODI Developer

CSV, Excel,XML,Oracle RDBMS,Java EE,ODI data services,ODI Console,ODI studio
Contract W2
Depends On Experience
Telecommuting not available Travel not required

Job Description

Title: ODI Developer
Location: Malden, MA
Duration: Contract

Job Description:

  • Client has several new initiatives underway and as a need to ensure that the systems are fully integrated and adhering to data standards.
  • Client is seeking an experienced Oracle Data Integration (ODI) person who will be responsible for reviewing, designing, developing, and implementing our data integration efforts for current data warehouse and planned enhancements.
  • The candidate must have experience in data integration in a data warehouse environment including integration of data from disparate systems and proprietary formats.
    Under general supervision, the Data Integration person shall provide strategic level technical leadership for the integration effort and must be able to perform hands on analysis and implementation.
  • Must also clearly understand the business objectives and be able to communicate issues to the business and technical stakeholders verbally and in writing.
  • Must also be able to understand the different standards in the Education domain CEDS, SIF, IMS GLC, PESC, State Core model and provide guidance to technical staff, project managers and insure vendors adhere to the standards.
  • The role also requires development and implementation of realistic integration plans.

Roles & Responsibilities:

  • Create short-term tactical solutions to achieve long-term objectives and an overall data management roadmap.
  • Assist with assessing and determining governance, stewardship, and frameworks for managing data across the organization.
  • Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement.
  • Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks.
  • Develop and deliver long-term strategic goals for data integration standards in conjunction with data users, department managers, clients, and other key stakeholders.

Operational Management

  • Develop integration process data flows and data mapping analyses.
  • Address data-related problems in regards to systems integration, compatibility, and multiple-platform integration.
  • Develop and promote data integration methodologies and standards.
  • Act as an advocate of data integration and management, including coaching, training, and career development to staff.
  • Develop and implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of data architecture.
  • Identify and develop opportunities for data reuse, migration, or retirement of systems.

Required Experience:

  • Minimum of 4 years Oracle ODI experience.
  • 8+ years overall experience in Data Integration, Data Architecture, Data Modeling, and implementation.
  • Minimum of 5 years of full lifecycle data warehousing experience
  • Experience with Set up, configuring and administration of ODI according to requirements.
  • Experience in Master Data Management and Meta Data Management.
  • Experience in Dimensional Modeling.

Required Skills:

  • Implementation of ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including, Relational Database Management servers (including Oracle RDBMS, flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security).
  • BI knowledge a requirement – 5 years in BI from ETL perspective.
  • Design experience of the detailed ETL architecture, including agents, scenarios, packages, data mapping, data extractions, transformations and validations.
  • This ETL design and implementation should include stand-alone and Java EE agents, ODI data services, ODI Console, ODI studio, and other appropriate development tools.
  • Ability to observe steps and ascertain success of step or failure and root cause of step(s).
  • Demonstrated ability to communicate the overall customer data architecture to both technical and business constituencies.
  • Creating Interfaces in order to move data from source to target.
  • Assist infrastructure personnel in implementing the ODI migration process to migrate the ODI configuration through various development, test, and production environments.
  • Develop system /integration test plans and scenarios for data loads and extracts.
  • Manage and monitor production and non-production ETL sessions.
  • Mentor and transfer ODI technical knowledge and processes to other team and department personnel, as requested.

Preferred Skills:

  • Good knowledge of applicable data privacy practices and laws (FERPA).
  • Experience in an education environment a plus.
  • Experience with Oracle Exadata is a plus.
Dice Id : 90739239
Position Id : 755049
Have a Job? Post it

Similar Positions

Image Support/ Deployment
  • HCL America Inc.
  • Burlington, MA
Desktop Engineer (superior skills, looking to move up!)
  • Advancement Alternatives
  • Lexington, MA
Executive IT Support Specialist
  • Computer Doc Associates, Inc
  • Cambridge, MA
Executive Desktop Support
  • Experis
  • Waltham, MA
Web & Mobile Architect
  • MMD Services, Inc
  • Addison, IL
Desktop Support Engineer
  • IRIS Software, Inc.
  • Boston, MA
Desktop Deployment Specialist
  • JVT Advisors
  • Marlborough, MA
Desktop Support with MDM
  • AMS Staffing Inc.
  • Wilmington, MA
A/V Engineer
  • Alexander Technology Group
  • Boston, MA
E3 Visa Sponsorship / Transfer - SolutionIT
  • SolutionIT, Inc.
  • Boston, MA