Oracle Data Integrator Cloud Service (ODI-CS) Developer

Job Title: Oracle Data Integrator Cloud Service (ODI-CS) Developer

Location: Remote

Duration: 12+ Months

Interview Mode: Video

Responsibilities:

Oracle Data Integrator Cloud Service (ODI-CS)

Key Responsibilities:

An ODI-CS developer is responsible for designing and implementing high-performance data integration solutions specifically within the Oracle Cloud Infrastructure (OCI). Designs, develops, and optimizes ETL/ELT processes to migrate and transform data between systems using ODI 11g/12c.

ETL Development: Design, develop, test, and deploy ODI interfaces, packages, procedures, and load plans to handle full and incremental data loads.

Data Transformation: Perform complex data transformations, cleansing, and validation using ODI Knowledge Modules.

Performance Optimization: Optimize execution time for data loads by tuning SQL, managing indexes, and refining transformation logic.

Environment Management: Configure ODI Topology, including Data Servers, Physical/Logical Schemas, and Agents.

Collaboration: Work with data architects, business analysts, and DBAs to define requirements and ensure data quality.

Maintenance: Monitor production jobs, troubleshoot data integration errors, and maintain technical documentation.

Required Skills & Qualifications:

Technical Expertise: Strong experience with ODI 12c/11g, Oracle Database, SQL, and PL/SQL.

Experience: 10–12 years of experience in data warehousing and ETL development. BI Applications (OBIEE/OAC). ODI-Cloud Services