Search by job, company or skills

C

Oracle ODI Developer

4-8 Years
new job description bg glownew job description bg glownew job description bg svg
  • Posted a month ago
  • Be among the first 50 applicants
Early Applicant
Quick Apply

Job Description

  • Xpertise in the Oracle ODI toolset and Oracle PL/SQL,ODI
  • Knowledge of ODI Master and work repository
  • Knowledge of data modelling and ETL design
  • Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
  • Packaging components, database operations like Aggregate pivot, union etc.
  • Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
  • Design and develop complex mappings, Process Flows and ETL scripts
  • Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
  • Experience of performance tuning of mappings
  • Ability to design ETL unit test cases and debug ETL Mappings
  • Expertise in developing Load Plans, Scheduling Jobs
  • Ability to design data quality and reconciliation framework using ODI
  • Integrate ODI with multiple Source / Target
  • Experience on Error recycling / management using ODI,PL/SQL
  • Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
  • Experience of creating PL/SQL packages, procedures, Functions , Triggers, views, Mat Views and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
  • Experience in Data Migration using Sql loader, import/export
  • Experience in SQL tuning and optimization using explain plan and Sql trace files.
  • Strong knowledge of ELT/ETL concepts, design and coding
  • Partitioning and Indexing strategy for optimal performance
  • Experience in understanding complex source system data structures preferably in Financial services (preferred) Industry

More Info

Job Type:
Function:
Employment Type:
Open to candidates from:
Indian

About Company

Coders Brain is a global leader in IT services, digital and business solutions that partners with its clients to simplify, strengthen and transform their businesses. We ensure the highest levels of certainty and satisfaction through a deep-set commitment to our clients, comprehensive industry expertise and a global network of innovation and delivery centers.

Job ID: 125252445