Open to opportunities

Santhali Garg

@santhaligarg

ETL Developer at Tata Consultancy Services who migrated ETL workflows to IICS and built a Snowflake SCD Type 2 pipeline.

India

Message

What I'm looking for

I’m seeking remote ETL Developer or Data Analyst opportunities in Indian and global IT markets.

At Tata Consultancy Services (TCS), I designed ETL mappings and workflows using Informatica PowerCenter and IICS, and wrote SQL and PL/SQL for data extraction, transformation, and reporting across banking, pharmacy, and energy projects.

On the Vertex pharmacy platform, I developed PL/SQL procedures and ETL mappings, led the transition of workflows from Informatica PowerCenter to IICS, and validated pharmaceutical datasets for reporting and compliance.

During my career break, I built a Snowflake customer data pipeline from CSV through staging and raw layers to a dimension, with validation, Streams, Tasks, lookup enrichment, and SCD Type 2 historical change tracking.

I also created a Python ETL project using Pandas to clean and transform customer CSV data. I’m refreshing my IICS and SQL query optimization skills, deepening my cloud data knowledge, and seeking remote opportunities.

Experience

Work history, roles, and key accomplishments

Assistant Consultant – ETL Developer / Data Analyst

Tata Consultancy Services

Jun 2010 - Apr 2024 (13 years 10 months)

Designed and developed ETL mappings and workflows using Informatica PowerCenter and IICS. Wrote complex SQL and PL/SQL scripts for data extraction, transformation, and business reporting.