Software Engineer – IICS

This is a fully remote position, open to applicants in India.

📋 Description

• Design, develop, and maintain solutions utilizing Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS) for scalable, secure, and high-performance enterprise data integration.

• Create and enhance mappings, workflows, reusable transformations, expressions, stored procedures, and ETL pipelines.

• Ingest, transform, and load data into data warehouses, data lakes, and operational systems.

• Develop and support incremental and delta loads, SCD Types 1 and 2, star schema loads, and large-scale batch as well as near-real-time processing.

• Construct and maintain REST and web service integrations, service connectors, business services, and IICS Application Integration (CAI) processes and process objects.

• Integrate with Salesforce, SAP, ServiceNow, Workday, and other on-premises and cloud platforms.

• Install and configure IICS add-on connectors and drivers.

• Create file-watching and file-transfer scripts for scheduled and event-driven data exchanges.

• Optimize SQL performance, database connectivity, task scheduling, and cloud-native deployments on platforms such as Snowflake, Amazon Redshift, and Google BigQuery.

• Implement data quality checks, governance controls, metadata management, lineage tracking, and impact analysis.

• Troubleshoot ETL, integration, and pipeline issues, including performance bottlenecks, transformation errors, and data quality issues.

• Utilize approved AI tools to draft and review mapping logic, SQL, test data, and technical documentation, while summarizing job logs in line with Pivotree's AI usage policy.

• Document where AI contributed to each modification and assess AI-suggested corrections against logs, sample data, and execution plans prior to production.

• Contribute to AI-enabled PIM data enrichment use cases such as attribute extraction, categorization, and content normalization.

• Collaborate with data architects, business analysts, and cross-functional teams on integration architectures, reusable patterns, guidelines, and enhancements in data management.

• Communicate project status updates to management and stakeholders.

⛳️ Requirements

• A minimum of 3 years of hands-on experience with IICS Cloud Data Integration (CDI) and Cloud Application Integration (CAI), including mappings, mapping tasks, task flows, schedules, parameter files, transformations, CAI processes, service connectors, and process objects.

• At least 5 years of hands-on experience with Informatica PowerCenter, encompassing mappings, workflows, reusable transformations, stored procedures, and session tuning.

• Proficient in advanced SQL on Oracle and SQL Server, including complex joins, analytic functions, query tuning, and DDL generation.

• Experience with Snowflake, Amazon Redshift, or Google BigQuery regarding loading and performance tuning is preferred.

• Familiarity with REST APIs and web services utilizing JSON and XML payloads, including authentication and error management.

• Experience integrating systems like Salesforce, SAP, ServiceNow, or Workday.

• Knowledge of data warehousing and modeling concepts, including star schemas, SCD Types 1 and 2, incremental loads, as well as conceptual, logical, and physical data models.

• Experienced in data quality and lineage tooling.

• Proficient in processing flat files, including CSV, delimited, and XML formats.

• Experience with file-watching and SFTP transfer scripts.

• Unix/Linux shell or DOS scripting experience is required.

• Proficiency in Python for validation and API tasks is preferred.

• Experience installing IICS add-on connectors and drivers.

• Familiarity with Git, IICS asset management, and promotion across development, testing, and production environments.

• Working fluency with an approved AI assistant for SQL, mapping logic, scripts, and documentation.

• Capability to verify AI output against sample data and execution plans.

• Ability to ensure client data remains secure from unapproved tools.

• Experience in building or supporting LLM-based pipeline steps, such as enrichment or classification, along with evaluation and cost monitoring is preferred.

• Quick adaptability to new technologies and changes in tools and platforms.

• Strong analytical and troubleshooting skills, with a systematic approach to root cause analysis.

• Clear written and verbal communication skills aimed at both technical and non-technical audiences.

• Commitment to thorough documentation, reusable design patterns, and engineering best practices.

• Openness to challenge assumptions, including those generated by AI, before production.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health benefits including medical, dental, and vision coverage.

• Opportunities for professional development and career advancement.

• Flexible work hours and remote work options.

• Supportive and inclusive company culture.