Overview
On Site
$80 - $105
Contract - Independent
Contract - W2
No Travel Required
Skills
ETL processes
ETL
Informatica MDM
Master Data Management
PowerCenter
SQL
data integration
performance tuning
Data Management
Informatica
tuning
Job Details
Join our team in NYC as a Senior Informatica PowerCenter and Cloud IDMC / IICS Engineering Consultant.
We are seeking a highly experienced Senior Informatica PowerCenter and Cloud IDMC / IICS Engineer to join our team onsite in NYC.
The ideal candidate will have:
A minimum of 10 years of experience working for American companies in the US, with at least 3+ years of recent experience in a commercial banking or large brokerage environment.
Essential skills include extensive experience with Informatica versions 8.1 - 10.1, a minimum of 5 years utilizing Informatica PowerCenter, and at least 3 years of experience with Informatica IDQ.
Additionally, candidates should possess 5+ years of data integration experience with a focus on the Informatica platform and at least 3 years of experience with IICS (Informatica Intelligent Cloud Services).
Strong proficiency in designing, developing, maintaining, and enhancing ETL processes using PowerCenter is required, along with the ability to develop and optimize complex SQL queries. Experience with Kimball design methodology, database performance tuning, and cloud-based data integration using IDMC / IICS Mapping is also essential.
The role involves collaborating with Informatica Global support for performance troubleshooting and communicating effectively within the team.
Experience with SQL Server, Oracle, and DB2 databases, as well as migrating data into Snowflake data lake using IICS, is highly preferred.
Candidates should have experience converting SSIS jobs to IICS jobs and possess 1-2 years of working experience with IICS API / Real-Time integration.
Additionally, the candidate should have a track record of successful technology project implementations.
MDM Experience Required:
In addition to the above requirements, candidates must have at least 6 years of Master Data Management experience. Recent experience with Informatica MDM 10.x, ideally 10.3/10.4, and end-to-end implementation experience of Informatica MDM 10.X product is mandatory.