Senior OAS/ODI Developer (onsite/hybrid in Fairfax, VA)

Overview

ILS is seeking a Senior OAS/ODI Developer to support our direct federal contract in Washington, D.C.

Responsibilities

• Design, develop, and implement complex reports, dashboards, and interactive visualizations using Oracle Analytics Server (OAS) and its components (e.g., Data Visualization, Dashboards, Analyses, BI Publisher).
• Build and manage OAS RPD models (Physical, Business Model and Mapping, Presentation Layers) to optimize data accessibility and performance.
• Configure and administer OAS security, including RPD and catalog security, object permissions, and user/group management.
• Troubleshoot and optimize OAS performance, including report rendering, data refresh, and query execution.
• Collaborate with business users and stakeholders to gather requirements, translate them into technical specifications, and deliver effective analytical solutions.

• Design, develop, test, and deploy robust and scalable ETL/ELT processes using Oracle Data Integrator (ODI).
• Create and optimize ODI mappings, procedures, packages, and scenarios to extract, transform, and load data from various source systems (relational databases, flat files, APIs, etc.) into target data warehouses and data marts.
• Implement data quality checks, error handling, auditing, and reconciliation mechanisms within ODI processes.
• Monitor and troubleshoot ODI execution, resolve data integration issues, and ensure data integrity and accuracy.
• Work with data architects to design and implement efficient data models within the data warehouse.

• Write complex, high-performance SQL queries for data extraction, transformation, analysis, and reporting against large datasets in Oracle databases.
• Perform advanced SQL tuning and optimization (e.g., using EXPLAIN PLAN, indexes, partitioning) to enhance query and ETL performance.
• Apply strong data analysis skills to understand data patterns, identify anomalies, and derive actionable insights from various data sources.
• Collaborate with business analysts and data scientists to support their data needs and facilitate advanced analytical initiatives.
• 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.
• Implement best practices for data governance, data security, and data lineage within the data pipeline.
• Automate data pipeline processes for efficiency and scalability.

• Install, configure, and maintain Oracle WebLogic Server domains for OAS and ODI deployments.
• Monitor WebLogic Server health, performance, and resource utilization, and perform basic troubleshooting.
• Deploy and manage applications (OAS, ODI agents) on WebLogic Server.
• Assist with WebLogic patching, upgrades, and security configurations.
• Understand and apply basic WebLogic clustering, high availability, and disaster recovery concepts.
• • Experience with Cloud Infrastructure and its data services.
• • Knowledge of other data visualization tools (e.g., DV, Tableau & Power BI).
• • Experience with scripting languages (e.g., Shell, Python) for automation.
• • Familiarity with Agile development methodologies.
• • Oracle certifications related to OAS, ODI, or Database.

Qualifications

• Must have 8+ years of hands-on experience in OBIEE reporting and administration on OBIEE or OAS (Oracle Analytic Services), Linux Operating System, and ODI;
• Strong PL/SQL and data analysis
• Optional: MS Power BI administration including Power BI admin and Power BI Publishing/scheduling
• Preferred: WebLogic Server Administration experience