Consultant-ETL-IICS

Fresh Gravity, Inc.; India; Hybrid; INR 900,000 - 1,400,000; Full time

Benefits offered by this job

Health coverage

Flexible & hybrid work

Certifications budget

Paid time off

Parental leave

Global mobility opportunities

Job summary

Fresh Gravity, Inc. is hiring a senior Data Integration Engineer to design, build and optimize Informatica Cloud (IICS) integrations behind master data platforms (OneCustomer, OneProduct). You will ingest data, configure MDM, and publish to Snowflake for downstream systems such as CRM and analytics.

You will collaborate with business stewards and global teams to ensure accurate, timely data flows. The role emphasizes evidence-based troubleshooting, end-to-end data lineage, and robust promotion

Qualifications

• 4–5 years hands-on IICS / Informatica Cloud experience including CDI mappings and taskflows.
• At least 2 years on Informatica MDM (SaaS/Business 360 preferred).
• Strong SQL across Snowflake, Oracle and PostgreSQL.
• Working knowledge of Snowflake: roles, warehouses, views and data sharing.
• Data‑integration patterns: CDC and incremental loads, idempotency, timezone handling.
• REST APIs and JSON for diagnosing issues.
• Domain knowledge of customer master data (HCP/HCO) or product master data.

Responsibilities

• Design, build and maintain IICS Cloud Data Integration mappings, mapping tasks and taskflows.
• Support MDM Hub configuration: entity models, match/merge rules, cleanse and validation, survivorship.
• Investigate and fix data-sync issues end to end: source → Operational Data → MDM → Snowflake.
• Work from evidence: mapping SQL, 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 promotion packages and rollback plan.
• Work with the R360 reference-data team to consume code lists via Snowflake data share or API.
• Document designs, source-to-target mappings, findings and runbooks in Confluence, and Jira.

Skills

IICS / Informatica Cloud

Informatica MDM

SQL (Snowflake, Oracle, PostgreSQL)

Snowflake knowledge

Data integration patterns

REST APIs & JSON

Customer/master data domain knowledge

Tools

Informatica Cloud (IICS) CDI

Informatica MDM

Snowflake

Oracle

PostgreSQL

PowerCenter

Job description

About the role

Scroll to read the full description

Location

India-Hybrid

Capability

Data Management

Sub-capability

Data Management

Openings

2

Role summary

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.

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.

Required skills

• 4–5 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 on 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.

Nice‑to‑have traits

• 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.

What we offer everyone at Fresh Gravity

Health & medical cover

Comprehensive insurance for you and your family.

Flexible & hybrid work

Work where you do your best, with real flexibility.

Learning & certifications

Budget and time for cloud, data, and AI certifications.

Generous time off

Paid leave, holidays, and time to recharge.

Parental leave and wellbeing support when it matters.

Global projects & mobility

Work with leading clients and grow across teams.

Engineered for outcomes. Built for the people who build them.

At Fresh Gravity you'll do the best work of your career on problems that matter — helping the world's leading organizations turn complex data into real outcomes. We productize, we don't just pilot.

Solve hard data, AI, and digital problems end-to-end for global clients.

Grow fast

Learn across data management, engineering, AI, integration, and digital — with mentors who've done it.

Real ownership

Small teams, big impact, and the autonomy to drive outcomes you're proud of.

A team that has your back

A collaborative, people-first culture that rewards curiosity and craft.