远程 - 高级Oracle/Informatica数据仓库工程师 - 美国公民或绿卡持有者
Remote - Senior Oracle / Informatica Data Warehouse Engineer - US Citizenship or
客户：美国国税局
地点：远程
职位概述
Booker DiMaio 正在为一项新获得的美国国税局合同组建技术支援团队，支持 SharePoint Online 和 Microsoft 365。我们正在寻找一名高级 Oracle / Informatica 数据仓库工程师，提供高级技术专长，支持数据仓库开发、集成和性能。该职位将支持 Oracle 开发策略和涉及 Oracle、Informatica 和多个企业数据源的数据仓库活动。该专家将协助设计、排查、优化和维护数据结构和 ETL 流程，并与更广泛的工程技术团队合作处理数据集成和报告需求。
安全/资格要求
· 美国公民或合法永久居民，自作为 LPR 合法入境之日起在美国连续居住至少三年。
- 必须具备获得并维持 IRS 类似员工访问权限的资格，并成功通过所需的中等风险背景调查和安全审查流程。
- 选定后将启动背景调查和入职要求。
- 必须成功完成适用的 IRS 人员安全要求，包括指纹采集、安全培训和相关审查要求。
- IRS 类似员工访问权限需符合适用的 IRS 资格和适合性要求，并在整个合作期间保持有效。
必备资质
· 在支持美国联邦政府项目或联邦政府客户方面有实际专业经验。
- 强烈的 Oracle 数据库开发实践经验。
- 强烈的 PL/SQL 开发经验。
- 具有数据仓库架构和开发经验。
- 具有 Informatica 和 ETL 流程经验。
- 具有数据库性能、数据集成和故障排除经验。
- 能够在多学科团队中担任高级技术专家。
主要职责
· 为 Oracle 数据仓库开发及相关技术策略提供高级专业知识。
- 开发和支持 Oracle 数据库对象，包括 PL/SQL、数据视图、触发器和函数。
- 分析和排查数据库性能并优化数据库解决方案。
- 支持 Informatica ETL 流程和数据集成活动。
- 与来自 PPS/SAP、SharePoint、Power Platform、FPDS 等系统的数据合作
查看英文原文
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.
Originally posted on Himalayas