Oracle Developer job at RADcube Indianapolis, IN, US

Job Description

Oracle Developer Type: Contract | Location: Indianapolis, Indiana Role - Oracle ETL Developer Location - Indianapolis, IN

Overall having 10-15 years of Oracle ETL developer with Oracle Data Integrator (ODI) and Data Warehouse Implementation experience
Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI
Experience in developing ETL processes - ETL control tables, error logging, auditing, data quality and should be able to implement reusability, parameterization, workflow design, etc.
Knowledge of ODI Master, work repository, 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 and 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, 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.

APPLY FOR THIS JOB First Name* Last Name* Email* Phone* City* State Province* Key Skills* Years of Experience (number value)* Current Pay ($)* Expected Pay ($)* Availability for project * LinkedIn profile * Attach Resume* #J-18808-Ljbffr RADcube

Job Tags

Contract work,

Similar Jobs

Inova Health System

Senior Power Plant Operator Job at Inova Health System

Inova Alexandria Hospital is looking for a dedicated *Senior Power Plant Operator* to join the team. This role will be full-time and will be required to work various morning, evening & night shifts. Schedules are made a month in advance. Please make sure you read the...

WingRep

Senior Sales Development Representative (SDR) Job at WingRep

What Youll Do As the Founding SDR at WingRep, youll help build a qualified pipeline by engaging with potential customers. This includes outbound and inbound prospecting via phone, email, LinkedInor whatever it takes to get them excited about WingRep.Drive Scalable Pipeline...

Donohue and Associates

Endocrinology Job at Donohue and Associates

...Employed outpatient only Endocrinology position joining (6) Endocrinology physicians and (4) Endo NP providers in a well established physician owned private practice with a (34) provider multispecialty group in practice over 40 years with multiple offices in desirable...

Sunnyside Group LLC

Delivery Driver Job at Sunnyside Group LLC

...Description Job Description We the Pizza Capitol Hill is looking for fun energetic delivery drivers. Do you have a Bike, scooter or car and are looking to make some extra cash on the side. Look no further. Flexible Schedule. Small delivery area. Pay with tips...

Wingstop

Shift Leader Job at Wingstop

...do, there's only Wingstop. We are looking for team members who want to deliver a flavor experience. We are looking for excellent shift leaders to supervise the operations of a shift to ensure that food safety, productpreparation, cleanliness, and company standards are...