DQ Informatica Developer

Job title: IDQ Informatica Developer

Job Type: Contract W-2

Job Location: New York, New York- Hybrid - 3 days onsite

Must Have: Informatica PowerCenter and Intelligent Cloud Services (IICS)

A global bank is seeking a IDQ Informatica Developer to join their New York office.

Responsibilities:

• Design, implement, and maintain ETL processes using Informatica PowerCenter (PC), Informatica Cloud (IICS)
• Translate business requirements into technical specifications and data integration designs, including mappings, workflows, sessions, and parameterization.
• Develop and optimize data integration workflows to ingest, cleanse, transform, and load data from various sources into data warehouses, marts, and data lakes.
• Build and maintain reusable mappings, mapplets, transformations, and components to promote consistency and reduce maintenance effort.
• Implement error handling, data quality rules, data lineage, and auditing within ETL processes; monitor and resolve data issues in a timely manner.
• Configure and tune Informatica environments for performance, including partitioning, pushdown optimization, cache management, and session tuning.
• Develop and execute unit, integration, and regression tests; support UAT and production validation.
• Implement CI/CD pipelines for ETL artifacts (mappings, workflows, configurations) using version control and deployment automation.
• Maintain documentation for mappings, data flow diagrams, data lineage, and runbooks; ensure knowledge transfer to operations teams.

Required Qualifications:

• 7+ years of hands-on experience with Informatica PowerCenter; 2+ years with Informatica Intelligent Cloud Services (IICS) or similar cloud-based Informatica tools.
• Strong SQL knowledge and experience with relational databases (e.g., SQL Server, Sybase ASE).
• Experience designing and implementing complex ETL mappings, transformations, and workflows.
• Familiarity with data warehousing concepts, dimensional modeling, and data lake architectures.
• Understanding of data quality, data lineage, data governance, and metadata management.
• Experience with version control (Git or SVN) and CI/CD concepts for ETL artifacts.
• Excellent problem-solving, analytical, and debugging skills.
• Strong communication and collaboration skills; ability to translate business requirements into technical solutions.
• Ability to drive projects forward in a fast-paced environment

Preferred Qualifications:

• Experience with agile methodologies (Scrum/Kanban) and Jira/Confluence.
• Certification(s) in Informatica PowerCenter and/or IICS (e.g., Informatica Developer, PowerCenter Advanced