MResult - IICS Developer - Informatica/SQL (6-12 yrs)

Job Description :

- Overall 8+ years of experience in development, maintenance, and enhancement experience in the Informatica technology stack.

- Extensive technical experience Complex SQL queries in SQL Server.

- 3 Years exp in IICS (Informatica Intelligent Cloud Services), Snowflake, Strong SQL Skills

- Experience working in Azure technologies like Data Verse, ADF, ADLS, Power Platform, Synapse etc.

- Should have strong experience in all phases of the project life cycle from Requirements gathering to implementation

- Should have expertise in extracting and loading data from source/target systems like

Snowflake, Oracle SQL, flat files, XML sources, etc.

- Experienced in using transformations like Expression, Router, Filter, Lookup, Hierarchy

Builder, Hierarchy Parser, Business Service, Update Strategy, Union, Joiner and Aggregator

- Strong technical experience building data integration processes by constructing mappings, mapping tasks, task flows, schedules, and parameter files

- Experienced in developing Data Integration mappings using REST APIs and configuring swagger files and rest connections

- Experienced with performance optimization, error handling, debugging, and monitoring

- Experienced in writing complex SQL queries and knowledge of SQL Analytical functions