* 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
Robust experience in UNIX/Linux Shell Scripting for automation, orchestration, and support activities.