Blog

Primary Skills

:INFORMATICA MDM , ORACLE DB , T-SQL , API , SOAP , DATA MODELS , ODBC , SQL SERVER , DATA ARCHITECTURE

Job Description

:

• 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 large commercial ‘Bank or 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 intergration 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

Task-2 (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.