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