Senior Informatica PowerCenter and Cloud IDMC / IICS Engineers

Client Needs: The client is looking for candidates with extensive experience in data management and ETL processes, particularly within the banking or large brokerage sector. They require expertise in various Informatica tools such as PowerCenter, IDQ, and MDM, as well as experience with cloud data integration platforms like IICS. The client seems to be working on a project related to data integration, data warehousing, and master data management. Type of Project: The project appears to involve ETL development, data warehousing, and master data management within the banking or large brokerage industry. It may also involve migration to cloud-based data solutions such as Snowflake and IICS. Required Skills for Candidates: For Job One (ETL from Data Sources): Minimum 10 years of experience working for American companies in the US Recent experience (3 years out of the last 6 years) in a commercial bank or large brokerage environment Extensive experience with Informatica tools (PowerCenter, IDQ, MDM) and versions 8.1 to 10.1 Proficiency in SQL, including complex query optimization Familiarity with Kimball design methodology for data warehousing Experience with database performance tuning for SQL Server, Oracle, and DB2 Knowledge of cloud-based data integration platforms such as IICS Experience in migrating data to Snowflake data lake Proficiency in converting SSIS jobs to IICS jobs Strong communication skills for liaising with Informatica global support Experience in technology project implementation For Job Two (Data Management): Minimum 6 years of master data management experience Expertise in Informatica MDM 10.x, ideally version 10.3/10.4 End-to-end implementation experience with Informatica MDM 10.x Recent experience in configuring real-time and batch processes in Informatica MDM Experience with E360 design and development Familiarity with BE services and real-time data consumption Exposure to Informatica Data Quality IDQ 10.x Understanding of integrating Informatica MDM and IDQ Knowledge of SOAP and REST APIs Strong understanding of data models and data architecture