Led enterprise-wide cloud modernization and data architecture migrations of 100+ complex ETL workflows and

tables from legacy Teradata/Oracle environments to Snowflake using Informatica IICS (IDMC) for BFSI and

Energy Domain clients.

Key Achievements:

 Directed cloud migration of 100+ ETL workflows from Teradata and Oracle environments to Snowflake using IICS.

 Designed financial reporting dimensional models in Snowflake including staging,raw,curated and presentation layers.

 Built and modeled 50–60 fact and dimension tables processing more than 2B records.

 Reduced overall pipeline runtime by ~40% through pushdown optimization, query tuning and transformation

redesign.Optimized fact-load workflow runtime from 15 minutes to ~6 minutes.

Pipeline Ownership- API and Multi Source Integration:

 Designed ingestion.

B. Tech / M. Tech; B.E / M.E; B.Sc. / M.Sc.; B. Com / M.com; MBA/PGDM; BCA/MCA; PHD