Oracle Developer with ETL (OBIA)

Axiom Software Solutions Limited - Louisville, KY

Full-time

Remote - Louisville, KY

About the position

The Oracle Developer with ETL (OBIA) position is focused on managing, supporting, and optimizing ETL processes within the Oracle Business Analytics Warehouse environment. The role requires a strong understanding of Oracle BI Applications and involves designing, developing, and testing ETL processes to enhance the Reporting/Data Analytics Platform. The developer will also be responsible for creating and maintaining data warehouse reports and dashboards, ensuring efficient data extraction, transformation, and loading using Oracle tools.

Responsibilities

• Manage, support, and optimize all ETL processes using Oracle Integrator tool in Oracle BI application (OBIA 12c).
• Design, develop, and test new ETL processes required for the Reporting/Data Analytics Platform.
• Manage the development and support of data warehouse reports, dashboards, and analytics using Oracle Business Intelligence tools.
• Perform end-to-end design, coding, testing, review, and implementation using OBIEE 12c and Oracle Data Integrator.
• Conduct data queries for analysis by understanding existing warehouse structures.
• Troubleshoot, maintain, optimize, and tune ETL jobs to meet SLA requirements.

Requirements

• Strong understanding of Oracle Business Analytics Warehouse and ODI coding.
• Experience with BIACM (Oracle BI Applications Configuration Manager).
• Proficient in Oracle PL/SQL writing skills.
• Working experience with OBIEE/OBIA upgrades.