IDMC ETL Developer - PowerCenter to IDMC Migration

Ekloud Data Labs; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

Ekloud Data Labs is seeking an ETL / IDMC Developer with strong hands-on experience in Informatica PowerCenter and IDMC/IICS. You will lead end-to-end migrations from PowerCenter to IDMC and design robust ETL/ELT solutions using CDI, CAI, and DQ.

Proficiency with REST APIs, JSON/XML payloads, API authentication, and Snowflake/Oracle SQL is required. Candidate should have UNIX/Linux scripting skills for automation and orchestration, plus experience loading data into cloud data warehouse

Qualifications

• 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 Cloud Data Integration (CDI) and related modules.
• Hands-on experience integrating data from REST APIs using Informatica IDMC/IICS REST V2 Connector or Web Services Connector.

Skills

Informatica PowerCenter

IDMC/IICS

ETL/ELT development

REST API integration

JSON/XML payloads

API authentication

Pagination handling

SQL development

Oracle

Snowflake

Query optimization

UNIX/Linux scripting

Cloud Data Warehouse

Tools

Informatica REST V2 Connector

Web Services Connector

Job description

Ekloud Data Labs is seeking an ETL / IDMC Developer with strong hands-on experience in Informatica PowerCenter and IDMC/IICS. You will lead end-to-end migrations from PowerCenter to IDMC and design robust ETL/ELT solutions using CDI, CAI, and DQ.

Proficiency with REST APIs, JSON/XML payloads, API authentication, and Snowflake/Oracle SQL is required. Candidate should have UNIX/Linux scripting skills for automation and orchestration, plus experience loading data into cloud data warehouse