Senior Oracle / Informatica Data Warehouse Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Deliver expert-level knowledge in Oracle data warehouse development and associated technical strategies.

• Design and maintain Oracle database elements, such as PL/SQL, data views, triggers, and functions.

• Examine and resolve database performance issues while enhancing database solutions.

• Assist with Informatica ETL processes and data integration tasks.

• Collaborate with data from sources including PPS/SAP, SharePoint, Power Platform, FPDS, SAM.gov, USAspending, and others as needed.

• Facilitate data ingestion, transformation, integration, and ensure availability for downstream reporting and analytics.

• Work alongside Power BI, Power Platform, SharePoint, and project management colleagues to develop integrated solutions.

• Offer technical troubleshooting, recommendations, and thorough documentation.

⛳️ Requirements

• Must be a U.S. citizen or a Lawful Permanent Resident with at least three consecutive years of U.S. residency since legal entry as an LPR.

• Must be qualified to acquire and retain IRS staff-like access.

• Must successfully undergo the necessary Moderate Risk background check and security screening process.

• Must complete all relevant IRS personnel-security requirements, including fingerprinting, security training, and other related screenings.

• Proven professional experience in supporting U.S. Federal Government initiatives or federal government clients.

• Extensive hands-on experience in Oracle database development.

• Strong proficiency in PL/SQL development.

• Familiarity with data warehouse architecture and development practices.

• Experience with Informatica and ETL methodologies.

• Knowledge of database performance optimization, data integration, and troubleshooting techniques.

• Capability to function as a senior technical Subject Matter Expert within a multidisciplinary team.

🏝️ Benefits

• Excellent environment that fosters exceptional growth opportunities.