Skip to main content

This job has expired

Oracle ODI and Analytics Developer

Employer
Intelligent Resource
Location
Homeworking
Salary
market rate
Closing date
11 Feb 2021

View more

Clearance Level
DV, SC, None / Undisclosed
Sector
Defence, Information Technology
Job Type
Contract

Oracle ODI and Analytics Developer

Ref: 4187

Duration: 3 months

Location: Remote / Hemel Hempstead

EXCLUSIVE OPPORTUNITY: Sopra Steria is currently recruiting for an Oracle ODI and Analytics Developer to design and develop the ELT and Data Integration routines using Oracle Data Integrator (ODI), on an initial three (3) month contract.

The post holder will work through Intelligent Resource for Sopra Steria, a European leader in digital transformation, providing one of the most comprehensive portfolios of end-to-end service offerings on the market: consulting, systems integration, software development, infrastructure management and business process services.

On client's instructions, due to the urgency, nature and length of the assignment, the successful candidate must have current security clearance to a high level.

Role Overview

Reporting directly to the Delivery Manager, the Oracle ODI & Analytics Developer is responsible for ensuring the successful completion of design, construction, unit test, code review & bug fixing of the allocated work package within the agreed time, quality and cost.

The Oracle ODI & Analytics Developer will maintain the status of development activities pertaining to allocated work package. In addition, Oracle ODI & Analytics Developer will work closely with the business consultants, developers, designers & business/system leg testers, ensuring timely communication of dependencies, risks & issues relating to allocated work package, dependant work packages & upcoming stages.

Key Responsibilities

  • Act as a Subject Matter expert for design and development of ELT and Data Integration routines using Oracle Data Integrator (ODI).
  • Develop data strategies to successfully oversee data flow from ingestion to repository storage and then ultimately to dashboards, interfaces, tools, and other stakeholder databases.
  • Manage and administer Extract, Transform, and Load (ETL)/ EL-T processes to ingest various data sources into a centralized data lake using Oracle Data Integrator (ODI 12c), SQL and PL/SQL
  • Design and develop or modify ELT Load Plans that load data using Oracle ODI 12c and PL/SQL
  • Develop ETL processes - ETL control tables, error logging, auditing and data quality.
  • Implement reusability, parameterization and workflow design
  • Ability to design data quality and reconciliation framework using ODI
  • ODI performance tuning
  • Schedule and monitor the ODI Interface execution using load plans
  • Customizing Knowledge Modules (KM) using ODI
  • Setting up ODI Master and work repository, topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
  • Design and develop complex mappings, Process Flows and ETL scripts
  • Design ETL unit test cases and debug ETL Mappings
  • Error recycling / management using ODI,PL/SQL
  • Integrating Restful API's and messages
  • Develop Reports and Dashboards using Oracle Analytics
  • Integrate of ODI objects in Version management tools
  • Participate in low level application design workshops
  • Preparation of design specifications (DS) based on the first draft of the functional specifications (FS); Submit review comments on FS, DS.
  • Construct code based on the Functional requirements specification (FRS), FS, DS;
  • Perform peer group unit test & code reviews.
  • Perform defect analysis and bug fixing duly maintaining defect evolution.
  • Co-ordinate with peer developers and the release manager during release build activities.
  • Identify, document and monitor issues & risks and advise the impact of the same
  • Adhere to quality processes

Essential Skills

  • Oracle Data Integrator 12c
  • Oracle 12c Database
  • Oracle WebLogic Server 12c
  • SQL, PL/SQL
  • Oracle Analytics Server 5.5 or Oracle Analytics Cloud
  • Serena Dimensions or any equivalent tool

Desirable Skills

  • Core Java 8 +
  • XML

Intelligent Resource is a wholly owned subsidiary of Sanderson Solutions Group Plc, an experienced and well established recruitment partner with a family of recruitment companies.

Intelligent Resource is committed to barrier-free and inclusive recruitment. We are a Disability Confident recruiter, and a RIDI 100 and Business Disability Forum partner organisation.

Should you choose to contact Intelligent Resource regarding this role or apply for it, all personal data you submit to us will be processed in accordance with our Privacy Notice which you can find on our website.

Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert