Role and Responsibilities
- Should have experience in developing ETL processes.
- Knowledge in the Oracle ODI toolset and Oracle PL/SQL
- Knowledge of data modelling and ETL design
- Basic knowledge of ODI Admin ODI Installation in High Availability Start and Stop the services and agents Patching Activities and Security Implementation.
- Setting up topology building objects in Designer Monitoring Operator different type of KMs Agents etc
- Packaging components database operations like Aggregate pivot union etc.
- Using ODI mappings error handling automation using ODI Migration of Objects
- Design and develop complex mappings Process Flows and ETL scripts.
- Must be well versed and handson in using and customizing Knowledge Modules (KM)
- Expertise in developing Load Plans Scheduling Jobs
- Ability to design data quality and reconciliation framework using ODI.
- Integrate ODI with multiple Source / Target.
- Experience in Working with Restful Services JSON Data
- Experience on Error recycling / management using ODI PL/SQL
Other Skills:
- Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
- Good knowledge of DB performance terminologies like partitioning indexing hints etc.
- Strong knowledge of ELT/ETL concepts design and coding
- Must have good verbal and written communication in English Strong interpersonal analytical and problemsolving abilities.
- Ability to work with minimal guidance or supervision in a time critical environment.
Vertical
Technology
Remote Work :
No