Urgent Requirement - Joining within 15-20 Days
Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc
Should be able to implement reusability, parameterization, workflow design, etc Knowledge of data modelling and ETL design
Design and develop complex mappings, Process Flows and ETL scripts d: Must be well versed and hands-on in using and customizing Knowledge Modules KM
Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents
Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
Design and develop complex mappings, Process Flows and ETL scripts
Experience of performance tuning of mappings d: Integrate ODI with multiple Source / Target
Expertise in database development SQL/ PLSQL for PL/SQL based applications
Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures, Triggers Functions in PL/SQL, Packages, Mate
Hands on experience in Oracle Data Integrator ODI development-Must have worked on Load plans/scenarios Knowledge of data warehousing/ data lake concepts -Should have good knowledge of PL/SQL
Good to have knowledge of query optimization
Good to have knowledge of Reporting Tool/Cognos
Good to have exposer on techno functional role which involves requirement gathering to solution planning
Work Experience Required: 2 to 6 Yrs.
Qualification: Post Graduation