Senior Oracle / Informatica Data Warehouse Engineer

Job Description:

• 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 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

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
• Must successfully complete the required Moderate Risk background investigation and security screening process
• Must successfully complete applicable IRS personnel-security requirements, including fingerprinting, security training, and related screening requirements
• 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

Benefits:

• Great environment for exceptional growth opportunities