Title: Informatica Developer - Remote
Location: Remote
Length: Long term
Restriction: W2 or C2C
Description:
Interview Type: Webcam Interview Only *** Remote*** 37.5 hours per week *** need 3 references***
perform the conversion of workflow management implementation to access and trigger the new IICSbased Informatica Workflows.
Job Description:
MPORTANT READ FULLY:
Candidates MUST have participated as an implementer/developer/tester in AT LEAST TWO (2) IDMC and/or Informatica MDM SaaS (NOT EDC onprem) projects.
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 endoflife 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. There 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.
The EBI Application Developer will work closely with members of the EBI & Agency Stakeholders to confirm the migration of existing ETL workflows success. The EBI Application Developer will perform the conversion of workflow management implementation to access and trigger the new IICS based Informatica Workflows.
·Migration Expertise Indepth 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), and HL7 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.
Must safeguard and protect data in compliance withe stablished EBI Data Governance, any state, federal or industry regulations and standards.
Produces estimates of time and resources required to perform various tasks as part of a team
Required Skills:
Experience in Informatica IDMC product lineup and/or hands on experience with Informatica MDM SaaS 1 Years
Informatica Powercenter, IICS, EDC (MetaData Management), IDQ (Data Quality) on Linux 1 Years
Must have participated as implementer/developer/tester in at least (2) IDMC and/or Informatica MDM SaaS (NOT EDC onprem) projects
Experience in integrating external workflow management applications with Informatica IDMC using Batch processes, API calls, and message queues 2 Years
Release Management procedures, source code control (GitHub) and best practices 2 Years
Excellent communication skills are required for this role 2 Years
Highly Desired Skills:
Experience with Broadcom s CA Workload dSeries product