Oracle Developer

Role - Oracle ETL Developer
Location - Indianapolis, IN

1. Overall having 10-15 years of Oracle ETL developer with Oracle Data Integrator (ODI) and Data Warehouse Implementation experience
2. Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI
3. Experience in developing ETL processes - ETL control tables, error logging, auditing, data quality and should be able to implement reusability, parameterization, workflow design, etc.
4. Knowledge of ODI Master, work repository, data modelling and ETL design
5. Setting up topology, building objects in Designer, Monitoring Operator, different type of KM’s, Agents etc.
6. Packaging components, database operations like Aggregate pivot, union etc.
7. Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
8. Design and develop complex mappings, Process Flows and ETL scripts and experience of performance tuning of mappings
9. Ability to design ETL unit test cases and debug ETL Mappings
10. Expertise in developing Load Plans, Scheduling Jobs
11. Ability to design data quality and reconciliation framework using ODI
12. Integrate ODI with multiple Source / Target
13. Experience on Error recycling / management using ODI, PL/SQL
14. Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
15. 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
16. Experience in Data Migration using Sql loader, import/export
17. Experience in SQL tuning and optimization using explain plan and Sql trace files.
18. Strong knowledge of ELT/ETL concepts, design and coding
19. Partitioning and Indexing strategy for optimal performance
20. Must have good verbal and written communication, Strong interpersonal, analytical and problem-solving abilities.
21. 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*