MDM Informatica Developer

IT ENGAGEMENTS INC

New York, NY, United States

about 2 months ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

0 years minimum

Working hours

Regular working hours

Job source

careerjet.com

Tech stack

SAP Sybase Adaptive Server Enterprise Cloud Computing Continuous Integration Data Governance Data Integration Extract Transform Load (ETL) Data Warehousing Relational Databases Software Debugging Dimensional Modeling Meta-Data Management Microsoft SQL Server

+11 more

Regression Testing Cloud Services Runbook Subversion Informatica Powercenter Informatica Cloud Git Data Lakes Data Lineage Deployment Automation Software Version Control

Job description

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.
Stay current with Informatica product updates and best practices; propose and implement process improvements.

Requirements

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 Flexible and open to using and learning new tools and applications Must be able to work independently