Oracle Data Integration

Pyramid Global Technologies

Austin (TX)

On-site

AUD 120,000 - 180,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Pyramid Global Technologies in Victoria, Australia is seeking an experienced ETL/ODI specialist with 8+ years of hands-on data warehousing experience. You will design, develop and optimize ODI mappings, packages and KMs, and ensure reliable ETL workflows across diverse source systems including flat files, Excel, XML/JSON, and Oracle/SQL Server databases.

The ideal candidate will lead end-to-end DWH implementations, set up topology, repositories, load plans, and perform performance tuning and

Qualifications

  • 8+ years of ETL/ELT experience.
  • Strong ODI development experience and KM customization.
  • Experience with PL/SQL and data modelling for ETL.
  • Hands-on end-to-end DWH work using ODI as ETL tool.
  • Knowledge of ODI Master and Work repositories and OWB.

Skills

ETL/ELT concepts
ETL unit test design
PL/SQL
Data modelling
ODI as ETL tool
ODI Master/Work repositories
ODI mappings and KM
Topology and Model layer
Load plans & scheduling
Performance tuning ODI mappings
Exception handling in ODI
Source system integration

Tools

ODI
OWB
Oracle Database
SQL Server

Job description

8+ years experience

  • Strong knowledge of ETL/ELT concepts
  • Ability to design ETL unit test cases and debug ETL mappings
  • Knowledge of PL/SQL
  • Knowledge of data modelling and ETL design
  • Hands-on with end to end DWH implementation experience using ODI as ETL tool
  • Knowledge of ODI Master and Work repositories.
  • Knowledge of OWB
  • Design and develop complex ODI mappings, packages, procedures etc.
  • Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
  • Setting up of topology and Model layer
  • Building objects in Designer and monitoring Operator
  • Experience of developing load plans and scheduling jobs.
  • Experience of performance tuning of ODI mappings
  • Ability to perform exception handling in ODI
  • Exposure of working with various source systems such as flat files, excel, XMLs, JSON, Oracle database, SQL server database etc
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Oracle Data Integrator Technical Lead
Oracle Data Integrator Technical Lead

Tata Consultancy Services Limited • Mentor (OH)

On-site
USD 120,000 - 140,000
Discretionary Incentive
Medical Coverage
401K Plan
+2
Oracle PL/SQL Developer
Oracle PL/SQL Developer

Jobsbridge • Fairfield (CA)

On-site
USD 90,000 - 120,000
Lead Data Warehouse & ETL Architect (Oracle/ODI)
Lead Data Warehouse & ETL Architect (Oracle/ODI)

JSM Consulting Inc. • City of Albany (NY)

On-site
USD 90,000 - 130,000
ODI Developer
ODI Developer

Cambay • Chicago (IL)

On-site
USD 90,000 - 115,000
Data Architect
Data Architect

Virtusa Corporation • Texarkana (TX)

On-site
USD 120,000 - 180,000
Oracle EPM Consultant
Oracle EPM Consultant

Softclouds • San Diego (CA)

On-site
USD 120,000 - 180,000
Senior Oracle Developer
Senior Oracle Developer

Motion Recruitment • Irving (TX)

On-site
USD 100,000 - 130,000
ODI Developer: Senior ETL & Data Warehouse Expert
ODI Developer: Senior ETL & Data Warehouse Expert

Cambay • Chicago (IL)

On-site
USD 90,000 - 115,000
Oracle BI Developer
Oracle BI Developer

Next Level Business Services, Inc. • Goleta (CA)

On-site
USD 120,000 - 180,000
ODI Developer
ODI Developer

Spruce Infotech • Austin (TX)

On-site
USD 90,000 - 120,000