Oracle Developer with ETL (OBIA)

Siri Infosolutions - Louisville, KY

Full-time

Remote - Louisville, KY

Professional, Scientific, and Technical Services

About the position

The Oracle Developer with ETL (OBIA) role involves managing and optimizing ETL processes using Oracle BI applications. The position requires strong expertise in Oracle Business Analytics Warehouse, ODI coding, and BIACM, with a focus on developing and supporting data warehouse reports and analytics.

Responsibilities

• Manage, support, and optimize all ETL processes for data extraction, transformation, and loading using Oracle Integrator in Oracle BI application (OBIA 12c).
• Design, develop, and test new ETL processes to populate the Reporting/Data Analytics Platform from source systems.
• Manage the development and support of existing data warehouse reports, dashboards, and analytics using Oracle Business Intelligence tools.
• Responsible for end-to-end design, coding, testing, review, and implementation using OBIEE 12c and Oracle Data Integrator.
• Perform 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.