Data Integration Lead Job For 9-12 Year Exp In Hexaware Chennai, India – 3935362

Job Description
. Good working knowledge of IICS – Informatica Cloud, Informatica designer transformations like Source Qualifier , Dynamic and Static Lookups , connected and Unconnected lookups , Expression , Filter , Router , Joiner , Normalizer and Update Strategy transformation.
. Solid hands-on development experience in Informatica PowerCenter – usage of reusable transformations, aggregates, lookups, caches, performance tuning, joiners, rank, router, update strategy etc.
. Strong Knowledge on Snowflake
. Experience in working in Data Warehousing – Must have knowledge of Data Warehousing concepts – SCD1, SCD2 etc.
. Troubleshoot issues and identify bottlenecks in existing data workflows.
. Provides performance tuning insight and create reusable objects and templates.
. Should be strong in migrating object process from Lower Environment to higher Environment.
. Should be strong in scheduling process of the workflows, tasks and mappings.
. Basic understanding of Informatica Administration
. Strong development skills in SQL. Having knowledge on AWS, HVR would be an added advantage