Description

You will design, develop, and maintain OBIEE reporting solutions and data integration processes.

Responsibilities

• Gather requirements from users and data source subject matter experts to create business requirements documentation.
• Design and develop ELT processes using Oracle Data Integrator (ODI) to move data from source to staging and into fact and dimension tables.
• Build the Physical, Business Model & Mapping (BMM), and Presentation layers of the OBIEE repository (RPD).
• Develop reports and dashboards, utilizing materialized views to ensure performance for navigation and drill-down capabilities.
• Perform data validation using SQL and provide technical documentation and knowledge transfer to business and support staff.

Required Skills

• 5+ years of experience in data warehousing and BI development.
• Expertise in OBIEE repository (RPD) design and development.
• Proficiency in SQL for data validation and analysis.
• Hands-on experience with Oracle Data Integrator (ODI) for ELT processes.
• Experience with data source analysis and mapping from source to staging to target.
• Ability to design data warehouse tables and documentation.
• Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent experience.

Key Skills

Education

Any Graduate