EBI (Informatica) Data Warehouse Specialist Job at Sunrise Systems, Edison, NJ

  • Sunrise Systems
  • Edison, NJ

Job Description

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.

Job Tags

Contract work, Remote work

Similar Jobs

Data Concepts

Part-Time Accounts Payable Specialist (JuniorMid Level) Job at Data Concepts

 ...Part-Time Accounts Payable Specialist (JuniorMid Level) Industry: IT Services We are an established IT services organization seeking a detail-oriented Accounts Payable Specialist to support our finance function on a part-time basis . This role is well suited... 

Core-Mark

Class A Delivery Driver Job at Core-Mark

 ...system. Safe and inclusive working environment, including culture of rewards, recognition, and respect. Position Details: ~ Monday - Friday ~ Dispatch time: 4:00AM ~$90,000 + a year Position Purpose: Food and food service delivery Drivers fulfill a... 

Facility Compliance Services LLC

Fire Alarm Technician Job at Facility Compliance Services LLC

 ...Altus Fire & Life Safety is a full-service fire and life safety services platform. We offer a complete suite of solutions, from the design, engineering, installation, and servicing of state-of-the-art fire and life safety systems to training, consulting, crisis management... 

CLASSIC CARPENTRY & FINISHINGS INC

Cabinetmaker Job at CLASSIC CARPENTRY & FINISHINGS INC

Job Description Job Description Custom Commercial millwork shop is seeking full time experienced cabinet makers. Must be self starter and able to read blue prints with experience in laminates and solid surface. Must be willing to work overtime, have own hand tools ...

Intellinum

Staff Accountant ( Hybrid ) Job at Intellinum

 ...Job Title: Staff Accountant Employment Type: Full Time (US CST Time zone) Years Experience : 5-7 years Job Summary: We...  ...standards Requirements & Skills Bachelor's degree in finance or accounting and at least five years of related experience in...