| Oracle - ODI Production Support Analyst - ETL - Onsite - TCS at Oracle, Arizona, USA |
| Email: [email protected] |
| From: AJAY, KK Software Associates [email protected] Reply to: [email protected] Role name: Developer Role Description: DWH support experience using ODI. Should have experience in developing ETL processes - ETL control tables, error logging, auditing etc. Should be able to implement reusability, parameterization, workflow design, etc. knowledge of ODI Master and work repository Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects Design and develop complex mappings, Process Flows and ETL scripts Must be well versed and hands-on in using and customizing Knowledge Modules (KM) 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 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 DWH support experience using ODI. Should have experience in developing ETL processes - ETL control tables, error logging, auditing etc. Should be able to implement reusability, parameterization, workflow design, etc. knowledge of ODI Master and work repository Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects Design and develop complex mappings, Process Flows and ETL scripts Must be well versed and hands-on in using and customizing Knowledge Modules (KM) 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 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 Competencies: Oracle Data Integrator (ODI) Branch | City | Location: TCS - Hartford, CT Bloomfield Bloomfield, CT Keywords: procedural language Connecticut Oracle - ODI Production Support Analyst - ETL - Onsite - TCS [email protected] |
| [email protected] View all |
| Wed Oct 23 03:06:00 UTC 2024 |