EY Oracle Data Integrator (ODI 12c)-cum-PLSQL Developer in Bangalore, India

Oracle Data Integrator (ODI 12c)-cum-PLSQL Developer


Requisition # BLR0012R

Post Date 6 days ago

  • Expert on technical environment/ tools for own area of expertise

  • Knowledge on business processes and procedures, as well as broader organizational issues and technology

  • Should be able to assist with design, development, integration, performance tuning, rollout, support and optimization during implementation of data-mart build-out.

  • Work with business users globally to clarify ETL requirements and business rules for the implementation of solutions and problem resolution.

  • Understand pre-designed Financial Services -specific target data models, metadata layer, data marts and ETL processes

  • Experience with Oracle database, SQL queries, stored procedures, for interfacing with the database and database designs

  • Design, develop, implement, troubleshoot, optimize, and tune ETL processes

  • Create and execute unit test plans based on system and validation requirements.

  • Ensure that all timelines of loading/validating data are met


  • Overall having 6+ years of ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (ODI).

  • Minimum 2-3 end to end DWH Implementation experience.

  • Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.

  • Expertise 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 KM’s, 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

  • Must have Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.

  • Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High and Low level design documents.

  • Experience in understanding complex source system data structures preferably in Financial services (preferred) Industry

  • Ability to work with minimal guidance or supervision in a time critical environment.