> Markdown version of [/jobs/ext/2198145-oracle-informatica-data-warehouse-sme-with-federal-government-experience](https://www.wearedevelopers.com/jobs/ext/2198145-oracle-informatica-data-warehouse-sme-with-federal-government-experience). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Oracle / Informatica Data Warehouse SME with Federal Government Experience - **Company:** Booker DiMaio, LLC - **Location:** Washington, DC, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Databases, Data Validation, Data Dictionary, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Warehousing, Database Development, Database Schema, Metadata, Oracle Databases, Oracle (Applications), Oracle Warehouse Builder, Performance Tuning, Power BI, Microsoft SharePoint, SQL Stored Procedures, PL-SQL, Enterprise Software Applications, Informatica Powercenter, Oracle Integration - **Published:** August 23, 2026 - **Apply:** https://www.careerjet.com/jobad/us72ac4c8ec256203adae10e26df0edb36 ## About the Role * Strong hands-on experience with Oracle database development. * Strong PL/SQL development experience. * Experience developing Oracle views, functions, triggers, queries, and related database objects. * Strong experience with Informatica and ETL development. * Experience designing, developing, maintaining, and troubleshooting ETL workflows. * Experience working with enterprise data warehouse environments. * Experience integrating data from multiple source systems. * Experience with data quality, data integrity, metadata, and data dictionaries. * Ability to troubleshoot complex database, data integration, and ETL issues. * Strong analytical and problem-solving skills. * Strong written and verbal communication skills. Desired Qualifications * Federal government experience. * Experience supporting the IRS or Department of the Treasury. * Experience with procurement or acquisition data. * Experience integrating Oracle with SharePoint Online and Microsoft Power Platform. * Experience with Power BI or enterprise reporting environments. * Experience working with SAP data sources. * Experience with external government data sources such as SAM.gov, FPDS, or USAspending. * Experience providing technical training and knowledge transfer. * Experience working in environments with federal security, governance, and compliance requirements. Powered by JazzHR Booker DiMaio ## Description Booker DiMaio is seeking an experienced Oracle / Informatica Data Warehouse SME to support a technology initiative with the U.S. Internal Revenue Service (IRS). This position will provide subject matter expertise supporting an enterprise Oracle data warehouse environment, including database development, data integration, ETL workflows, performance optimization, and data quality. The role will work closely with technical teams supporting reporting, analytics, Microsoft Power Platform, SharePoint, and other enterprise systems. The ideal candidate will have strong hands-on experience with Oracle, PL/SQL, Informatica, and enterprise data warehouse environments, along with the ability to troubleshoot complex data and integration issues. Responsibilities * Provide subject matter expertise supporting an enterprise Oracle data warehouse environment. * Develop and maintain Oracle database objects, including tables, views, stored procedures, functions, triggers, and queries. * Develop and optimize PL/SQL solutions and Oracle database performance. * Develop, maintain, and troubleshoot Informatica ETL workflows. * Support data integration and ETL processes involving multiple source systems. * Develop queries and data views to support reporting, analytics, and business requirements. * Support data validation, integrity, quality, metadata, and data dictionary activities. * Troubleshoot database, data integration, and ETL issues and develop appropriate solutions. * Support integration between the data warehouse and reporting, SharePoint, Power Platform, and other enterprise applications. * Collaborate with Power BI developers, application developers, and other technical personnel to support data and reporting requirements. * Provide technical documentation, guidance, and knowledge transfer as needed., Location: Remote, with occasional onsite work at IRS locations Employment Type: Full-Time Travel: Occasional travel may be required; approved travel expenses will be reimbursed. … + 21 hours ago + Apply easily + ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)