Informatica IDMC developer

Job Description

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

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

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

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 is strongly required (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 communicatio n 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.

TCS Employee Benefits Summary

• 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, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $110,000 - $125,000 a year

Qualifications:

BACHELOR OF COMPUTER SCIENCE