Job Title

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 specificationsSkills/Experience Requirements:5+ 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 modeling in a highly complex environment.5+ 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 2022Strong proven expertise in PL/SQL and Data ModelingExposure to Oracle Analytics Server is beneficialExperience developing, designing and maintaining Cloud data extractsExcellent communication and documentation skills.Must have expertise in the following: ODI with BI Apps (OBIA) 11.1.1.10ODI11.1.1.9/12cOBIEE 11g/12c Repository (RPD)Oracle Analytics ServerExposure to BI Cloud adaptors