ETL / Informatica IDMC Developer

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

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:
  • 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:
  • Oracle
  • Snowflake
  • Query optimization and performance tuning
• Strong experience in UNIX/Linux Shell Scripting for automation, orchestration, and support activities.