What are the responsibilities and job description for the Oracle ETL Developer position at RADcube, LLC?

Job Description

Description :

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

Requirements :

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

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

Receive alerts for other Oracle ETL Developer job openings

Oracle ETL Developer

What are the responsibilities and job description for the Oracle ETL Developer position at RADcube, LLC?

What is the career path for a Oracle ETL Developer?

Job openings at RADcube, LLC

Not the job you're looking for? Here are some other Oracle ETL Developer jobs in the Carmel, IN area that may be a better fit.

We don't have any other Oracle ETL Developer jobs in the Carmel, IN area right now.

AI Assistant is available now!