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 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

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

More Jobs at Contactx Resource Management Pvt. Ltd.

Tax Transfer Pricing Professional

mumbai

3.0 - 7.0 yrs

INR 5 - 9 Lacs

Senior Engineer - Projects

gandhinagar, ahmedabad

2.0 - 5.0 yrs

INR 5 - 9 Lacs

Internal Audit - Mutual Fund Professional

mumbai

2.0 - 3.0 yrs

INR 3 - 6 Lacs

Area Sales Manager - BET

chennai, bengaluru

4.0 - 8.0 yrs

INR 3 - 7 Lacs

Sr. Sales Engineer - HVAC / Chiller Sales

hyderabad, chennai

2.0 - 5.0 yrs

INR 2 - 6 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Contactx Resource Management Pvt. Ltd.

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

ODI PLSQL Developer