Remote Senior Oracle & Informatica Data Warehouse Engineer

bookerdimaio

United States

Remote

USD 120,000 - 170,000

Full time

14 days+

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

Booker DiMaio is building a technical support team for an IRS contract focused on SharePoint Online and Microsoft 365. We seek a Senior Oracle / Informatica Data Warehouse Engineer to provide senior technical expertise in data warehouse development, integration, and performance.

The role supports Oracle development strategies and ETL workflows with Oracle, Informatica, and multiple enterprise sources. The SME will troubleshoot, optimize, and maintain data structures and ETL processes within a

Qualifications

Experience with Oracle database development and PL/SQL.
Strong data warehouse architecture and ETL design experience.
Proficiency with Informatica and data integration.
Ability to act as a senior SME within a multidisciplinary team.

Responsibilities

Provide senior subject matter expertise for Oracle data warehouse development and related strategies.
Develop and support Oracle database objects including PL/SQL, views, triggers, and functions.
Analyze and troubleshoot database performance and optimize solutions.
Support Informatica ETL workflows and data integration activities.
Collaborate with systems like PPS/SAP, SharePoint, Power Platform, FPDS, SAM.gov, USAspending as needed.
Support data ingestion, transformation, and availability for reporting and analytics.
Coordinate with Power BI/Power Platform/SharePoint teams to enable integrated solutions.
Provide troubleshooting, recommendations, and documentation.