Looking for, Senior Informatica PowerCenter and Cloud IDMC - IICS Engineers || NYC NY ONSITE ( Must Local) at NYC, New York, USA |
Email: [email protected] |
From: Mayank Mer, Pivotal [email protected] Reply to: [email protected] "No Relocation || Need local to NY only || We need DL || INVESTMENT FIRM EXP" Title: Senior Informatica PowerCenter and Cloud IDMC / IICS Engineers Work Location: NYC NY ONSITE ( Must Local) Visa : USC / GC Only MUST COME FROM A MAJOR BANK or INVESTMENT FIRM (RECENT 4 YEARS) MUST BE A INFORMATICA POWERCENTER SME with IDMC, IICS, MDM and IDQ Skills Need: JOB ONE (ETL from Data Sources): MUST HAVE a minimum 10 years of experience working for American Companies in the US. MUST HAVE 3+ years (Out of the last 6 years) of recent experience working in a commercial Bank or Large Brokerage environment . Must have extensive experience with Informatica versions 8.1 - 10.1. Min 5 years of experience utilizing Informatica PowerCenter. Must have min of 3 years experience with Informatica IDQ (Required). Must have min of 3 years experience with Informatica MDM (Required). 5 years of data integration experience with 5+ years on Informatica platform. 3+ years experience on IICS (Informatica Intelligent Cloud Services) platform. Extensive experience Designing, developing, maintaining, and enhancing ETL utiliing PowerCenter. Develop and Optimie complex SQL queries to support the ETL process. Extensive experience applying Kimball design methodology for Data warehouse design. Extensive experience writing complex T-SQL for database performance tuning. Extensive experience developing Cloud IDMC / IICS Mapping, and mapping task using ODBC and API based data integration and design task flows. Extensive experience communicating with Informatica Global support and performance troubleshooting using PowerCenter or IDMC / IICS Framework. Experience with SQL Server, Oracle and DB2 DB's. Extensive experience developing ETL scripts using IICS to migrate data from Oracle / SQL Serveer and DB2 into Snoflake data lake. Experience converting SSIS jobs to IICS jobs. Experience working on SQL Server and Oracle DB. IICS, with API / Real Time integration, working experience for 1-2 years. 6+ years of technology project implementation experience JOB TWO (Data Management): 6+ years Master Data Management experience. Must have recent experience with all of the below: Expert Knowledge of Informatica MDM 10.x, ideally 10.3/10.4 End to end implementation experience of Information MDM 10.X product Recent experience in configuring real-time processes in Informatica MDM Recent experience in configuring batch processes in Informatica MDM Recent experience with E360 Design and Development Experience in configuring batch processes in Informatica MDM Experience with BE Services and real-time consumption and production Experience with Active Vos - Good to have Exposure to Informatica Data Quality IDQ 10.X Understanding how to integrate Informatica MDM and IDQ Knowledge of SOAP and REST API Good Understanding of Data models and Data Architecture. Thanks & Regards, Mayank Mer Technical Recruiter https://www.linkedin.com/in/mayank-mer-405972114/ Keywords: database green card New York |
[email protected] View all |
Thu Mar 21 03:09:00 UTC 2024 |