Informatica IDMC developer

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

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