What are the responsibilities and job description for the Oracle Developer position at RADcube?
Oracle Developer Type : Contract | Location : Indianapolis, Indiana | Job Posted on : Wed, 18 Dec 2024
Role - Oracle ETL Developer
In order to make an application, simply read through the following job description and make sure to attach relevant documents.
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
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
