Informatica Integration Consultant (Part-Time, Ad Hoc)

Job Description

Job Title: Informatica Integration Consultant (Part-Time, Ad Hoc)

Location: Remote

Rate: $60–$70/hour

Contract Length: ~40 hours total (with potential for additional support)

Start Date: ASAP

Contract Type: 1099

Position Summary

We are seeking an experienced Informatica Integration Consultant to provide part-time, ad hoc support for a client’s internal team. A primary objective of this engagement is to support a CMS program involving credit card and e-commerce payment integrations, where Informatica is being used to manage and move transactional data between systems.

The consultant will focus on debugging, tuning, and enhancing Informatica workflows, particularly those supporting CMS, payment processing, and downstream reporting or operational systems. While Salesforce experience is a plus, the greatest value lies in deep Informatica expertise combined with experience supporting e-commerce, payment processing, and transactional data integrations. Familiarity with Sage 500 ERP is a strong bonus, but not a core requirement.

This is an ideal opportunity for someone who enjoys flexible engagements, hands-on problem solving, and advising internal teams on complex integration challenges.

Key Responsibilities

Provide on-demand technical support for Informatica workflows, with a strong focus on debugging, performance optimization, and data reliability

Support CMS-related integration work, including credit card and e-commerce payment data flows

Assist with diagnosing and resolving issues related to transactional data movement, transformations, and system handoffs

Support and coach internal staff on integration best practices related to CMS, payment processing, and adjacent systems

Assist in developing, validating, and stabilizing data flows between Informatica and connected platforms (CMS, payment gateways, Salesforce, Sage 500 ERP, etc.)

Troubleshoot data quality, latency, reconciliation, and error-handling issues

Provide advisory input to improve the scalability, reliability, and maintainability of integration components

Document findings, recommendations, and solutions for repeatable use by internal teams

Preferred Qualifications

5+ years of hands-on experience with Informatica IICS

Proven ability to debug and optimize ETL workflows in real-time or near-real-time environments

Experience supporting e-commerce platforms, CMS integrations, or payment/credit card processing workflows

Familiarity with Salesforce integrations or CRM data flows is a plus

Experience working with Sage 500 ERP is highly desirable but not required

Strong understanding of data movement, transformation logic, and system-to-system integrations

Ability to work independently while collaborating effectively with remote teams

Strong documentation, communication, and advisory skills

U.S.-based only. No visa sponsorships or C2C accepted

Part-time

Fully remote