Dheeraj Puttapaka

Senior Data Engineer @CGI

Guelph, ON, CA
MOBILE NUMBERS
+91 *********19

Signup · Get unlimited contacts

WORK HISTORY

Nov 2024 — Present

Senior Data Engineer @CGI

View department →

CA

Project1 -Delivered a cloud-native data platform on Microsoft Azure, integrating on-prem SQL Server & Oracle data into Azure Synapse Analytics using ADF, SSIS, Kafka, ADLS for batch + real-time streaming- Built scalable ETL/ELT pipelines in Azure Data Factory & Databricks (PySpark/Scala, Delta Lake), processing structured/unstructured datasets reliably- Modeled enterprise data warehouses in Synapse with fact/dimension tables, stored procedures, and UDFs for OLAP-style analytics- Developed Power BI dashboards integrated with Synapse, transforming KPIs into actionable insights for business users- Ensured security & governance with ADLS, Blob Storage, Purview, encryption, RBAC, and lifecycle policies and Automated workflows with Azure DevOps CI/CD, containerized workloads in Docker, and scaled deployments via AKS- Achieved cost/performance optimization with serverless compute, indexing, caching, and partitioning strategies.Project 2- Designed and developing a data engineering platform on AWS EMR, Apache Airflow, Snowflake, Python, PySpark, Hadoop, Docker for enterprise-scale analytics- Designed and orchestrated Airflow workflows with Amazon EMR for distributed big data transformations. Developed and optimized Snowflake data models (fact/dimension, clustering, partitioning) to improve scalability and BI performance- Built PySpark ETL pipelines for multi-source data ingestion into Snowflake, ensuring modular, production-ready pipelines- Integrated Snowflake with on-prem + multi-cloud platforms, enabling seamless cross-environment data availability- Implemented RBAC, data masking, encryption for governance and security within Snowflake. Automated delivery with CI/CD (Jenkins) and containerized pipelines via Docker- Leveraged Hadoop + Spark on EMR for distributed processing of large datasets, reducing processing time significantly.

EDUCATION

N/A

George Brown Polytechnic

Postgraduate Degree, Applied Artificial Intelligence Solutions Development

N/A

Conestoga College

Postgraduate Degree, Business Analytics

ABOUT DHEERAJ PUTTAPAKA

I am a Data Engineer with a strong focus on building scalable and efficient data systems. My expertise spans data modeling, python, and the end-to-end development of data pipelines that ensure smooth, reliable, and high-performance data flow. I have a proven track record of designing and implementing solutions that improve data storage, retrieval, and analytical capabilities across large datasets. Skilled in integrating with cloud platforms such as AWS, I follow industry best practices to build robust, maintainable, and secure systems. My work consistently drives actionable insights and adds measurable value to business operations. In addition to my data engineering skills, I bring hands-on experience in coding, automation, and backend development, enabling me to contribute across a wide range of technical challenges and initiatives.

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Dheeraj Puttapaka — Senior Data Engineer at CGI in Guelph, ON, CA | Unifers