Data Engineer - Oracle

Kinetic; Mackay Regional; On-site; AUD 100,000 - 170,000; Full time

Benefits offered by this job

Collaborative environment

Cutting-edge Oracle Cloud ERP projects

Wellbeing and safety culture

Job summary

Kinetic is seeking an experienced data migration specialist to support an Oracle Cloud ERP transition. You will design, develop, and test PL/SQL routines for ETL, perform data mapping, and ensure data integrity across source and target systems.

You will collaborate with business analysts and stakeholders to resolve data challenges and deliver a smooth migration. This is a 12-month contract with potential to extend, offering exposure to Oracle Autonomous Database and FBDI templates, and a chance

Qualifications

• 5+ years in data migration with Oracle databases
• Advanced PL/SQL and ETL process knowledge
• Familiarity with Oracle Finance and Procurement data sets is a plus
• Experience with Oracle FBDI templates
• Strong analytical and problem-solving skills with attention to detail

Responsibilities

• Design, develop, and test PL/SQL routines for ETL processes.
• Analyse source and target data models, perform data mapping, and resolve data quality issues.
• Validate and reconcile data between source and target systems.
• Collaborate with business analysts, developers, and stakeholders to define requirements.
• 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.

Skills

Oracle PL/SQL

ETL processes

Data migration

Data mapping

Data integrity

Tools

Oracle FBDI templates

Oracle Autonomous Database

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.