EBI (Informatica) Data Warehouse Specialist

Job Title: EBI (Informatica) Data Warehouse Specialist

Job ID: 24-05068

Location: Remote

Duration: 12 Months contract

The Data Warehousing Specialist (DWS) designs, implements, and supports data warehousing initiatives.

POSITION DETAILS:

Enterprise Business Intelligence Solution (EBI) has for the last several years leveraged the Informatica PowerCenter application to perform a larger amount of data movement. This tool provides the capabilities of Extraction, Transformation and Loading (ETL) of data from any source to any target for any agency in the enterprise. EBI has learned that Information has scheduled the PowerCenter product line for end-of-life within the next few years. Informatica has a cloud-based replacement solution, and this project is the effort to migration all existing ETL workflows to that new solution. The resource selected for this role will support the integrity of migrating ETL workflows. This resource will utilize the Informatica Migration Toolset, correct any inconsistencies from automated migration and manually migrate any ETL workflows that the Toolset cannot accomplish.

Responsibilities include:

The EBI Data Warehouse Specialist will work closely with members of the EBI & Agency Stakeholders to confirm the migration of existing ETL workflows success. The EBI Data Warehouse Specialist will work perform the conversion of workflow management implementation to access and trigger the new IICS-based Informatica Workflows.

• Migration Expertise- In-depth knowledge of migration strategies, tools, and best practices for transitioning from PowerCenter to IDMC.
• Analyze EBI data and transformations and perform data validation and integration testing.
• Recommend and implement performance improvements of ETLs and optimization of scheduling efficiencies.
• Proficient with Informatica PowerCenter, EDC (Metadata Management), IDQ (Data Quality), Informatica’s Intelligent Cloud Services (IICS), Informatica’s Intelligent Data Management Cloud (IDMC), andHL7 Library on Linux.
• Proficient with workflow automation concepts and the tool CA Workload Automation DE.
• Monitoring and support of Informatica workflows in the EBI and effectively communicate with SMEs regarding failures, outages and/or delays in downstream processing as needed.
• Research and troubleshoot operational and performance issues on production systems.
• Work as directed by DoIT management to apply DoIT coding standards, Release Management procedures, source code control(GitHub) and best practices.