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

AAOS

Marketing Manager Job at AAOS

 ...Get ready to ignite your marketing journey with AAOS as our new Marketing Manager! In this role, you will plan, develop, and implement innovative and integrated marketing campaigns for a diverse range of products, courses, services, and programs. Collaborating with enthusiastic... 

Confidential

Board Member Job at Confidential

 ...Board Member About the Company Respected pre-clinical biotechnology company Industry Biotechnology Type Privately Held About the Role The Company is in search of a Board Member with a strong background in clinical leadership, particularly in the... 

Smartdept. inc.

Web Designer Job at Smartdept. inc.

smartdept. is searching for a Web Designer for an ad agency client. This is a part-time , fully remote , ongoing contract opportunity.The primary responsibility of the Web Designer will be to create and maintain clients websites. This includes designing the website,... 

Uprite Construction Corporation

Senior Construction Project Manager Job at Uprite Construction Corporation

* Please Note: Uprite Construction is not accepting resumes from third-party agencies for this position. Any unsolicited resumes will...  ...for unsolicited referrals.* We are hiring for a Senior Project Manager who will be based in our Roseville office. What You'll... 

BlueOval SK

Waste Management Engineer Job at BlueOval SK

 ...worlds best battery manufacturer. About the Opportunity The Waste Engineer at BlueOval SK will have a once-in-a-lifetime...  ...processes to identify opportunities for reduction, reuse, and recycling. + Process Optimization: Collaborating with cross-functional...