Oracle Data Integrator

1 week ago

Melbourne, Victoria, Australia Resource Corner Full time $90,000 - $120,000 per year

We are seeking an experienced "ODI 12c Developer/Consultant" to design, develop, and implement data integration solutions using Oracle Data Integrator 12c. The ideal candidate will have a strong background in ETL processes, data warehousing, and ODI 12c tools. The role involves working closely with business analysts, data architects, and other stakeholders to deliver high-quality data integration solutions.

Required Skills:

  1. Technical Skills:

o     Strong experience with Oracle Data Integrator 12c (ODI 12c).

o      Having hands-on experience in developing ETL end-to-end processes using ODI 12c

o     Good knowledge of ODI Architecture like ODI Studio's components – Designer, Topology, Security, Operator

o     Having strong knowledge about ODI repositories (Master and Work Repository)

o    Good understanding of various knowledge modules in ODI 12c

o      Proficiency in SQL, PL/SQL, and database concepts (Oracle, SQL Server, etc.).

o     Experience with ETL tools and data integration techniques.

o     Knowledge of data warehousing concepts and methodologies.

o     Experience with Oracle Fusion Middleware and Oracle BI tools is an advantage.

  1. Soft Skills:

o     Strong analytical and problem-solving skills.

o     Excellent communication and collaboration skills.

o     Ability to work independently and as part of a team.

Key Responsibilities:

  1. Design and Development:

o      Design and develop ETL processes using Oracle Data Integrator 12c.

o      Create and optimize mappings, packages, procedures, and Load plans in ODI 12c.

o      Implement data integration solutions for large-scale data warehouses and data marts.

  1. Data Integration:

o      Integrate data from multiple sources (databases, flat files, APIs, etc.) using ODI 12c.

o      Work with heterogeneous systems and ensure seamless data flow across platforms.

  1. Performance Tuning:

o      Optimize ODI 12c mappings, interfaces, and Load plans for performance and scalability.

o      Troubleshoot and resolve performance bottlenecks in ETL processes.

  1. Collaboration:

o     Collaborate with data architects, business analysts, and other stakeholders to understand data integration requirements.

o     Work with database administrators (DBAs) to ensure optimal database performance and storage.

  1. Testing and Deployment:

o     Perform unit testing, integration testing, and support user acceptance testing (UAT).

o      Deploy ODI 12c solutions to production environments and provide post-deployment support.

  1. Documentation:

o     Create technical documentation for ODI 12c mappings, workflows, and processes.

o     Maintain documentation for data integration standards and best practices.

  1. Support and Maintenance:

o     Provide ongoing support for ODI 12c applications and resolve production issues.

Monitor and maintain data integration processes to ensure data accuracy and consistency.

  • Oracle ODI Specialist

    4 weeks ago

    Melbourne, Victoria, Australia ClearCompany Full time

    About usThe Department of Government Services (DGS) wasestablishedon 1 January 2023 to improve everyone's experience of doing business and interacting with the Victorian government.We bring important day-to-day services together in one department to make things easy and seamless for Victorians and businesses.We are doing this by connecting and digitising our...

  • Oracle ODI Specialist

    4 weeks ago

    Melbourne, Victoria, Australia ClearCompany Full time

    About usThe Department of Government Services (DGS) wasestablishedon 1 January 2023 to improve everyone's experience of doing business and interacting with the Victorian government.We bring important day-to-day services together in one department to make things easy and seamless for Victorians and businesses.We are doing this by connecting and digitising our...

  • Oracle ODI Specialist

    2 weeks ago

    Melbourne, Victoria, Australia Victorian Government Full time $162,077 - $185,518 per year

    OverviewWork Type: Ongoing - Full-timeSalary: $162,077 - $185,518Grade: VPS 6.2Occupation: IT and telecommunicationsLocation: Melbourne - CBD and Inner Metro suburbsReference: VG/1882630About usThe Department of Government Services (DGS) was established on 1 January 2023 to improve everyone's experience of doing business and interacting with the Victorian...

  • Oracle ODI Specialist

    1 week ago

    Melbourne City Centre, Victoria, Australia Department of Government Services Full time $120,000 - $180,000 per year

    About usThe Department of Government Services (DGS) was established on 1 January 2023 to improve everyone's experience of doing business and interacting with the Victorian government. We bring important day-to-day services together in one department to make things easy and seamless for Victorians and businesses. We are doing this by connecting and digitising...

  • Consulting Program Manager

    1 week ago

    Melbourne, Victoria, Australia Oracle Full time $80,000 - $140,000 per year

    Job DescriptionThis is an expression of Interest of an upcoming role of a Consulting Program Manager.As this role supports State and Federal Government, Australian Citizenship and eligibility for a security clearance are required.About Oracle ConsultingOracle Consulting helps clients unlock the full value of Oracle Cloud. With more than 7,000 experts across...

  • Consultant, Oracle

    4 weeks ago

    Melbourne, Victoria, Australia Environmental Resources Management (ERM) Full time

    Consultant, Oracle page is loaded## Consultant, Oraclelocations: Adelaide, Australia: Melbourne, Australiatime type: Full timeposted on: Posted Todayjob requisition id: R00027704**About ERM & Our Team**ERM is the world's largest pure-play sustainability consultancy, with over 8,000 professionals in more than 40 countries. Recognized globally as a...

  • Oracle EPM Manager

    4 weeks ago

    Melbourne, Victoria, Australia ClearCompany Full time

    OverviewWe have been engaged by an established organisation based in Melbourne to assist in securing an Oracle EPM Cloud Manager to join them on a permanent basis.As part of our clients Oracle Cloud ERP team, you will play a key role in end to end project delivery lifecycle from initiation, to go-live, warranty, and support across multiple clients from a...

  • Oracle EPM Manager

    4 weeks ago

    Melbourne, Victoria, Australia ClearCompany Full time

    OverviewWe have been engaged by an established organisation based in Melbourne to assist in securing an Oracle EPM Cloud Manager to join them on a permanent basis.As part of our clients Oracle Cloud ERP team, you will play a key role in end to end project delivery lifecycle from initiation, to go-live, warranty, and support across multiple clients from a...

  • Oracle EPM Manager

    6 days ago

    Melbourne, Victoria, Australia HCM Australia Full time $120,000 - $180,000 per year

    We have been engaged by a established organisation based in Melbourne to assist in securing an Oracle EPM Cloud Manager to join them on a permanent basis.  As part of our clients Oracle Cloud ERP team, you will play a key role in end to end project delivery lifecycle from initiation, to go-live, warranty, and support across multiple clients from a wide...

  • Account Manager

    1 week ago

    Melbourne, Victoria, Australia Oracle Full time $150,000 - $200,000 per year

    Job DescriptionLooking for Account Manager (Java Enterprise Solutions) based in Australia. The Java SE Enterprise JAPAC business is responsible for developing net new business which is almost untapped market of Oracle Java. Our focus is to sell Java SE subscription to the CIO of Enterprises (End Users & ISVs), the Leader of IT-Infrastructure, IT-Security,...