Oracle ETL Developer Job at RADcube, LLC, Carmel, IN

cDVFUk9TU096ejdVdEo5T2lDRHVxU2g0bVE9PQ==
  • RADcube, LLC
  • Carmel, IN

Job Description

Job Description

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.

Job Tags

Similar Jobs

Molden & Associates

ENTRY LEVEL Graphic Designer - US ONLY Job at Molden & Associates

Entry Level Production and Comp role Opportunity in Graphic Design packaging department. In this role you will be responsible for hands creation of product packaging mock-ups, complex production and layout. RESPONSIBILITIES INCLUDE; Designs, develops, produces... 

Marathon Promotions

Customer Service Claims Support Job at Marathon Promotions

 ...example and sharing of knowledge/skill Requirements of the Entry Level Claims Support: All majors encouraged to apply No degree requires Excellent student mentality and ability to learn new strategies and business techniques Ability to understand client... 

McKesson

Warehouse Worker - Part Time Shifts Job at McKesson

McKesson - JobID: 77952765840 [Material Handler / Freight Handler] As a Warehouse Worker at McKesson, you'll: Move efficiently to ensure that life-changing products are shipped quickly and accurately through effective order fulfillment management; Drive power industrial... 

Fountain Valley School of Colorado

PT - School Bus Driver Job at Fountain Valley School of Colorado

 ...the School provides a rigorous, global curriculum in academics, arts, athletics, and the outdoors. The Opportunity: The Bus Drivers is in charge of providing safe transport of high school children based on a schedule and route. Their duties may include helping... 

Affiliated Engineers

Security Consultant Job at Affiliated Engineers

 ...Affiliated Engineers, Inc. (AEI) is a leading, multidisciplinary consulting engineering firm and collaborative community of over 800...  ...the highest standards in sustainable design practices. As a Security Consultant in our Chicago office, you will help us empower...