ETL(Extract,Transform & Load) and Datawarehouse Specialist

Dhamotharan Seenivasan is a seasoned ETL Developer and Data Architect with over 17 years of expertise in Data Warehousing, Business Intelligence, ETL development, and cloud technologies. As an Architect at Mphasis Corp, he focuses on building scalable Azure-based data solutions, driving ETL pipeline development, and leading large-scale data migration projects that modernize enterprise data ecosystems.

His work has consistently delivered impactful results, enabling seamless data integration, improved performance, and cost-effective operations. Dhamotharan is well-versed in designing and optimizing ETL workflows that ensure data accuracy, consistency, and availability. His contributions span developing pipelines for structured and unstructured data, applying advanced transformation and validation logic, and implementing robust data quality frameworks through lineage tracking and compliance enforcement.

He has successfully led the migration of legacy systems to modern cloud architectures using Microsoft Azure, leveraging tools such as Azure Data Factory, Databricks, and Synapse Analytics to support real-time and batch processing. His expertise also includes optimizing storage and retrieval with platforms like Snowflake and Azure Data Lakes to power high-performance analytics.

A key strength lies in his ability to improve ETL efficiency through SQL query tuning, indexing, and partitioning, while implementing incremental and streaming data loads. Dhamotharan also focuses on automation and cloud resource optimization to reduce operational costs and maximize computing efficiency, making him a vital force behind enterprise data transformation initiatives.