OBIEEOBIA 3 - 8 Yrs

Requirements

We are seeking an experienced Data Warehouse/BI Developer to join our team. The ideal candidate will have a strong background in implementing Data Warehouse and Business Intelligence (BI) solutions using Oracle BI tools. This role involves developing reports managing metadata and working with various data warehousing and ETL tools.

Key Responsibilities:

• Implement Data Warehouse and BI solutions using Oracle BI tools.
  
• Develop and maintain reports and metadata repositories (RPD).
  
• Utilize ODI (Oracle Data Integrator) DW/BI SQL and scheduling tools such as BIACM and DAC.
  
• Apply expertise in data warehousing concepts including Slowly Changing Dimensions (SCDs) star schema hierarchy and aggregation.
  
• Employ advanced repository modeling concepts including fragmentation and aggregate awareness.
  
• Develop and execute ETL routines using ODI tools.
  
• Work with RDBMS (Relational Database Management Systems) such as Oracle Teradata SQL Server or DB2.
  

Required Skills:

• Proven experience in implementing Data Warehouse/BI solutions.
  
• Expertise in Report Development and RPD Metadata Development.
  
• Proficiency in ODI DW/BI SQL and scheduling tools (BIACM DAC).
  
• Strong knowledge of data warehousing concepts including SCDs star schema hierarchy aggregation and advanced repository modeling.
  
• Experience in reporting repository development and working with RDBMS (Oracle Teradata SQL Server or DB2).
  
• Experience in building and executing ETL routines using ODI tools.
  

Benefits