Oracle Informatica Data Warehouse SME with Federal Government Experience

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.

Booker DiMaio is seeking an experiencedOracle / Informatica Data Warehouse SMEto support a technology initiative with theU.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 withOracle PL/SQL Informatica and enterprise data warehouse environments along with the ability to troubleshoot complex data and integration issues.

• Provide subject matter expertise supporting an enterpriseOracle data warehouseenvironment.
• Develop and maintain Oracle database objects including tables views stored procedures functions triggers and queries.
• Develop and optimizePL/SQLsolutions and Oracle database performance.
• Develop maintain and troubleshootInformatica 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.

• Strong hands-on experience withOracle database development.
• StrongPL/SQLdevelopment experience.
• Experience developing Oracle views functions triggers queries and related database objects.
• Strong experience withInformatica and ETL development.
• Experience designing developing maintaining and troubleshooting ETL workflows.
• Experience working with enterprisedata 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.

• Federal government experience.
• Experience supporting theIRS or Department of the Treasury.
• Experience with procurement or acquisition data.
• Experience integrating Oracle withSharePoint Online and Microsoft Power Platform.
• Experience withPower BIor enterprise reporting environments.
• Experience working with SAP data sources.
• Experience with external government data sources such as FPDS or USAspending.
• Experience providing technical training and knowledge transfer.
• Experience working in environments with federal security governance and compliance requirements.