Consultant/Sr. Consultant - ETL IICS + Informatica MDM SaaS Developer

Fresh Gravity, Inc.; Pune District; On-site; INR 1,600,000 - 2,600,000; Full time

Job summary

Fresh Gravity, Inc. is seeking an experienced IICS/MDM engineer to design and maintain cloud data integration mappings, including ingestion into Informatica MDM SaaS and data egress to Snowflake.

You will configure MDM Hub, implement match/merge rules and survivorship, and resolve complex data-sync issues end-to-end across Oracle, Snowflake and Postgres sources. Collaboration with cross-functional teams is essential.

Qualifications

• Extensive hands-on experience with IICS / Informatica Cloud including CDI mappings and taskflows.
• Minimum 2 years Informatica MDM experience (SaaS/Business 360 preferred) with match/merge and survivorship.
• Strong SQL skills across Snowflake, Oracle and PostgreSQL; debugging transformations and reconciliations.
• Solid knowledge of Snowflake concepts: roles, warehouses, views, data sharing.
• Experience with REST APIs and JSON for diagnosing issues.
• Domain knowledge of customer master data (HCP/HCO); life sciences or pharma preferred.

Responsibilities

• Design, build and maintain IICS Cloud Data Integration mappings, taskflows, and ingestion to MDM SaaS and Snowflake.
• Support MDM Hub configuration: entity models, match/merge rules, cleanse and survivorship.
• Investigate and fix data-sync issues end-to-end across sources and downstream systems.
• Work from evidence: mapping SQL, field coverage, run history, and record counts at each hop.
• Monitor jobs, tune performance, handle reruns and incident follow-up.
• Move changes through DEV/UAT/PROD with promotion packages and rollback plans.
• Collaborate with R360 reference-data team to consume code lists.
• Document designs and mappings in Confluence; keep Jira updated.

Skills

IICS / Informatica Cloud

MDM (SaaS/Business 360)

SQL (Snowflake/Oracle/PostgreSQL)

Snowflake knowledge

CDC & incremental loads

REST APIs & JSON

Master data (HCP/HCO)

Tools

Power BI

Job description

Role Overview

You will build, run and improve the Informatica Intelligent Cloud Services (IICS) integrations behind master

data platforms: OneCustomer (HCP, HCO and Affiliation) and OneProduct. The work covers source-to-MDM

ingestion, MDM Hub configuration, and publish (egress) to Snowflake for downstream consumers such as

CRM, SFMC and analytics. You will work with business stewards, product owners and other engineers across

time zones.

Key Responsibilities

• Design, build and maintain IICS Cloud Data Integration mappings, mapping tasks and taskflows, covering ingestion into Informatica MDM SaaS (Business 360) and the egress layer to Snowflake.
• Support MDM Hub configuration: entity models, match/merge rules, cleanse and validation, crosswalks and survivorship.
• Investigate and fix data-sync issues end to end: source Operational Data (Oracle/Postgres) MDM Snowflake downstream. For example, a record missing downstream, a merge not reflected,or a date shifted by a day because of timezone or epoch handling.
• Work from evidence: mapping SQL, field coverage, job run history, and record counts at each hop.
• Monitor jobs, tune performance, and handle reruns, reconciliation and incident follow-up.
• Move changes through DEV UAT PROD with documented promotion packages, dependency checks and a rollback plan.
• Work with the R360 reference-data team to consume code lists (Snowflake data share or API) in your integrations.
• Document designs, source-to-target mappings, findings and runbooks in Confluence, and keep work current in Jira.

Skills & Experience we value :

• 45 years of hands-on IICS / Informatica Cloud: CDI mappings, taskflows, parameters, error handling and scheduling. PowerCenter experience is a plus.
• At least 2 years on Informatica MDM (SaaS/Business 360 preferred, or MDM Hub on-prem): match/merge, golden records, cross-references, trust and survivorship.
• Strong SQL (Snowflake, Oracle, PostgreSQL), including debugging transformations and reconciling counts.
• Working knowledge of Snowflake: roles, warehouses, views and data sharing.
• Data-integration patterns: CDC and incremental loads, idempotency, bulk vs. event publish, and timestamp/timezone handling.
• REST APIs and JSON, including reading API responses to diagnose issues.
• Domain knowledge of customer (HCP/HCO) or product master data. Life sciences or pharma experience is preferred.

Preferred :

• Experience with Veeva CRM, SFMC or other downstream consumers of MDM data.
• Exposure to reference data management (Informatica RDM / R360) and code-list governance.
• Python or shell scripting for validation and reconciliation.
• Power BI or other downstream reporting exposure. working-style prerequisites
• Agile / PI planning: comfortable with SAFe-style PI planning, story-pointed Jira work and weekly team meetings, and gives realistic estimates and status.
• Confluence as the system of record: documentation lives there, not in chat or personal drives.
• Access and security: works under SSO/IDS-based access with short-lived sessions (about 30 minutes idle). Handles credentials and tokens responsibly and never commits secrets or session values to code or config.
• Environment discipline: does not promote changes to PROD without UAT validation, an impact check and the required approvals.
• Evidence-first investigation: states findings with counts and proof at each hop, and distinguishes confirmed root causes from theories.
• Cross-geography collaboration: works with France, India, Hungary and Middle East teams, writes clear English, and keeps reliable overlap hours with CET.
• Ownership and communication: proactively raises risks and delays, closes the loop with stakeholders, and states decisions and recommendations instead of waiting for direction.
• Values alignment: Aim Higher, Act for Patients, Be Bold, Lead Together.

Good to have skillsets:

• Curious about root causes, not just workarounds.
• Writes things down so the next person does not start from scratch.
• Comfortable challenging a requirement when the data says otherwise.