IICS Data Integration Engineer

Pivotree

United States

Remote

USD 120,000 - 165,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Pivotree is seeking an IICS Developer to design, build, and support enterprise data integration pipelines across cloud apps, databases, and data platforms. The role emphasizes scalable, secure data integration using Informatica PowerCenter and IICS, with a focus on delta loads, SCDs, and real-time processing.

You will work on REST integrations with major platforms and implement data governance, quality checks, and metadata management.

Qualifications

  • 3+ years hands-on with IICS CDI/CAI, mappings, tasks, and schedules.
  • 5+ years with Informatica PowerCenter, mappings and sessions.
  • Advanced SQL on Oracle/SQL Server; knowledge of Snowflake/Redshift/BigQuery.
  • REST APIs and web services with JSON/XML payloads and major platforms.
  • Data warehousing modelling: star schemas, SCD types 1 and 2, incremental loads.
  • Unix/Linux scripting and Python for validation (preferred).

Responsibilities

  • Design, develop, and maintain Informatica PowerCenter and IICS solutions delivering scalable, secure data integration.
  • Develop and optimize mappings, workflows, transformations, and ETL pipelines for data warehouses and data lakes.
  • Build and maintain REST and web service integrations with Salesforce, SAP, ServiceNow, Workday and more.
  • Install and configure add-on connectors and drivers for IICS; create file-watching and transfer scripts.
  • Optimize performance and governance: data quality, lineage, and metadata management.
  • Collaborate with data architects and analysts to design reusable integration patterns.

Skills

IICS CDI
CAI processes
SQL analysis
REST APIs
Data modeling

Tools

Informatica PowerCenter
Snowflake
Redshift
BigQuery
Oracle SQL

Job description

Pivotree is seeking an IICS Developer to design, build, and support enterprise data integration pipelines across cloud apps, databases, and data platforms. The role emphasizes scalable, secure data integration using Informatica PowerCenter and IICS, with a focus on delta loads, SCDs, and real-time processing.

You will work on REST integrations with major platforms and implement data governance, quality checks, and metadata management.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Software Engineer - IICS
Software Engineer - IICS

Pivotree • United States

Remote
USD 120,000 - 165,000
Informatica Data Integration Engineer - PowerCenter/IICS
Informatica Data Integration Engineer - PowerCenter/IICS

Executive Staff Recruiters / ESR Healthcare • New Jersey

On-site
USD 110,000 - 150,000
Imformatica Lead
Imformatica Lead

Diligent Tec, Inc • Santa Ana (CA)

On-site
USD 110,000 - 160,000
Senior ETL Developer - Informatica PowerCenter & IICS
Senior ETL Developer - Informatica PowerCenter & IICS

Ethereum Technologies • Charlotte (NC)

On-site
USD 90,000 - 130,000
Data Analyst - IICS/PowerCenter
Data Analyst - IICS/PowerCenter

Golden Technology • Cincinnati (OH)

On-site
USD 70,000 - 90,000
IICS Lead: Cloud ETL Architect & Data Integration Leader
IICS Lead: Cloud ETL Architect & Data Integration Leader

TechDigital Group • Frisco (TX)

On-site
USD 80,000 - 120,000
Informatica ETL Engineer – PowerCenter & IICS
Informatica ETL Engineer – PowerCenter & IICS

Valiant Technologies LLC • Columbia (SC)

On-site
USD 110,000 - 150,000
IICS Lead
IICS Lead

TechDigital Group • Frisco (TX)

On-site
USD 80,000 - 120,000
Remote Informatica Developer (IICS) – Data Pipelines
Remote Informatica Developer (IICS) – Data Pipelines

Xideral • United States

Remote
USD 90,000 - 120,000
Life Insurance and Medical Insurance
Vacation premium
Paid Vacation Days
+1
Cloud Data Integration Lead (IICS CDI/CAI)
Cloud Data Integration Lead (IICS CDI/CAI)

Diligent Tec, Inc • Santa Ana (CA)

On-site
USD 110,000 - 160,000