Software Engineer - IICS

Pivotree Solutions India; Mumbai; On-site; INR 1,800,000 - 4,200,000; Full time

Job summary

Pivotree Solutions India is seeking an experienced IICS Developer to design, build, and support data integration pipelines across cloud apps, databases, and data platforms. The role leverages AI tools under strict quality controls to ensure accurate data handling and reproducible results.

You will work with Informatica PowerCenter and IICS to ingest, transform, and load data into data warehouses and data lakes, collaborating with cross-functional teams and ensuring scalable, secure pipelines

Qualifications

• 3+ years hands-on experience with IICS CDI/CAI and data integration.
• 5+ years Informatica PowerCenter experience with mappings, workflows and sessions.
• Advanced SQL on Oracle and SQL Server; loading and performance tuning for Snowflake/Redshift/BigQuery.
• REST APIs and web services with JSON and XML; integrations with enterprise apps.
• Data warehousing and modeling including star schemas and SCD Types 1 and 2.
• Unix/Linux scripting; Python for validation and API work; SFTP/file processing.
• Git and IICS deployment across environments.
• AI-assisted development and QA processes; verify AI outputs against data.

Responsibilities

• Design, develop, and maintain Informatica PowerCenter and IICS solutions for data integration.
• Develop and optimize mappings, workflows, and ETL pipelines for data warehouses, data lakes, and operational systems.
• Build and support integration patterns including SCDs, delta loads, and near real-time processing.
• Build REST and web service integrations, CAI processes for real-time integrations with key apps.
• Install and configure connectors, write file-watching and transfer scripts (SFTP).
• Optimize SQL performance and cloud deployments on Snowflake, Redshift, BigQuery.
• Implement data quality, governance, lineage, and metadata management.
• Troubleshoot ETL and pipeline issues; validate AI-suggested fixes.
• Collaborate with architects and analysts to improve data architectures.
• Communicate status to management and stakeholders.

Skills

IICS CDI CAI

REST APIs

Advanced SQL

Python

Data warehousing

Tools

Informatica PowerCenter

IICS

Snowflake

Amazon Redshift

Google BigQuery

Oracle

SQL Server

Git

Job description

Job Summary

As a market leader in product data content solutions, Pivotree helps clients assess, implement, andrun best-of-breed applications for Master Data Management (MDM) and Product InformationManagement (PIM). We are looking for an IICS Developer who will design, build, and supportintegration pipelines that collect, transform, and manage product and enterprise data across cloudapplications, databases, and data platforms. This role uses AI tools as part of day-to-dayengineering work, under clear standards for quality, data handling, and review.

Responsibilities

• Design, develop, and maintain Informatica PowerCenter and Informatica Intelligent CloudServices (IICS) solutions that deliver scalable, secure, and high-performance enterprise dataintegration.
• Develop and optimize mappings, workflows, reusable transformations, expressions, storedprocedures, and ETL pipelines for ingesting, transforming, and loading data into datawarehouses, data lakes, and operational systems.
• Build and support complex integration patterns, including incremental and delta loads, SlowlyChanging Dimensions (SCD Types 1 and 2), star schema loads, and large-scale batch andnear-real-time processing.
• Build and maintain REST and web service integrations, service connectors, business services,and IICS Application Integration (CAI) processes and process objects for real-time integrationwith Salesforce, SAP, ServiceNow, Workday, and other on-premises and cloud platforms.
• Install and configure add-on connectors and drivers for IICS; build file-watching and file-transfer scripts (SFTP and similar) for scheduled and event-driven data exchange.
• Optimize SQL performance, database connectivity, task scheduling, and cloud-nativedeployments on Snowflake, Amazon Redshift, and Google BigQuery, using AI-generatedperformance recommendations only after validating them against execution plans and load metrics.
• Implement data quality checks, governance controls, metadata management, lineage, andimpact analysis to keep enterprise data accurate, compliant, and trusted.
• Troubleshoot ETL, integration, and pipeline issues, using AI-assisted root cause analysis toisolate performance bottlenecks, transformation errors, and data quality anomalies. Validateevery AI-suggested fix against logs, sample data, and execution plans before it reachesproduction.
• Use approved AI tools across the development lifecycle to draft and review mapping logic,SQL, test data, and technical documentation, and to summarize job logs. Follow Pivotheres AIusage policy at all times, including rules on client and customer data, and record where AIcontributed to each change.
• Contribute to AI-enabled data enrichment use cases, such as attribute extraction,categorization, and content normalization for PIM, as the project roadmap requires.
• Collaborate with data architects, business analysts, and cross-functional teams to designintegration architectures, document reusable patterns and guidelines for enterpriseapplications, and continuously improve data management processes.
• Communicate project status clearly to management and stakeholders.

Technical Skills

• IICS Cloud Data Integration (CDI) and Cloud Application Integration (CAI), 3+ years hands-on:mappings, mapping tasks, task flows, schedules, parameter files, transformations (Expression,Router, Filter, Lookup, Update Strategy, Union, Aggregator, Joiner, Sorter), CAI processes,service connectors, and process objects.
• Informatica PowerCenter, 5+ years hands-on: mappings, workflows, reusable transformations,stored procedures, and session tuning.
• Advanced SQL on Oracle and SQL Server: complex joins, analytic functions, query tuning, andDDL generation; plus Snowflake, Amazon Redshift, or Google BigQuery loading andperformance tuning (preferred).
• REST APIs and web services with JSON and XML payloads, including authentication, errorhandling, and integrations with Salesforce, SAP, ServiceNow, or Workday.
• Data warehousing and modeling: star schemas, SCD Types 1 and 2, incremental loads,conceptual, logical, and physical data models, and data quality and lineage tooling.
• File processing and scripting: flat files (CSV, delimited, XML), file-watching and SFTP transferscripts, Unix/Linux shell or DOS scripting, Python for validation and API work (preferred), andinstalling IICS add-on connectors and drivers.
• Version control and deployment: Git, IICS asset management, and promotion acrossdevelopment, test, and production environments.
• AI-assisted development: working fluency with an approved AI assistant for SQL, mappinglogic, scripts, and documentation; verifying AI output against sample data and execution plans;keeping client data out of unapproved tools; and building or supporting LLM-based pipelinesteps such as enrichment or classification with evaluation and cost monitoring (preferred).

Key Competencies

• Ability to learn new technology quickly and adapt to changes in tooling and platforms.
• Strong analytical and troubleshooting skills, with a systematic approach to root cause analysis.
• Clear written and verbal communication with technical and non-technical audiences.
• Commitment to documentation, reusable design patterns, and engineering best practices.
• Ownership of quality: willingness to challenge assumptions, including AI-generated ones,before they reach production.

Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.