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

VnNJWXJMYllkNDZVQ3NNOEx6NzVBbXc9
  • 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

University of Alaska Fairbanks

Esports Student Assistant — Alaska Esports Job at University of Alaska Fairbanks

 ...Alaska Esports is UAFs competitive collegiate esports program: seven teams, three varsity, and a community built around the idea that this program should feel like home. We run campus tournaments, public gaming events, and live broadcasts out of the Wood Center. We... 

Sunridge Hotel Group

Night Auditor (Overnight) - Best Western Downtown Phoenix Job at Sunridge Hotel Group

This is a weekend overnight position, covering 11pm-7am on Saturday and Sunday.SUMMARY: Accommodates guests of the hotel and Night Audit duties by performing the following:ESSENTIAL FUNCTIONS:Greets, registers, and assigns rooms to guestsHandles confidential information...

Openkyber

Creative Project Manager Job at Openkyber

 ...Description We are looking for a Creative Project Manager to join a manufacturing organization in Irvine, California on a Contract basis. This role combines hands-on content and administrative support with growing responsibility for coordinating timelines, teams, and... 

Muscatine Power and Water

2027 Summer Internships Job at Muscatine Power and Water

Welcome to an exciting opportunity to join our team as a Summer 2027 Intern! At Muscatine Power and Water, we believe in nurturing talent...  ...-on experience to the next generation of professionals. Our internship program is designed to offer you an immersive learning... 

TekWissen LLC

Network Engineer Job at TekWissen LLC

 ...Engineering, and Talent, with advanced capabilities in AI and Data, Industry and Process, and Technology. Job Title: Network Engineer Location: Huntsville, AL Duration: 12 Months Job Type: Temporary Assignment Work Type: Onsite Role snapshot...