Informatica Cloud(IICS) Developer

"Candidate should have 12-14 years of experience

Designing and developing data integrations using Informatica Cloud(IICS) and Informatica PC.

Well versed with all IICS Client Components.

Debug 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 methodologies

Involved 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 in Agile development methodology.

Monitor all performance metrics for various production systems and identify root cause for all technical issues and recommend solutions.

IT experience in Analysis, Design, Development, Implementation, Testing of Data Warehousing and Data Integration Solutions using IICS

Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).

Creates ETL Mappings, Mapplets, Workflows, Work