Informatica Cloud Services

Key skills: Informatica Intelligent Cloud Services (IICS), Informatica Power Center, Databases: Snowflake, Oracle, Sql server

Job Summary:
Looking for Informatica Intelligent Cloud Services (IICS)

• Having Good experience in Informatica PowerCenter using various transformations, ETL Framework and Design/ Development
• Develop ETL Solutions using IICS Data Integration/ Application Integration handling large data volumes
• Knowledge in handling various source/target systems including XML/Flat files/Databases using PowerCenter/Informatica MFT/IICS File Ingestion.
• Experience in change data capture, Data warehousing
• Experience in handling admin and support activities of tickets/incidents
• Good understanding of Data Warehousing concept with hands on experience with slowly changing dimensions and fact tables.
• Understand the business requirement and propose informatica design solutions accordingly.
• Strong ETL knowledge who can develop the complex mapping as per given requirement.
• Develop design specifications, unit test plans, and handle the complex scenario.
• Advance knowledge of SQL query who can develop complex query Ability to work in a fast-paced environment and meet deadlines
• Excellent with SQL coding - performance optimization, table indexing, stored procedures, functions, data partition/distribution
• Informatica (Power Center) Experience with the business/data analysis, integration, quality controls and governance of golden source data management.
• Proficient in understanding business requirements.
• Good Experience in Snowflake and MS SQL.