Informatica IDMC Developer in Charlotte, NC (Fulltime, Onsite)

Informatica IDMC Developer

Charlotte, NC

Fulltime, Onsite

Must Have Technical/Functional Skills

Primary Skills: Informatica Intelligent Data Management Cloud (IDMC), Cloud Data Integration (CDI), Cloud Application Integration (CAI), Data Quality (CDQ), Mass Ingestion Services, ETL/ELT Development, API Integrations, Data Warehousing Concepts, SQL and Performance Optimization

Secondary Skills: Salesforce Integration, Salesforce Objects, SOQL, and Data Migration, Microsoft SQL Server Integration Services (SSIS), SQL Server Database Development and Data Migration and Data Conversion Projects

Roles & Responsibilities

Role Overview

o Informatica IDMC Development and Administration

o Cloud & Hybrid Data Integration Solutions

o Salesforce Data Integration and Migration

o SSIS Development and Legacy ETL Support

o Data Quality, Governance, and Validation

o API and Real-Time Integration Development

o Performance Optimization and Troubleshooting

o Technical Leadership, Mentoring, and Solution Architecture

o Production Support and Release Management

o Agile Delivery and Stakeholder Collaboration

Responsibilities Include:

o Design, develop, and maintain data integration solutions using Informatica IDMC services including Cloud Data Integration (CDI), Cloud Application Integration (CAI), Mass Ingestion, and Data Quality.

o Build scalable ETL/ELT pipelines for data extraction, transformation, and loading across multiple source and target systems.

o Integrate cloud and on-premises applications using Informatica IDMC and API-based integrations.

o Develop and optimize mappings, mapping tasks, taskflows, schedules, and reusable components.

o Work closely with business analysts, architects, and stakeholders to understand data requirements and translate them into technical solutions.

o Design and implement data quality, validation, reconciliation, and governance standards.

o Support Salesforce data integrations, migrations, synchronization, and master data management processes.

o Develop and maintain SSIS packages for data movement, transformation, and legacy integration requirements.

o Troubleshoot production issues, perform root cause analysis, and implement sustainable solutions.

o Participate in code reviews, architecture discussions, release planning, and deployment activities.

o Ensure compliance with organizational security, audit, and data protection standards.

o Prepare technical documentation, design documents, and operational runbooks.

Qualifications:

o BA or BS degree in Information Technology, Computer Science, Finance, or a related discipline.

o Knowledge and hands-on experience with Capital Markets / Primary Markets deal execution is strongly required (5+ years preferable).

o Strong understanding of New Issue, Book Building, and Syndication workflows in Fixed Income and Equities.

o Prior experience providing desk-aligned production support in a trading floor or capital markets environment.

o Excellent troubleshooting skills; ability to resolve critical production issues quickly under pressure.

o Strong communicatio n and relationship-building skills; able to interact confidently with front-office users.

o Knowledge of bond fundamentals and capital markets execution processes is mandatory.

o Ability to document workflows, create knowledge repositories, and provide effective training.

o Highly organized, detail-oriented, with the ability to manage multiple issues and requests simultaneously.

o Prior experience with vendor platforms for deal execution (e.g., Ipreo / Primary Portal / Dealogic) is a plus.