Key Skills & Experience
- ETL / Informatica IDMC Developer:
* Solid 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.