Informatica IDMC Developer - Cloud Data Integration & API

Tata Consultancy Services; Charlotte (NC); On-site; USD 110,000 - 125,000; Full time

Benefits offered by this job

Discretionary Incentive

Medical Coverage

Parental Leave

Identity Protection

Certification Reimbursement

Vacation & Holidays

401K & Bonus

Job summary

Tata Consultancy Services seeks an experienced Data Integration Specialist to lead Informatica IDMC development and administration for cloud and hybrid environments. You will implement CDI/CAI/Mass Ingestion, data quality, and governance while collaborating with business analysts and architects.

The role emphasizes API-based integrations, SSIS maintenance, and production support in a capital markets context.

Qualifications

• BA/BS degree in Information Technology, Computer Science, Finance, or a related discipline.
• 5+ years of capital markets / primary markets deal execution experience preferred.
• Strong understanding of New Issue, Book Building, and Syndication workflows in Fixed Income and Equities.
• Experience providing desk-aligned production support in trading floor or capital markets environments.
• Excellent troubleshooting skills and ability to resolve critical production issues quickly.

Responsibilities

• Design, develop, and maintain data integration solutions using Informatica IDMC services (CDI, CAI, Mass Ingestion, Data Quality).
• Build scalable ETL/ELT pipelines for data extraction, transformation, and loading across multiple source/target systems.
• Integrate cloud and on-prem applications using Informatica IDMC and API-based integrations.
• Develop and optimize mappings, mapping tasks, taskflows, schedules, and reusable components.
• Collaborate with analysts, architects, and stakeholders to translate data requirements into technical solutions.
• Implement data quality, validation, reconciliation, and governance standards.
• Support Salesforce data integrations, migrations, synchronization, and master data management.
• Develop and maintain SSIS packages for data movement and legacy integrations.
• Troubleshoot production issues, perform root cause analysis, and implement durable fixes.
• Participate in code reviews, architecture discussions, release planning, and deployment activities.
• Ensure compliance with security, audit, and data protection standards.
• Prepare technical docs, design documents, and runbooks.

Skills

Informatica IDMC

Cloud Data Integration

Cloud Application Integration

Data Quality

Mass Ingestion Services

ETL/ELT Development

API Integrations

Data Warehousing Concepts

SQL and Performance Optimization

Salesforce Integration

Salesforce Objects

SOQL

SSIS

Data Migration

Data Conversion Projects

Education

BA/BS in Information Technology or Computer Science

Job description

Tata Consultancy Services seeks an experienced Data Integration Specialist to lead Informatica IDMC development and administration for cloud and hybrid environments. You will implement CDI/CAI/Mass Ingestion, data quality, and governance while collaborating with business analysts and architects.

The role emphasizes API-based integrations, SSIS maintenance, and production support in a capital markets context.