Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
JAGADEESAN V

JAGADEESAN V

Chennai

Summary

Results-driven ETL and Data Integration Specialist with over 7 years of experience in leveraging Informatica Intelligent Cloud Services (IICS), data warehousing, and cloud data integration technologies such as Snowflake and SQL. Expertise in designing, developing, and optimizing end-to-end ETL pipelines, facilitating data migration, and enhancing performance tuning across the pharmaceutical, life sciences, and manufacturing sectors. Proven ability to thrive in Agile/Scrum environments while managing CI/CD migrations and providing robust production support. Strong collaboration skills foster effective partnerships with cross-functional teams to deliver high-quality data solutions that drive business success.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Associate Engineer

COGNIZANT TECHNOLOGIES SOLUTIONS
01.2021 - Current

Project: SANOFI

  • Designed and implemented IICS ETL pipelines to integrate ICARE, MDI, TDMS, and Concur data into Salesforce CRM and Snowflake.
  • Developed parameterized mappings, reusable components, data synchronization task and taskflows improving reusability and reducing development time by 20%.
  • Built and optimized Snowflake tables, views, and stored procedures for high-volume data loads.
  • Automated secure data transfers using AWS S3 + IICS Mass Ingestion, reducing manual effort by 30%.
  • Provided post-migration support (Hypercare, issue triage, performance tuning) ensuring zero downtime during cutover.
  • Mentored junior developers and improved team productivity through best practices workshops.
  • Migrated 200+ ETL workflows from on-prem PowerCenter to IICS with zero data loss.
  • Improved ETL job performance by 35% using Pushdown Optimization and partitioning.


Project: BMW

  • Migrated data replication and enhanced legacy ETL pipelines to support ACRM solutions, reducing data processing time by 15%.
  • Delivered ad-hoc ETL solutions for quick business requests, accelerating response to stakeholders by 25%
  • Provided production support (job monitoring, debugging, resolution) ensuring 99.9% SLA adherence.
  • Followed ITIL standards for incident, problem, and change management.

Software Engineer

HCL TECHNOLOGIES LIMITED
01.2018 - 01.2021

Project: Merck & Co.

  • Analyzed requirements and developed ETL pipelines integrating Salesforce APIs with downstream applications.
  • Optimized ETL performance by tuning mappings, reducing load times by 35%.
  • Created ETL enhancements & integration workflows, ensuring accuracy of global CRM data.
  • Monitored daily/weekly jobs, identified root causes of failures, and implemented preventive measures.
  • Authored project documentation (IDD, POC, SOP, IQOQ) to support compliance and audits.

Education

B.E - Computer Science Engineering

Velammal Engineering College
05-2016

Diploma - Electronics and communication Engineering

Central Polytechnic College
05-2012

Skills

  • Proficient in Informatica PowerCenter and IICS
  • Experience with fact/dimension modeling and SCD
  • Proficient in multiple database systems: Oracle, SQL Server, MySQL, Snowflake
  • CRM proficiency: Salesforce
  • Automation tools and task scheduling
  • Performance tuning expertise
  • Agile and Scrum methodologies

Certification

  • Informatica Intelligent Data Management Cloud Foundation Series.

May/2025

Description: Completed foundational training on Informatica’s Intelligent Data Management Cloud (IDMC), covering data integration, application integration and data quality modules.

Timeline

Associate Engineer

COGNIZANT TECHNOLOGIES SOLUTIONS
01.2021 - Current

Software Engineer

HCL TECHNOLOGIES LIMITED
01.2018 - 01.2021

B.E - Computer Science Engineering

Velammal Engineering College

Diploma - Electronics and communication Engineering

Central Polytechnic College

Similar Profiles

CREATE PROFILE
JAGADEESAN V