Senior OAS/ODI Developer

Job Description

Design, develop, and maintain enterprise analytics solutions using Oracle Analytics Server (OAS) and Oracle Data Integrator (ODI). Collaborate closely with business stakeholders, data architects, and analysts to deliver high-quality dashboards, reports, and scalable data pipelines that support critical business decisions.

Requirements

• Strong expertise in SQL, data modeling, and ETL/ELT development
• Hands-on experience optimizing performance and ensuring data quality
• Experience with WebLogic Server administration and modern data visualization tools (optional but preferred)

Responsibilities

• Design, develop, and implement complex reports, dashboards, and interactive visualizations using Oracle Analytics Server (OAS) and its components.
• Create and optimize ODI mappings, procedures, packages, and scenarios to extract, transform, and load data from various source systems into target data warehouses and data marts.
• Implement data quality checks, error handling, auditing, and reconciliation mechanisms within ODI processes.
• Develop and maintain clear and comprehensive documentation for SQL queries, data models, and ETL processes.
• Play a key role in designing, building, and maintaining end-to-end data pipelines that ensure timely, accurate, and reliable data flow for analytics and reporting.
• Install, configure, and maintain Oracle WebLogic Server domains for OAS and ODI deployments.
• Understand and apply basic WebLogic clustering, high availability, and disaster recovery concepts.

Qualifications

• Expertise in SQL, data modeling, and ETL/ELT development
• Hands-on experience optimizing performance and ensuring data quality
• Experience with WebLogic Server administration and modern data visualization tools (optional but preferred)

Skills

• Strong expertise in SQL, data modeling, and ETL/ELT development
• Hands-on experience optimizing performance and ensuring data quality
• Experience with WebLogic Server administration and modern data visualization tools (optional but preferred)

Benefits

N/A

Pay

TBD

Schedule

Hybrid role with in-office presence two days per week at our headquarters (Fairfax, VA 22033).