Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

SUSAVAN GHANTI

Kolkata

Summary

Seasoned Senior Data Engineer at QuantiPhi Analytics with 5 years of expertise in Master Data Management (MDM), Data Integration, Data Modeling, and Data Quality. Proven track record in architecting scalable MDM solutions across Insurance, Logistics, CRM, and E-Commerce using Informatica IDMC, MDM, GCP, and Snowflake. Skilled in designing enterprise-grade data architectures and implementing robust frameworks.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

QuantiPhi Analytics
Bangalore
03.2024 - Current
  • Designed and delivered MDM-driven medallion architecture (Bronze/Silver/Gold) in Snowflake using Informatica IDMC SaaS.
  • Created ER Models in ERWin and Fact/Dimension Models for Data Modelling.
  • Built pipelines in CDI with Cloud Data Quality rules for standardization and enrichment.
  • Developed complex mappings, mapping tasks, and taskflows in IICS.
  • Configured match/merge and survivorship rules for unified customer view.
  • Integrated real-time data with downstream CRM and claims systems via CAI APIs.
  • Configured trust and validation rules in IDMC MDM SaaS.
  • Designed/tuned match rules (fuzzy, exact, probabilistic) across millions of records.
  • Implemented merge with stewardship approvals, maintaining golden records.
  • Used Apache Airflow to orchestrate workflows across layers.
  • Automated ingestion using Snowpipe, Streams, Dynamic Tables, SPs, and Tasks.
  • Created DAG-based orchestration in Snowflake with customized tasks.
  • Implemented Lambda views for real-time warehouse optimization.

Senior MDM Analyst

Ernst & Young GDS LLP
Bangalore
11.2022 - 03.2024
  • Developed a Customer MDM SaaS Solution in IDMC from scratch for a multinational building material company.
  • Configured relationship, hierarchy, and match-merge for domains.
  • Customized OOTB workflows in Cloud Application Integration.
  • Created ETL transformations, mappings, and taskflows in CDI.
  • Developed reference tables in Reference 360 and populated them via Batch/API/manual.
  • Established user roles, groups, and attribute-level security.
  • Implemented Codelists and Crosswalks in Reference 360.
  • Created profiling and rule specs in CDQ for email validation.
  • Developed Unit Test cases for custom workflows.
  • Configured DaaS service for real-time address validation.
  • Tools: IDMC, Data Integration, Profiling, Application Integration, Informatica MDM SaaS, Business360, Customer360, Reference360.

Associate Consultant

Capgemini India
Kolkata
10.2020 - 11.2022
  • Implemented Customer MDM for KPMG LLP.
  • Followed Agile methodology with daily scrums.
  • Performed extensive match rule tuning.
  • Built Business Entities, Views, Transformations, Hierarchies from scratch.
  • Developed Tasks, Triggers, Layouts, Extensions, High Charts, and C360 UI visualizations.
  • Customized workflows and approvals in Active Vos.
  • Developed Queries, Packages, and Message Triggers.
  • Hands-on with Postman API and SOAP UI.
  • Implemented MDM Hub User Exits and External Calls.
  • Migrated code changes across environments.
  • Tools: Informatica MDM Hub, Provisioning Tool, Active Vos, IDQ, Oracle SQL, Tiboli, Eclipse, Postman.

Education

Bachelor of Engineering -

Jadavpur University
Kolkata
01.2020

Skills

  • Programming Language - Python,Java
  • Data Modelling
  • SQL and Databases - Snowflake, SQL Server, BigQuery, CloudSQL, Oracle
  • ETL & Informatica - IICS , IDMC , CDI, CAI
  • MDM - IDMC SaaS, Informatica Multidomain MDM Hub, Reltio
  • ELT - DBT,
  • CI/CD - Git
  • VERSIONING - Jira, Confluence
  • GCP Services - GCS, Pub/Sub, Composer, Dataflow, Cloud Datafusion
  • AWS Services - S3, DMS, Redshift, RDS, EC2
  • Reporting tool - Power BI, Spotfire, Tibco

Certification

  • SnowPro Core
  • Azure AZ-900

Timeline

Senior Data Engineer

QuantiPhi Analytics
03.2024 - Current

Senior MDM Analyst

Ernst & Young GDS LLP
11.2022 - 03.2024

Associate Consultant

Capgemini India
10.2020 - 11.2022

Bachelor of Engineering -

Jadavpur University
SUSAVAN GHANTI