Remote Senior Oracle & Informatica Data Warehouse Engineer

Booker DiMaio, LLC; Northern (KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Booker DiMaio, LLC is seeking a Senior Oracle / Informatica Data Warehouse Engineer to support a newly awarded Internal Revenue Service contract focused on SharePoint Online and Microsoft 365 data integration and reporting.

The role requires senior-level Oracle and Informatica expertise, with responsibilities across ETL development, data warehouse optimization, and cross-functional collaboration. Remote work is offered for a US federal engagement with security clearances and onboarding processes.

Qualifications

• Demonstrated professional experience supporting U.S. Federal Government programs or federal government customers.
• Strong hands-on Oracle database development experience.
• Strong PL/SQL development experience.
• Experience with data warehouse architecture and development.
• Experience with Informatica and ETL processes.
• Experience with database performance, data integration, and troubleshooting.
• Ability to operate as a senior technical SME within a multidisciplinary team.

Responsibilities

• Provide senior subject matter expertise for Oracle data warehouse development and related technical strategies.
• Develop and support Oracle database objects, including PL/SQL, data views, triggers, and functions.
• Analyze and troubleshoot database performance and optimize database solutions.
• Support Informatica ETL workflows and data integration activities.
• Work with data originating from systems such as PPS/SAP, SharePoint, Power Platform, FPDS, SAM.gov, USAspending, and other sources as required.
• Support data ingestion, transformation, integration, and availability for downstream reporting and analytics.
• Collaborate with Power BI, Power Platform, SharePoint, and project management team members to support integrated solutions.
• Provide technical troubleshooting, recommendations, and documentation.

Skills

Federal Government experience

Senior SME

Team collaboration

Tools

Oracle

Informatica

PL/SQL

ETL

Power BI/Power Platform

Job description

Booker DiMaio, LLC is seeking a Senior Oracle / Informatica Data Warehouse Engineer to support a newly awarded Internal Revenue Service contract focused on SharePoint Online and Microsoft 365 data integration and reporting.

The role requires senior-level Oracle and Informatica expertise, with responsibilities across ETL development, data warehouse optimization, and cross-functional collaboration. Remote work is offered for a US federal engagement with security clearances and onboarding processes.