RadCube Careers
Oracle Developer
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.
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.
