Oracle Developer

Summary

Join our team as an Oracle Developer with ETL (OBIA) experience in Louisville, KY (remote option available). This role focuses on OBIA upgrades/implementation, OBIEE, and ETL processes. You will manage, support, and optimize ETL processes using Oracle Integrator, design and develop new ETL processes, and manage the development of data warehouse reports and dashboards using Oracle Business Intelligence tools. The ideal candidate possesses strong Oracle Business Analytics Warehouse and ODI coding skills, experience with BIACM, and excellent Oracle PL/SQL writing skills. Experience with OBIEE/OBIA upgrades is also required.

Requirements

• Developer who has strong understanding of Oracle Business Analytics Warehouse and ODI coding
• Experience with BIACM (Oracle BI Applications Configuration Manager)
• Overall very good oracle pl SQL writing skills
• Strong knowledge of Oracle Business Analytics Warehouse and Oracle BI Applications Configuration Manager tool
• Working experience with OBIEE/OBIA upgrades

Responsibilities

• Manage, Support, and optimize all ETL process to perform data extraction, transformation, and loading (ETL) using the Oracle Integrator tool in Oracle BI application (OBIA 12c)
• Design, Develop and Test any new ETL process required to populate the Reporting/Data Analytics Platform from source systems
• Manage the development of new and the support of existing data warehouse reports, dashboards, analytics, or other data warehouse output requirements using the Oracle Business Intelligence tools
• Responsible for end-to-end design, coding, testing, review, and implementation using OBIEE 12c and Oracle Data Integrator and Oracle OBIA applications
• Perform data queries for analysis by understanding existing warehouse structures
• Additional responsibilities include troubleshooting, maintenance, optimization and performance tuning of ETL jobs to meet SLA