– Overall having 5+ Years’ Experience in Oracle Data Integrator (ODI) 12c, 11g, 10g.

– Must have Hands on Development Experience in ODI-12c. development of Complex ODI Packages, Mappings, Load Plans, ETL processes flow, ETL control tables, ETL Scripts, Error logging, auditing, data quality, etc.

– Good to have Hands on Development Experience in lower versing ODI -10g as well.

– Should have the ability to Set up, Configure ODI environments, Topology, Model, building objects in Designer, Monitoring Operator, different type of KM’s, Agents etc.

– Must be well versed and hands-on in using and Customizing Knowledge Modules (KM)

– Good Experience in ODI Version Upgrade & ODI Migration.

– Experience of ODI Performance Tuning of Packages, mappings, flows.

– Ability to design ETL Unit Test cases and Debugging ETL Packages, Mappings

– Expertise in developing Load Plans, Scheduling Jobs

– Integrate ODI with multiple Source / Target

– Experience on Data Control, Error Recycling in ODI.

– Should have the concept of Data Warehouse, Star, Fact, Dimensions, Lookups.

– Experience on Oracle RDBMS, Tables, Views, Synonyms.

– Should have good knowledge & experience on Indexing, Gather Stats, Performance Tuning at Database level.

– Experience on Oracle SQL Developer, Advanced skills of SQL (analytical functions etc.) and PLSQL

– Should be responsible to independently Design & Develop complex Packages, Mappings, Process Flows and ETL scripts, Customization of Knowledge Modules, Fitments, Testing, Debugging of Errors, ODI Code-Fix, ODI Backups and Code Deployments across various instances like DEV, SIT, UAT, PROD.

Carrying out Unit Test and System Integration Testing till PROD Go-Live and beyond.

– Should have the ability to Communicate effectively and present/demo ideas and solutions

– Must be a Team Player & Contributor.