Summary
Overview
Work History
Education
Skills
Timeline
Generic

Dinesh Charan Ambati

Toronto,Canada

Summary

  • 7+ years of experience in building and optimizing ELT pipelines using Snowflake, DBT, Azure, and Python.
  • Proven expertise in ETL/ELT pipelines, data modeling, cloud migrations, and real-time analytics using Spark, Kafka, and Airflow.
  • Skilled in automating workflows, ensuring data quality, and enabling self-service BI through Power BI and Tableau.
  • Hands-on experience in Azure Data Factory, Synapse, and Power BI for enterprise-scale data platforms.
  • Proactive in Agile teams, contributing to design discussions, estimation, and delivery of robust solutions.
  • Adept at collaborating with cross-functional teams to translate business requirements into scalable, efficient, and secure data solutions.

Overview

11
11
years of professional experience

Work History

Sr. Data Engineer

Sherwin-Williams
09.2024 - Current
  • Designed and deployed scalable data pipelines using AWS Glue, Pyspark, and Snowflake for enterprise analytics.
  • Automated ETL workflows and serverless jobs through AWS Lambda, reducing manual effort and infrastructure overhead.
  • Built data governance framework to monitor quality and ensure compliance across Snowflake warehouses.
  • Developed real-time ingestion pipelines using Kafka and Spark Streaming for supply chain and operations analytics.
  • Partnered with business teams to map data pipelines to operational and financial processes, ensuring alignment with business outcomes.
  • Mentored junior engineers on DBT best practices, SQL optimization, and data quality frameworks.
  • Designed automated data quality controls and alerting mechanisms to proactively identify anomalies.
  • Authored technical documentation for maintainability and onboarding new team members.
  • Partnered with data analysts/scientists to ensure datasets were clean, consistent, and business-ready.

Sr. Data Engineer

Cigna Healthcare
03.2021 - 12.2022
  • Architected and maintained Azure Data Lake and Synapse environments for enterprise-scale healthcare analytics.
  • Actively participated in Agile ceremonies and cross-functional discussions to align technical deliverables with clinical/operational goals.
  • Proposed and implemented improvements in data modeling standards and DBT project structure, reducing development effort.
  • Integrated Power BI dashboards with Azure SQL and Blob Storage to deliver KPIs for business users.
  • Created data models and transformations supporting Power BI dashboards.
  • Implemented DBT testing, snapshots, and documentation for governance & compliance.
  • Performed data profiling & validation to improve quality and reliability.
  • Supported DevOps CI/CD pipelines, ensuring smooth deployment of data solutions.
  • Worked closely with stakeholders to align solutions with business requirements.

Data Engineer

DBS Bank
08.2018 - 02.2021
  • Developed and maintained data pipelines and ETL frameworks using PySpark, AWS EMR, and Hive.
  • Designed and implemented AWS EMR and Redshift data lake for financial analytics and operational reporting.
  • Created Spark-based ETL pipelines to ingest and transform data from multiple systems (Kafka, DynamoDB, RDS).
  • Improved performance of existing ETL processes by optimizing partitioning, joins, and Spark caching strategies.
  • Developed a Python-based data validation framework to detect anomalies and ensure data accuracy.
  • Worked closely with BI teams to streamline dashboard performance and data delivery timelines.

SQL Developer

Acko
06.2014 - 07.2016
  • Developed and optimized SQL Server databases and ETL jobs.
  • Implemented a centralized data warehouse, consolidating multiple data sources.
  • Automated backups, monitoring, and performance tuning for production systems.
  • Created SSRS dashboards & reports to support business decision-making.
  • Introduced basic data validation rules in SQL jobs to improve accuracy of reporting.
  • Created structured technical documentation for ETL jobs and reporting logic.
  • Worked closely with reporting teams to ensure SQL models aligned with business KPIs.

Education

Post Graduate Certificate - Artificial Intelligence & Data Science

Loyalist College
01.2024

MBA - Finance & Marketing

Chaitanya Bharathi Institute of Technology
01.2018

B.Com - Computers

Osmania University
01.2014

Skills

  • Cloud Platforms: AWS (Glue, Lambda, EMR, Redshift, S3, EC2), Azure (Data Factory, Synapse, Data Lake, SQL DB)
  • Pipeline & Automation: ETL/ELT (Pyspark, SQL, Airflow, Glue), Data Modeling (Star/Snowflake), CI/CD Automation
  • Databases: Snowflake, Oracle, SQL Server, MySQL, PostgreSQL, Hive, HBase
  • Programming: Python (Pandas, NumPy, Pyspark), SQL, PL/SQL, T-SQL, Shell Scripting
  • BI & Analytics: Power BI, Tableau, SSRS, Cognos, Excel Dashboards
  • DevOps & Tools: Git, Jenkins, Terraform, Docker, Jira, ServiceNow, Databricks

Timeline

Sr. Data Engineer

Sherwin-Williams
09.2024 - Current

Sr. Data Engineer

Cigna Healthcare
03.2021 - 12.2022

Data Engineer

DBS Bank
08.2018 - 02.2021

SQL Developer

Acko
06.2014 - 07.2016

Post Graduate Certificate - Artificial Intelligence & Data Science

Loyalist College

MBA - Finance & Marketing

Chaitanya Bharathi Institute of Technology

B.Com - Computers

Osmania University
Dinesh Charan Ambati