Job Description
Designing and developing data integrations using Informatica Cloud(IICS) and Informatica PC.Well versed with all IICSDebug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologiesInvolved in complete end to end ETL project lifecycle.Good expertise in creating complex Taskflows, reusable components and user function.Experience in advanced concepts like partitioning, optimization, and performance tuning.Good knowledge in SQL and data analysis.Good knowledge in Snowflake, work with the development team to create technical designs, write code, and unit test new features. You will also be responsible for enterprise ETL jobs using Informatica PowerCenter.