Oracle Cloud ERP Data Migration Engineer (ETL/PLSQL)

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

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