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