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