Summary
Overview
Work History
Skills
Education
Languages
Timeline
Generic

Saikumar Dornala

Nepean,ON

Summary

Experienced and innovative data engineer proficient in designing, implementing, and optimizing data pipelines with a strong emphasis on DBT(Data Build Tool) and Snowflake. Skilled in streamlining ETL processes and data modeling to transform raw data into valuable insights. Demonstrated expertise in leveraging cloud-based platforms, particularly Snowflake, to develop scalable and efficient solutions. Collaborative team player with a proven track record of understanding business requirements and delivering high-quality solutions that drive business outcomes. Committed to continuous learning and staying abreast of emerging technologies to enhance efficiency and effectiveness in data engineering practices.

Overview

2
2
years of professional experience

Work History

Data Cloud Engineer

Reitmans Canada Ltd.
04.2022 - 03.2024
  • Led a migration project to transfer all data from Quantisense to Snowflake, ensuring seamless transition and optimal performance in the new environment
  • Developed and implemented end-to-end data pipelines, including creating streams and tasks to efficiently bring data from landing to raw stages
  • Executed loading of historical data and performed comprehensive data cleaning processes to ensure data accuracy and integrity
  • Designed and implemented staging, intermediate, and final fact or dimension tables to support various analytical needs and business requirements
  • Developed complex SQL queries utilizing stored procedures, common table expressions (CTEs), and temporary tables to support MicroStrategy reports
  • Leveraged hands-on experience with modern data engineering tools, including dbt (Data Build Tool) and Snowflake, to optimize data workflows and drive analytical insights
  • Document data engineering processes, workflows, and best practices to facilitate knowledge sharing and collaboration within the team
  • This includes creating technical documentation, writing code comments.

Skills

  • Strong proficiency in SQL for data querying, manipulation, and optimization
  • Windows 2016/2012/2008, Windows 7/10
  • Familiarity with version control systems such as Git for managing codebase and collaboration in team projects
  • Code Development
  • Effective Communication
  • Design
  • Performance Optimization
  • Multitasking Abilities
  • Attention to Detail

Education

Electronics And Communications Engineering, VIT, Vellore, TN, India., Software Testing, MCIT, Montreal, QC, Canada

Languages

French
Limited Working

Timeline

Data Cloud Engineer

Reitmans Canada Ltd.
04.2022 - 03.2024
Saikumar Dornala