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