Logo for Booker DiMaio

Remote - Senior Oracle / Informatica Data Warehouse Engineer - US Citizenship or GC Required

Booker DiMaio

Role overview

Qualifications

  • Demonstrated professional experience supporting U.S. Federal Government programs
  • Strong hands-on Oracle database development experience
  • Strong PL/SQL development experience
  • Experience with data warehouse architecture and development

Responsibilities

  • Provide senior subject matter expertise for Oracle data warehouse development
  • 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

Key facts

  • Remote from: Oregon (USA)
  • Full time
  • Senior (5-10 years)
  • Data Warehouse Engineer
  • English

Hard skills

Other skills

  • Troubleshooting (Problem Solving)
  • Collaboration
  • Problem Solving

About the company

Booker DiMaio logo

Booker DiMaio

IT Services & IT Consulting

Booker DiMaio, Engineering Innovation & Transformation, is a high-tech engineering & software modernization firm in Maryland leading the IT industry with proven performance and innovative design, development, and integration services. We lead agile-based digital transformations delivering sleek, intuitive, user-focused solutions. CORE COMPETENCIES: TECHNOLOGY: Cloud Computing, Big Data Visualization, Analytics, DevSecOps, Cybersecurity, Health IT, IT Modernization, Infrastructure As a Service, Integration & Sustainment, Software Engineering, System Architecture OPERATIONS: Staff Augmentation, Program Management, Telecommunications, User Experience Design, Administrative, Contact Center Support, Security Operations Center, Technology Transformation, Technology Advisory, Research & Development, Rapid Prototyping TECHNOLOGY PORTFOLIO: Booker DiMaio provides access to a suite of technology solutions through our reseller network, delivering added value to national security missions and government transformation for defense, intelligence, and civilian customers. A few of our notable partners are AWS, Microsoft Azure, FedRAMP Cloud Solutions, SecuLore DIFFERENTIATORS: SPECIALIZED - Our team is specially hired for each project and has a combined 90+ years of specialized industry experience. DRIVEN - We deliver solutions that are based on an in-depth understanding of the industry and commitment to improving user experiences. COMPREHENSIVE - We offer a comprehensive suite of end-to-end Big Data solutions, including cloud platforms, software engineering, DevSecOps, cybersecurity, and much more. COMPLIANT - Our tailored solutions facilitate compliance with CMMC, NIST, and other strict regulatory requirements. EFFECTIVE - Our cross-functional team of industry experts will carry your mission-critical operations to success, increasing digital proficiency across the globe with modern software and technology solutions. Contact.us@bookerdimaio.com

Company details

Company typeSME
IndustryIT Services & IT Consulting
Company size11 - 50

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Client: Internal Revenue Service
Location: Remote

Position Overview
Booker DiMaio is building a technical support team for a newly awarded Internal Revenue Service contract supporting SharePoint Online and Microsoft 365. We are seeking a Senior Oracle / Informatica Data Warehouse Engineer to provide senior technical expertise supporting data warehouse development, integration, and performance. The role will support Oracle development strategies and data warehouse activities involving Oracle, Informatica, and multiple enterprise data sources. The SME will help design, troubleshoot, optimize, and maintain data structures and ETL workflows and work with the broader technical team on data integration and reporting needs.

Security / Eligibility Requirements
  • U.S. citizenship or Lawful Permanent Resident status with at least three consecutive years of U.S. residency from the date of legal entry as an LPR.
  • Must be eligible to obtain and maintain IRS staff-like access and successfully complete the required Moderate Risk background investigation and security screening process.
  • Background investigation and onboarding requirements will be initiated following selection.
  • Must successfully complete applicable IRS personnel-security requirements, including fingerprinting, security training, and related screening requirements.
  • IRS staff-like access is subject to applicable IRS eligibility and suitability requirements and must be maintained for the duration of the engagement.

Required 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.

Key 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.

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Data Warehouse Engineer Related jobs

Other jobs at Booker DiMaio

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.

  • remote jobs
  • Remote - Senior Oracle / Informatica Data Warehouse Engineer - US Citizenship or GC Required