Expertise in working with Oracle Data Integrator 11g/12c
Hands on experience on creating interface/mappings, procedures, packages, variables etc
Working with multiple source system like Oracle, Files, etc
Strong Data warehouse concepts & writing complex SQL and PLSQL code
Experience in architecting data-related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.
Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Load plans, and Metadata.
Experience using Dimensional Data modelling, Star Join Schema modelling, Snow-Flake modelling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modelling.
Ability to develop and maintain data warehouse mappings
Ability to develop ETL solutions and automate data loading processes
Primary Skills
Expertise in working with Oracle Data Integrator 11g/12c
Strong Data warehouse concepts & writing complex SQL and PLSQL code
Secondary Skills
Relational database knowledge (relational models, star schema, keys, common terminology)
Ability to take initiative and work independently with minimal supervision in a structured environment
Ability to coordinate completion of multiple tasks and meet aggressive time frames