Urgent Requirement || Senior Informatica PowerCenter and Cloud IDMC -IICS Engineers || NYC, NY (Onsite) || 12+Months at NYC, New York, USA |
Email: [email protected] |
From: Suraj Prashar, Pivotal [email protected] Reply to: [email protected] Hi, Hope you are doing great!! Please find the requirement below, If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number (703) 570-8775 * (Ext. 232). Job Title: Senior Informatica PowerCenter and Cloud IDMC / IICS Engineers Location: NYC, NY (Onsite) Duration: 12+ Months Interview: Video Visa Type: USC/GC Local Or Nearby Only Job Description:- 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. Keywords: database green card New York |
[email protected] View all |
Thu Mar 21 03:30:00 UTC 2024 |