ODI Admin, Developer

Job highlights

• Minimum 6 years of experience in ELT development for Data Warehouses using Oracle Data Integrator,preferably ODI 12c. .

• Minimum 6 years of experience in ELT development for Data Warehouses using Oracle Data Integrator, preferably ODI 12c.

Responsibilities:

• Design, develop, test and deploy ODI mappings/scenarios in production and non-production environments.

• Develop and maintain up-to-date versions of ODI packages, mappings, procedures, variables, sequences, and load plans.

• Extract and integrate data from heterogeneous data sources like relational databases (eg Oracle, PostgreSQL), flat files (including JSON format) and API endpoints.

• Build reusable mappings and/or customize Knowledge Modules to improve development efficiency.

• Implement incremental (CDC) and full-load strategies as per data source characteristics.

• Build data validation, exception handling and error recycling mechanisms in ODI mappings.

• Optimize ODI mappings for large volume data processing.

• Perform root cause analysis of mapping failures and data discrepancies during development, SIT and UAT.

• Support deployment of ODI scenarios to testing and production environments.

• Ensure adherence to coding standards and reconciliation of source-to-target mapping

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.