Summary
Overview
Work History
Education
Skills
Primary Tools
Timeline
Generic
Thangaganesh Soundarapandian

Thangaganesh Soundarapandian

Chennai

Summary

Aspiring to build a meaningful and positive career by leveraging my skills and knowledge to contribute to the continuous growth of individuals, the organization, and society. Committed to ongoing learning, professional development, and making a valuable impact through dedicated and ethical work.

Overview

17
17
years of professional experience

Work History

Freelance ETL Developer

Clariant
04.2025 - 08.2025
  • Constructed data warehouse solution with DBT and Snowflake, enhancing analysis capabilities for material master data within manufacturing client.
  • I have been a Centre of Excellence for the DBT and Talend ETL skill pool in the company.

Senior ETL Lead

TSS
07.2021 - 03.2025
  • Responsible for building a recommendation engine solution for a lifestyle client, which includes DBT as ELT, and Snowflake as cloud data warehouse.
  • Collaborated with team members to achieve target results.
  • Managed complaints with calm, clear communication and problem-solving.
  • Lead a migration project where the current tech stack is migrated into a new and strategic one.
  • All Talend jobs are getting migrated into DBT code with GitHuB as the versioning repository and Snowflake being the cloud DB.

Senior ETL Lead

Hexaware
10.2019 - 07.2021
  • Developed Data Governance solution that enhanced client data quality using Talend ETL tool and MDM principles.
  • Managed team of 10 ETL developers, overseeing design and deployment of Talend ETL jobs for Snowflake and MS SQL Server.
  • Collaborated with analysts to gather requirements and produce design documentation, ensuring alignment with project scope.
  • Oversaw complete ETL lifecycle including setup for SIT, Pre-Prod, and Production environments, coordinating all build and release activities.

Senior ETL Lead

AstraZeneca
04.2016 - 06.2019
  • The project involves the development of a comprehensive data warehouse to consolidate the company's financial data.
  • Data from diverse sources, including SAP, various API applications, and AWS S3 buckets, is ingested into AWS S3 buckets.
  • Talend extracts the raw data from these buckets and loads it into a MySQL database structured in a 3NF data model.
  • Subsequently, Talend performs necessary aggregations and transformations on the data, loading the processed results into AWS Redshift as data marts.
  • These marts serve as the foundation for Power BI reporting, enabling advanced analytics, and insights.

Technical Lead

L&T Infotech
06.2015 - 04.2016
  • This project involves creation of Talend ETL pipelines which reads a financial excel sheet, understands the data, applies transformation as applicable and transforms the data into meaningful reports.

Technical Lead

Robert BOSCH
06.2014 - 05.2015
  • The project is about building an MDM solution for a manufacturing client.
  • The source data is from the COBOLT system.
  • We used the Talend tool to read, transform, and load the data into SAP objects, which are then to be used to serve as a material master for the company.
  • This project is all about moving from legacy systems to a strategic solution.

ETL Developer

Syntel
04.2013 - 03.2014
  • The project is about building ETL pipelines which serve as data transfer pipelines for a banking client.
  • Talend pipelines are scheduled accordingly and are also worked on an ad-hoc basis, based on the requirements.

ETL Developer

Virtusa
07.2008 - 04.2013
  • The project involves building an MDM solution for a travel client to create a golden 360-degree view of their customers, which aims to improve the customer experience.
  • This involves using Talend DI, DQ, ESB, and MDM products.
  • Various third-party applications are also used in the process to improve data quality.

Education

B.E -

Anna University
Chennai
01.2008

H.S.C -

TN State Board of Education
Chennai
01.2004

S.S.L.C -

TN State Board of Education
Chennai
01.2002

Skills

  • DBT
  • Snowflake
  • Talend ETL
  • Data governance
  • Data warehousing
  • Cloud computing

Primary Tools

  • DBT 1.9 cloud
  • Fivetran in HVR and SAAS
  • Snowflake cloud database
  • Talend Cloud Data Platform (7.2/ 7.3)
  • Talend Data Service Platform (6.2.1) mounted in AWS cloud
  • Talend Enterprise Edition (DI, DQ, MDM) (Version 5.2)
  • Talend Open Studio (DI, DQ) (Version 5.4.1 / 5.4.2)

Timeline

Freelance ETL Developer

Clariant
04.2025 - 08.2025

Senior ETL Lead

TSS
07.2021 - 03.2025

Senior ETL Lead

Hexaware
10.2019 - 07.2021

Senior ETL Lead

AstraZeneca
04.2016 - 06.2019

Technical Lead

L&T Infotech
06.2015 - 04.2016

Technical Lead

Robert BOSCH
06.2014 - 05.2015

ETL Developer

Syntel
04.2013 - 03.2014

ETL Developer

Virtusa
07.2008 - 04.2013

B.E -

Anna University

H.S.C -

TN State Board of Education

S.S.L.C -

TN State Board of Education

Similar Profiles

CREATE PROFILE
Thangaganesh Soundarapandian