Informatica IDMC developer

About the role

Informatica IDMC Development and Administration, Cloud & Hybrid Data Integration Solutions, Salesforce Data Integration and Migration, SSIS Development and Legacy ETL Support, Data Quality, Governance, and Validation, API and Real-Time Integration Development, Performance Optimization and Troubleshooting, Technical Leadership, Mentoring, and Solution Architecture, Production Support and Release Management, Agile Delivery and Stakeholder Collaboration.

Responsibilities

• 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.
• Build scalable ETL/ELT pipelines for data extraction, transformation, and loading across multiple source and target systems.
• Integrate cloud and on-premises applications using Informatica IDMC and API-based integrations.
• Develop and optimize mappings, mapping tasks, taskflows, schedules, and reusable components.
• Work closely with business analysts, architects, and stakeholders to understand data requirements and translate them into technical solutions.
• Design and implement data quality, validation, reconciliation, and governance standards.
• Support Salesforce data integrations, migrations, synchronization, and master data management processes.
• Develop and maintain SSIS packages for data movement, transformation, and legacy integration requirements.
• Troubleshoot production issues, perform root cause analysis, and implement sustainable solutions.
• Participate in code reviews, architecture discussions, release planning, and deployment activities.
• Ensure compliance with organizational security, audit, and data protection standards.
• Prepare technical documentation, design documents, and operational runbooks.

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

Qualifications

• BA or BS degree in Information Technology, Computer Science, Finance, or a related discipline.
• Knowledge and hands-on experience with Capital Markets / Primary Markets deal execution (5+ years preferable).
• Strong understanding of New Issue, Book Building, and Syndication workflows in Fixed Income and Equities.
• Prior experience providing desk-aligned production support in a trading floor or capital markets environment.
• Excellent troubleshooting skills; ability to resolve critical production issues quickly under pressure.
• Strong communication and relationship-building skills; able to interact confidently with front-office users.
• Knowledge of bond fundamentals and capital markets execution processes is mandatory.
• Ability to document workflows, create knowledge repositories, and provide effective training.
• Highly organized, detail-oriented, with the ability to manage multiple issues and requests simultaneously.
• Prior experience with vendor platforms for deal execution (e.g., Ipreo / Primary Portal / Dealogic) is a plus.
• Bachelor of Computer Science (or equivalent).

Benefits

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation,