Informatica Integration Consultant (Part-Time, Ad Hoc)

B

Blue Star Partners LLC

Informatica Integration Consultant (Part-Time, Ad Hoc)

Columbus, OH
Part Time
Paid
  • Responsibilities

    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