Oracle Data Integrator Cloud Service
Newark, DE - USA
Job Summary
Oracle Data Integrator Cloud Service (ODI CS)
Location : Newark NJ
Hire Type: Contract
Location : Newark NJ
Hire Type: Contract
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
Handle full and incremental data loads
Data Transformation:
Perform complex data transformations cleansing and validation
Use ODI Knowledge Modules
Performance Optimization:
Optimize execution time for data loads
Tune SQL manage indexes refine transformation logic
Environment Management:
Configure ODI Topology
Manage Data Servers Physical/Logical Schemas and Agents
Collaboration:
Work with data architects business analysts and DBAs
Define requirements and ensure data quality
Maintenance:
Monitor production jobs
Troubleshoot data integration errors
Maintain technical documentation
Required Skills & Qualifications:
Technical Expertise:
Strong experience with ODI 12c/11g Oracle Database SQL and PL/SQL
Experience:
3 10 years in data warehousing and ETL development
Experience with Oracle Cloud Infrastructure (OCI) Data Integration or BI Applications (OBIEE/OAC)
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
Handle full and incremental data loads
Data Transformation:
Perform complex data transformations cleansing and validation
Use ODI Knowledge Modules
Performance Optimization:
Optimize execution time for data loads
Tune SQL manage indexes refine transformation logic
Environment Management:
Configure ODI Topology
Manage Data Servers Physical/Logical Schemas and Agents
Collaboration:
Work with data architects business analysts and DBAs
Define requirements and ensure data quality
Maintenance:
Monitor production jobs
Troubleshoot data integration errors
Maintain technical documentation
Required Skills & Qualifications:
Technical Expertise:
Strong experience with ODI 12c/11g Oracle Database SQL and PL/SQL
Experience:
3 10 years in data warehousing and ETL development
Experience with Oracle Cloud Infrastructure (OCI) Data Integration or BI Applications (OBIEE/OAC)