The recruiter will look for the following skills while searching for an ETL or ODI developer. Particular positions may need different skills but these are the general ODI skills needed.
- Know everything about ODI architecture and ODI components.
- Working knowledge with creating different interfaces, packages, constraints, procedures, SQL joins functions and agents etc.
- Extend the base ODI Knowledge Modules to create customized versions that will be re-usable across the company's data integration projects.
- Map business rules into Oracle Data Integrator Interfaces, Packages, and Load Plans source to target mappings .
- Take care of business rules using ODI Constraints and Data quality functions.
- Know the differences between Oracle Data Integrator versions like 10g, 11g and 12c.
- Working knowledge with Change Data Capture (CDC).
- Knowledge on Data warehouse concepts such as Dimensional modelling, Entity relationship.
Apart from knowing the tool, the developer must be aware of data warehouse concepts in depth. SQL skills are also must.