Job details
Position Function: This position is responsible for the development and support of ETL’s used for loading Oracle Business Intelligence Data Warehouses. The ETL tools used for loading is Oracle Data Integrator (ODI). The candidate will be required to implement ETL’s between Oracle EBS, cloud bases data sources, third party environments and the Oracle BI Data Warehouses. Primary responsibilities: Include designing, implementing and supporting all areas of data loading process as well as troubleshooting, monitoring and coordinating the release of ETL processes. Essential Duties and Responsibilities:
- Overall technical owner and administrator for OBIEE and any supplemental BI Solutions.
- Maintain daily ETL loads and work with offshore team leading the development of ODI interfaces and the Datawarehouse additions.
- Development of new data models.
- Create Datawarehouse data marts and subject areas in OBIEE for Business Intelligence, Reporting and Analytics.
- Gain an understanding from business users of requirements for reporting Metrics, KPIs and standard analytics.
- Transform these requirements into Business Intelligence solutions available to end users.
- This position is responsible for maintaining a very high level of technical expertise on industry standards concerning business intelligence applications and processes.
- Document and deliver technical specifications
- 3+ years’ years of experience designing, developing, and supporting complex data warehousing, data marts and ETL environments in a senior position.
- Proven experience in performing conceptual, logical, and physical data modelling in a highly complex environment.
- 3+ years using: Oracle E-Business Suite (12.x or higher)
- Oracle BI Applications (OBIA) exposure to versions 11.1.1.10 +
- Exposure to Microsoft SSIS 2022
- Strong proven expertise in PL/SQL and Data Modelling
- Exposure to Oracle Analytics Server is beneficial
- Experience developing, designing and maintaining Cloud data extracts
- Excellent communication and documentation skills.
- Oracle OBIEE
- OAS
- OAC
- Oracle EBS environment (also known as EBIZ or E-Business)
- Advanced Analytics or Visualization
- SQL Development
- ODI Basic experience
Apply safely
To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.
