Still Struggling with Tech Hiring? Discover Olibr's Solution Now!

Oracle Data Integrator|Multiple|6+Years

  • DigiHelic Solutions Pvt. Ltd.
  • Multiple
  • 6 - 8 Yrs

Job Description

  • Hands-on 6+ year exp in designing complex ODI Oracle Data Integrator packages, ODI Scenarios, Mappings, Variables.
  • Strong exp in in Analysis, Design, Development, Implementation of Data Warehousing in ETL process using ODI 12c/11g.
  • Expertise in Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake Schema modeling.

Job Responsibilities

  • Ability to design data quality and reconciliation framework using ODI Integrate ODI with multiple Sources /Target
  • Experience in building/customizing ETLs from Source Systems such as Oracle Database to Data Warehouse.
  • Exp in Working with ODI Designing, Topology Management, Operator, Security management.
  • Exp Oracle Data Integrator Designer (ODI) to develop processes for Extracting, Transforming, Integrating, and loading data into Target Systems.
  • Expertise in configuring the ODI Master and Work Repositories, ODI models etc
  • Excellent in writing PL-SQL DDL & DML queries and troubleshooting complex stored-procedures
  • Packaging components, database operations like Aggregate pivot, union, etc. using ODI mappings, error handling, automation using ODI, Loadplans, Migration of Objects.
  • Must be well-versed and hands-on in using and customizing Knowledge Modules (KM).
  • Setting up topology, building objects in Designer, Monitoring Operator, different types of KMs, Agents, etc.
  • Worked with Oracle, XML data, File in ODI.

Location

Chennai, Tamil Nadu, India

Noida, Uttar Pradesh, India

Pune, Maharashtra, India

Bengaluru, Karnataka, India