Oracle ODI Specialist

About us

The 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 our systems and platforms across state and local government as well as streamlining our corporate and procurement services.

About the role

This role is responsible technical development requiring a combination of technical, analytical, strategic thinking, problem-solving and collaborative skills to deliver robust, scalable solutions using Oracle platform. You will be supporting to design, development, and managing enterprise-level solutions, lead data integrations between applications such as SAP SuccessFactors, Oracle EPM, and Oracle ERP. This role also involves extensive work in data modelling, data management, and data integrations for enterprise reporting using Oracle Analytics cloud.

Key accountabilities include:

• Leverage knowledge of ODI architectures and components (Repositories, Agents, Designer) and ODI Studio for mappings, packages and load plans, for enterprise-grade solutions.
• Writing and Debugging ETL functions using programming languages like Java, JavaScript, PL/SQL or Python, and manage database connectivity with Oracle JDBC
• Design and develop robust ETL/ELT pipelines using Oracle Data Integrator (ODI), Oracle Integration Cloud (OIC), and related tools to integrate data from cloud applications and on-premises databases.
• Implement best practices for data warehousing and business intelligence systems. Design and develop comprehensive analytics dashboards and reports using Oracle Analytics Cloud (OACS).

About you

To be considered for the role, you must be able to demonstrate:

• Interpersonal, Negotiation and Leadership Skills: Proven ability to lead and collaborate effectively with diverse stakeholders, fostering strong working relationships across technical and business teams.
• Analytical Thinking and Initiative: Strong problem-solving skills with a proactive approach to identifying and resolving technical issues. Committed to continuous improvement and staying current with Oracle Cloud technologies.
• Technical Expertise in Oracle Cloud Technologies: Extensive experience with Oracle ODI, OIC, OCI, APEX, and OACS, and proficiency in PL/SQL, JavaScript, and Python for data integration and transformation.
• Project Delivery and Documentation: Demonstrated success in delivering data integration projects and maintaining clear, structured documentation aligned with project objectives.
• Support Operations and Incident Management: Experienced in managing ODI support operations, resolving incidents, and implementing preventative measures to ensure system reliability and performance.
• Technical Documentation and Knowledge Sharing: Skilled in maintaining accurate technical documentation and diagrams, with a focus on knowledge sharing and continuous team improvement.

Mandatory Requirements

• 8+ years of experience working as Oracle integration cloud (OIC), Oracle Data Integrator (ODI), Oracle Analytics Cloud (OACS) preferably having Oracle Certified Associate (OCA) or Oracle Certified Professional (OCP) certifications.
• Proven expertise in integrating ERP systems (e.g., Oracle ERP, SAP, Salesforce). Knowledge of Oracle ERP APIs and business process would be preferable.
• Knowledge of Oracle Cloud Infrastructure (OCI), Implementation of CI/CD pipelines using tools such as Jenkins, Git, and Docker for streamlined deployments and monitoring would be preferable. Strong SQL and PL/SQL programming skills. Knowledge of scripting languages such as Python, Bash.

For specific responsibilities please review the attached position description.

This position is only open to applicants with relevant rights to work in Australia.

How to apply

Apply before the advertised closing date 11:59pm on Monday, 22 September 2025. All applications should include:

• a resume; and
• a cover letter which addresses the key selection criteria (within three pages)

Other relevant information

The department is committed to providing and maintaining a working environment which is safe and without risk to the health of its employees and clients and consistent with the department's obligations under the Occupational Health and Safety Act 2004 (OH&S Act), to support this DGS has a COVID-19 Vaccination policy which strongly recommends all DGS employees be fully vaccinated.

Preferred candidates will be required to complete a Pre-employment Declaration and Consent Form. Employment of successful candidates will be subject to a National Police Check.

DGS actively promotes diversity, inclusion and an equal opportunity workplace. We welcome applicants from all diverse backgrounds, including people with disabilities and Aboriginal and Torres Strait Islander peoples. All roles at DGS can be worked flexibly, however it may differ from role to role.