Required Skills: 6+ Year experience- 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
S
Syntricate Technologies Inc