Minimum 2 years of experience in Oracle Data Integrator, Data warehousing & Oracle Analytics
Experience in Analyze, design, development, implement and support Data Warehouse solution in Oracle Data Integrator
Must understand On-premise & cloud options for Oracle Data Integration
Should have exposure to BI landscape, architecture, performance considerations and key BI components
Knowledge of Analysis Design, Development, Customization, Implementation & Maintenance of ODI
Experience working on OBIA with ODI as ELT tool
Experience in Designing, implementing and maintaining ODI load plan and process
Working knowledge of ODI, PL/SQL, TOAD Data Modelling logical / Physical, Star/Snowflake, Schema, FACT & Dimensions tables, ELT,OLAP "
JD for OWB Developer:
More than 5 years experience on Oracle Warehouse Builder (OWB) and Oracle Workflow Builder
Expert Knowledge on Oracle PL/SQL to develop individual code objects to entire DataMart s.
Scheduling tools : Oracle TBSS (DBMS_SCHEDULER jobs to create and run) and trigger based for file sources based on control files.
Must have design and development experience in data pipeline solutions from different source systems (FILES, Oracle) to data lakes.
Must have involved in creating/designing Hive tables and loading analyzing data using hive queries.
Must have knowledge in CA Workload Automation DE 12.2 to create jobs and scheduling.
Extensive knowledge on entire life cycle of Change/Incident/Problem management by using ServiceNow
Employement Category:
Employement Type: Full time Industry: IT - Software Role Category: General / Other Software Functional Area: Not Applicable Role/Responsibilies: OWB Developer