ETL / Informatica IDMC Developer

Key Skills & Experience - ETL / Informatica IDMC Developer:

* Strong hands-on experience with Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC/IICS).

Proven experience in at least one end-to-end migration project from Informatica PowerCenter to IDMC.

Expertise in designing, developing, and supporting ETL/ELT solutions using:
o Cloud Data Integration (CDI)

Mass Ingestion
Cloud Application Integration (CAI)
Data Quality (DQ)
Hands-on experience integrating data from REST APIs using Informatica IDMC/IICS REST V2 Connector or Web Services Connector.
Strong understanding of JSON/XML payloads, API authentication, pagination handling, and loading data into relational databases and cloud data warehouse platforms.

Excellent SQL development skills with experience in:
o Oracle

Snowflake
Query optimization and performance tuning
Strong experience in UNIX/Linux Shell Scripting for automation, orchestration, and support activities.