Our client is seeking an experienced Data Warehouse Consultant with expertise in Oracle Warehouse Builder (OWB) to join their team and contribute to an exciting project. As a Data Warehouse Consultant, you will play a crucial role in designing, implementing, and maintaining data warehouse solutions using OWB technology. If you have a passion for data management, problem-solving, and delivering exceptional results, we want to hear from you.
Job Description and Skills Required:
* At least 3-6 years of experience in Data warehousing using Oracle warehouse Builder (OWB)
* IBM Cognos and Power BI is optional
* Good experience in Data warehousing concepts such as dimensional modelling, Star Schema and Snowflake Schema, Galaxy Schema, Data marts, Dimensions and Facts identification.
* Implementation of security using Roles, Privileges, Grants, and object wise privileges.
* Extensively experience in development of E-LT and ETL Mapping in Oracle Data Integrator.
* ETL jobs creation & customization using OWB.
* Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment.
* Worked with multiple sources such as Relational database, Flat files for Extraction Transforming and Loading data into target tables.
* Ability to work individually as well as in a team with excellent problem-solving and troubleshooting capabilities.
* Good hands-on experience in creating RFC and handling tickets using ticketing systems
Candidates basd in Brisbane, Sydney, Melbourne or Canberra are preferred - But will consider anywhere in Australia