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.
Salary Range: $110,000 - $125,000 a year
