Job Description:

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

Salary Not Disclosed by Recruiter
Industry IT-Software / Software Services
Functional Area IT Software - Application Programming, Maintenance
Role Category Programming & Design
Role Software Developer
Employment Type Full Time, Permanent

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : IT-Software
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 12th May 2020

Key Skills:

These are some of our most popular tutorials

People who search this job also searched for the following Keywords


Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status