| ODI Production Support Analyst Location-Bloomfield, CT at Bloomfield, Connecticut, USA |
| Email: [email protected] |
| ole 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) Experience (Years): 6-8 -- Tauheed Saleem | Talent Acquisition Teamware Solutions a division of Quantum Leap Consulting Pvt. Ltd 2838 E. Long Lake Road Suite 210, Troy, MI 48085 [email protected] LinkedIn- linkedin.com/in/tauheed-saleem-92ab546a/ Disclaimer This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- Keywords: information technology procedural language Michigan ODI Production Support Analyst Location-Bloomfield, CT [email protected] |
| [email protected] View all |
| Wed Oct 23 00:52:00 UTC 2024 |