Data Engineer - Oracle

Kinetic; City of Melbourne; On-site; AUD 90,000 - 120,000; Full time

Benefits offered by this job

Collaborative team environment

Opportunities on Oracle Cloud ERP projects

Focus on safety and continuous improvement

Job summary

Kinetic is seeking a data migration expert for a 12-month contract in Melbourne. You will manage data transfers into Oracle Cloud ERP while ensuring integrity and performance. Collaborate with business analysts to tackle complex data challenges and produce technical documentation to support the transition.

The ideal candidate has over 5 years of experience in data migration, strong Oracle PL/SQL skills, and an understanding of Oracle finance and procurement data sets. Join us to work on cutting-edge projects in a supportive team.

Qualifications

• 5+ years’ experience in data migration, particularly with Oracle databases and ERP environments.
• Advanced Oracle PL/SQL skills and strong ETL process knowledge.
• Familiarity with Oracle Finance and Procurement data sets.

Responsibilities

• Design, develop, and test PL/SQL routines for ETL processes.
• Analyse source and target data models, perform data mapping.
• Validate and reconcile data between source and target systems.

Skills

Data migration

Oracle PL/SQL

ETL process

Analytical skills

Problem-solving

Tools

Oracle Cloud ERP

Oracle Autonomous Database

FBDI templates

Job description

The role

Are you passionate about data integrity and seamless system transitions? In this role, you’ll play a critical part in migrating data into Oracle Cloud ERP, ensuring accuracy, security, and performance every step of the way. You’ll work with cutting‑edge tools like PL/SQL, Oracle Autonomous Database, and FBDI templates to extract, transform, and load data efficiently.

You’ll collaborate closely with business analysts and stakeholders, tackle complex data challenges, and help deliver a smooth migration that supports our business transformation. If you thrive on problem‑solving and precision, this is your opportunity to make a real impact.

This is a 12‑month contract, with potential to extend.

What you’ll do

• Design, develop, and test PL/SQL routines for ETL processes to move data efficiently and securely.
• Analyse source and target data models, perform data mapping, and resolve data quality issues through cleansing and enrichment.
• Validate and reconcile data between source and target systems.
• Collaborate with business analysts, developers, and stakeholders to define requirements and resolve data challenges.
• Support SIT and UAT phases, ensuring data integrity checks are completed.
• Create technical documentation, data flow diagrams, and migration reports.
• Participate in team meetings and workshops to drive successful outcomes.

What You’ll Bring

• 5+ years’ experience in data migration, particularly with Oracle databases and ERP environments.
• Advanced Oracle PL/SQL skills and strong ETL process knowledge.
• Familiarity with Oracle Finance and Procurement data sets.
• Experience with Oracle FBDI templates.
• Strong analytical and problem‑solving skills with attention to detail.

Why Join Us?

At Kinetic, we’re committed to improving the livelihoods of the communities we serve. We offer:

• A collaborative and supportive team environment.
• Opportunities to work on cutting‑edge Oracle Cloud ERP projects.
• A culture that prioritises safety, wellbeing, and continuous improvement.