About Me

Get to know me better

Het Acharya
Het Acharya

My Story

With over 12 years of experience in software engineering and big data, I specialize in architecting and delivering scalable, high-performance data platforms and analytics solutions. I have a proven track record of leading end-to-end data migrations from on-premises systems to cloud platforms like Snowflake, Azure, and Amazon Redshift, modernizing data ecosystems and improving processing efficiency by up to 40%.

Experience

SnowflakeSept 2022 – Present

Sr. Solutions Architect, Migrations

  • Design and implement target architectures for customers migrating their workloads to Snowflake.
  • Analyze existing customer architectures to develop comprehensive migration plans.
  • Repoint ETL tools such as Informatica and DataStage from source RDBMS to Snowflake.
  • Partner with customers to craft tailored migration solutions and streamline data movement.
  • Design scalable, efficient workloads optimized for cloud performance.
Infostrux Solutions IncOct 2021 – Aug 2022

Sr. Data Architect

  • Designed and implemented enterprise-grade data warehouse solutions using Kimball and Inmon methodologies.
  • Led the migration of Google Analytics 360 (GA360) data from GCP to Snowflake.
  • Partnered with clients to define cloud data strategies and governance standards.
  • Implemented CI/CD workflows for data delivery with Python, DBT, AWS Glue, and SageMaker.
Next Pathway IncFeb 2018 - Aug 2021

Lead Data Engineer

  • Worked with customers end to end, from opportunity discovery and SHIFT product demos through architecture design, value articulation, and post-migration success.
  • Ensured smooth transitions from on-premises systems to cloud environments.
  • Led multiple teams building code analyzers and code translation from Teradata, Netezza, Hadoop, and Oracle.
  • Targeted cloud platforms including Azure, Snowflake, Redshift, GCP BigQuery, and Yellowbrick.
Bank of Montreal (BMO)Nov 2016 - Feb 2018

ETL/Application Developer, Consultant

  • Developed Microsoft SSIS packages integrating IBM Netezza, IBM IGC, REST APIs, and DB2 to automate complex business tasks.
  • Contributed to an ETL framework that standardized package design and error handling across the department.
  • Migrated data pipelines from Netezza to Hadoop, enabling integration with new big data systems.
G AdventuresFeb 2016 - Nov 2016

BI/ETL Developer, Consultant

  • Built Business Intelligence and ETL solutions for migrating data from PostgreSQL to Microsoft Dynamics GP.
  • Environment: Visual Studio 2010, Microsoft SSIS, Scribe Workbench 7.9, PostgreSQL 9.0, Pervasive, Polaris database, PowerShell, SQL Server 2012, Subversion.
Bank of Montreal (BMO)July 2014 - Jan 2016

ETL Application Developer, Consultant

  • Database and ETL developer on the Enterprise Data Warehouse (HUB-IDP) running on the IBM Netezza appliance.
  • Delivered AML (Anti Money Laundering) data warehouse projects with extensive reporting on capital market feeds such as Global One, Calypso, and Wallstreet.
  • Worked on regulatory projects including VOLCKER.

Education

McMaster University

Bachelor of Engineering, Electrical and Biomedical

Sep 2009 - April 2014

Graduated in Electrical and Biomedical Engineering program with co-op. Dean's Honors list 2014

Skills & Technologies

Snowflake
GCP
Azure
AWS Redshift
Amazon Redshift
BigQuery
Yellowbrick