Oracle / Informatica Data Warehouse SME with Federal Government Experience

Full-time

Booker DiMaio, LLC

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.

Position Overview

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.

Required Qualifications

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.

Apply

Vacancy posted 2 days ago

Similar jobs that could be interesting for youBased on the Oracle / Informatica Data Warehouse SME with Federal Government Experience in Washington DC vacancy

10 Years Azure Data Solutions Architect
Role: Azure Data Solutions Architect... ...Client: DC Government Location: Washington... ...lakehouse and warehouse on Azure... ...Work closely with senior management... ...and Skills Experience: 15+ years of... ...Microsoft SQL Server, Oracle, PostgreSQL,... ...tools (SSIS, Informatica), and cloud-...
Oracle
Permanent employment
Full time
GoIntellects Inc.
Washington DC
5 days ago
Enterprise Imaging Architect SME Senior Manager
$135.2k - $278.5k
...At Accenture Federal Services, nothing... ...the US federal government make the nation... ...through hands-on experience, certifications... ...Matter Expert (SME) provides... ...Collaborate with capture and proposal... ...and interpret data to develop actionable... ...involving: Oracle Health...
Oracle
Full time
Live in
Work at office
Local area
Accenture Federal Services
Washington DC
2 days ago
Data Warehouse Subject Matter Expert (SME)
...Data Warehouse Subject Matter Expert (SME) 100% on-site Secret Clearance required. Position... ..., including systems with multi-terabyte data... ...years of total database experience. ~12+ years of SQL Server... ...deemed appropriate by the Government . Why Join Nationwide...
Suggested
For contractors
Work at office
Nationwide IT Services
Arlington, VA
5 days ago
Data Analytics/Automation SME
...award of contract, government acceptance of candidate... ...Summary The Data Analytics / Automation SME provides technical... ...Ability to leverage Oracle Federal Financials functionality... ...Education & Experience Requirements Education... ...Analytics Proficient with UiPath and...
Oracle
Full time
Contract work
Potawatomi Federal Solutions
Washington DC
4 days ago
Senior Data Warehouse Engineer
$140k - $180k
...seeking a Senior Data Warehouse Engineer to join... ...and work closely with clients to develop... ...and enforce data governance strategies, ensuring... ....5-7+ years of experience in data... ...PostgreSQL, MySQL, Oracle).Bachelor's degree... ...Change Agent in the Federal contracting industry...
Oracle
Steampunk
McLean, VA
4 days ago
Software Architect SME - Cloud, Data Analytical Platforms
$175 per hour
DescriptionSoftware Architect SME - Cloud, Data & Analytical... ...resilient, and aligned with federal standards and... ...partners closely with government stakeholders, engineering... ...architecture strategy across Oracle RAC, PostgreSQL,... ...10+ years of experience in software engineering...
Oracle
Full time
For contractors
Work at office
ActioNet
Suitland, MD
2 days ago
Data Engineer
...operationalizing the enterprise data and analytics... ...working closely with business and IT... ...databases (Oracle, SQL Server, DB2,... ...Analytics using AWS Glue, Informatica, EMR, Spark,... ...and building Data Warehouse using Snowflake.... ...~8+ years of experience in Enterprise Information...
Oracle
My3Tech Inc
Washington DC
3 days ago
Senior Data Engineer
...to Washington DC with 1-2 days a week onsite... ...a skilled Senior Data Engineer, Database... ...champion of data governance by aligning... ...discipline. 9+ years of experience in data engineering... ..., such as Oracle, PostgreSQL, MS SQL... ...dynamic player in the federal government sector,...
Oracle
Local area
2 days per week
1 day per week
InDev
Washington DC
4 days ago
Data Engineer
...Data EngineerImagineeer is seeking... ...within DoD and federal healthcare environments... ...align with federal cybersecurity... ...automationData Governance and... ...to 10 years of experience in data engineering... ...Atlas, Alation, Informatica, or equivalent)... ...certifications (AWS, Azure, Oracle, IBM DB2, CDMP,...
Oracle
Local area
Work from home
Flexible hours
Imagineeer
Arlington, VA
5 days ago
Data Engineer IV
$110k - $155k
...Data Engineer IV ApplyLogic is... ...supporting a complex federal government customer in... ...U.S. Citizen with the ability to... ...Education, Experience, & Skills:... ...with SQL Server, Oracle, PostgreSQL, or... ...such as SSIS, Informatica, Talend, Azure... ...enterprise data warehouses, data lakes,...
Oracle
Contract work
Temporary work
ApplyLogic Consulting Group
Alexandria, VA
4 days ago
SME - Data Engineer
$128k - $270k
SME - Data Engineer Candidate must have a TS/SCI security clearance. Responsibilities Experience in designing and implementing large-scale data systems... ...but not limited to data warehouses, data lakes, and data... ...technologies. Experience with creating a preprocessed,...
DCCA
Bethesda, MD
4 days ago
Data Architect
...Data ArchitectVEA is an award winning... ...be challenged with assisting... ...processes, data governance models and... ...data store, data warehouse, and federated databases to support... ...must have experience with Databricks, Informatica, and... ...environments (e.g Oracle, Teradata, MySQL...
Oracle
Virtual Enterprise Architects
Washington DC
2 days ago
Data Analyst - U.S. Government Agency
...dedicated to partnering with government and community leaders... ....At Dexis, you will experience a corporate culture of... ...About the PositionThe Data Analyst will support a... ...Experience supporting a Federal Office of Inspector... ...the use of Salesforce, Oracle, Azure, Entra AD, Intune...
Oracle
Full time
For contractors
Work at office
Dexis Consulting Group
Washington DC
1 day ago
Data Analyst/Data Engineer
...is seeking a talented Data Analyst/Data Engineer... ...remote Department: Federal Government Type: Full Time Min. Experience: Experienced Security... ...Subject Matter Expert (SME) inputs) Obtain data through... ...of experience working with messy or semi-structured...
Full time
Contract work
Remote work
Ssg
Greenbelt, MD
7 hours ago
Data Analyst--------------Only US citizens and GC------Need Locals
...headquartered in Chantilly, VA with off-shore delivery... ...Business Intelligence, Data Management, SOA, BPM,... ...needs of our State and Government customers through... ...Three to six years of experience in SQL and PL/SQL along... ...Databases - particularly Oracle 11g, with Stored Procedure...
Oracle
Local area
Worldwide
USM Systems
Washington DC
4 days ago
Data Integration Engineer III
$105k - $135k
...for a talented Data Integration... ...supporting a complex Federal Government customer in... ...U.S. Citizen with the ability to... ...Education, Experience, & Skills: Required... ...SQL Server, Oracle, PostgreSQL,... ...experience with SSIS, Informatica, Talend, Azure... ...with data warehouses, data lakes,...
Oracle
Contract work
Temporary work
ApplyLogic Consulting Group, LLC
Alexandria, VA
2 days ago
Data Integration Engineer IV
$125k - $155k
...for a talented Data Integration... ...supporting a complex Federal Government customer in... ...U.S. Citizen with the ability to... ...Education, Experience, & Skills Bachelor... ...SQL Server, Oracle, PostgreSQL,... ...experience with SSIS, Informatica, Talend, Azure... ...data warehouses, data lakes, lakehouses...
Oracle
Contract work
Temporary work
ApplyLogic Consulting Group, LLC
Alexandria, VA
2 days ago
Enterprise Data Management Cloud Service Consultant
$86.4k - $176.2k
...DC At Accenture Federal Services, nothing... ...helping the US federal government make the nation... ...through hands‑on experience, certifications, industry... ...! The Work: The Oracle EDMCS Consultant... ...‑wide master‑data management (MDM) and... ...governance, and alignment with financial and...
Oracle
Live in
Work at office
Local area
Accenture-Federal-Services-2
Arlington, VA
2 days ago
Federal Lead Data Analyst
$71.2k - $166.1k
Federal Lead Data Analyst This role is based in our Arlington, VA officeWe... ...how health happens with technologies that support... ...human-centric healthcare experience powered by unified global... ...come to the right place. Oracle Health Government Services is seeking a skilled...
Oracle
Temporary work
Flexible hours
Oracle Corporation
Arlington, VA
3 days ago
Senior Data Engineer
...Overview Supports enterprise data management and planning... ...integration of data with business processes.... ...in a related field. Experience :• 8 years in strategic... ...SQL-based Databases (Oracle, SQL Server, PostgreSQL) ETL Tools (Informatica, Talend, SSIS) Microsoft...
Oracle
CSV-TAUREAN
Alexandria, VA
22 hours ago
Data/Systems Analyst (CONTRACT CONTINGENT)
...Enterprises, and Government Agencies of all sizes... ..., Transportation, Federal and State... ...Description• Engage with the Project Team and... ...ownership of assigned data and system... ...three years of direct experience is requiredb. A minimum... ...including: Oracle Federal Financials...
Oracle
Contract work
For contractors
Flexible hours
Prosidian Consultng
Washington DC
7 hours ago
Data Analytics Engineer
...Data Analytics Engineer We are seeking a... ...Engineer to support our Federal Government Customer with delivering secure,... ...week ~5+ years of experience ~ Experience with... ...Relational Databases (Oracle, PostgreSQL) ~... ...aggregation patterns (data warehouse, data mart, data...
Oracle
Remote work
1 day per week
Ryde Technologies
Arlington, VA
3 days ago
Data Engineer
$55 - $58 per hour
...Data Engineer 3 openings.... ...machine learning models with senior data scientist... ...years of relevant experience in analytics,... ...working in large data warehouse environments... ...Experience in using of Oracle SQL tools for data... ...Experience with Informatica, ETL, Databricks
Oracle
Local area
3B Staffing LLC
McLean, VA
3 days ago
Data Engineer (Analytics)
INTEGRITYOne Partners - Data Engineer (... ...mission. You'll work with dedicated team... ...that help federal law enforcement agencies... ...database experience in Oracle or Postgres ElasticSearch... ...such as data warehouse, data mart, data... ...Experience working in government or high-security...
Oracle
Full time
Monday to Friday
INTEGRITYOne Partners
Washington DC
4 days ago
Senior Data & AI Analyst, Finance Systems
$89k - $135.75k
...DescriptionSummaryThe Senior Data & AI Analyst,... ...migration for Oracle Fusion... ...conversion excellence with cutting-edge AI capabilities... ...strategies, and governance frameworks for... ...Required Skills & Experience)Education & ExperienceBachelor... ...FBDI, APIs, SSIS, Informatica, Alteryx), cloud...
Oracle
Permanent employment
Full time
Contract work
Work experience placement
Work at office
AeroVironment
Arlington, VA
4 days ago
Senior Data Engineer
$115k - $150k
...Washington D.C., with offices in London,... ...clients.As a Senior Data Engineer, you will... ...practices in data governance and security, and... ...including data lakes, warehouses, and real-time... ...Technical Skills & Experience:7+ years of... ...MySQL, PostgreSQL, Oracle).Proficiency in Python...
Oracle
Full time
Visa sponsorship
Insomniac Design
Washington DC
2 days ago
Data Engineer III
$95k - $130k
...Data Engineer IIIApplyLogic is a fast-... ...supporting a complex Federal Government customer in... ...be a U.S. Citizen with the ability to obtain... ...Education, Experience, & Skills:Bachelor... ...with SQL Server, Oracle, PostgreSQL, or other... ...such as SSIS, Informatica, Talend, Azure Data...
Oracle
Contract work
Temporary work
ApplyLogic Consulting Group
Alexandria, VA
4 days ago
Remote Senior Data Engineer
$115k - $130k
...(NASDAQ: CBNK) with over $3 billion... ...team, the Senior Data Engineer will... ...matter expert (SME) responsible for... ...strong data governance. The Senior Data... ...lake and data warehouse solutions, and... ...Minimum Education & Experience Bachelor’s... ...Spark, Talend, or Informatica. Hands-on experience...
Currently hiring
Remote work
GrabJobs
Washington DC
5 days ago
Data Engineer
Analytica is seeking a Data Engineer to support a key, long-term federal government client program and... ...for 3 years. We work with U.S. government clients... ...quantitative fields 5 years’ experience designing conceptual,... ...enterprise data warehouse modeling constructs and...
Flexible hours
ANALYTICA
Bethesda, MD
2 days ago
Python Data engineer
...Python Data Engineer Our client... ...first preference, with Plano TX as a... ...requires strong experience in data... ...Data Lake/Mart/Warehouse, Databases SQL/NoSQL (DB2, Oracle), Big Data Technologies... ...PySpark), ETL (Informatica), CDC (Attunity... ...protected by federal, state, or local...
Oracle
Work at office
Local area
ICONMA
McLean, VA
1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Oracle / Informatica Data Warehouse SME with Federal Government Experience. Be the first to apply!