Sub Con- ETL / Informatica IDMC Developer (26-05900) -

SRF ID

153338

Please find below the JD for the ETL position.

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.