Bhaskar Gajjala

Results-driven Data Engineer with 15+ years of IT experience and 10+ years in Data Engineering specializing in Snowflake, dbt, SQL, and cloud-based data engineering solutions. Expertise in designing scalable ELT pipelines, enterprise data warehouses, CDC frameworks, and real-time data processing using AWS technologies. Strong experience in Snowflake optimization, dbt transformations, data modeling, incremental loading, and performance tuning.

Senior Data Engineer - Trianz

(2021-01)

Client: MassMutual

• Developed scalable ELT pipelines using Snowflake and dbt for enterprise insurance analytics platforms.
• Built dbt incremental models, snapshots, macros, reusable transformations, and automated testing frameworks.
• Implemented CDC pipelines using Snowflake Streams, Tasks, Snowpipe, and AWS DMS for near real-time ingestion.
• Integrated AWS S3 external stages with Snowflake for structured and semi-structured data ingestion.
• Developed real-time ingestion pipelines using AWS Kinesis, SQS, and SNS.
• Optimized Snowflake warehouse performance, reducing ETL runtime by 40% using clustering keys and query tuning.
• Utilized Time Travel and Zero Copy Cloning for backup, recovery, and environment migration activities.
• Automated deployments and scheduling using Git, Jenkins, Airflow, and CI/CD pipelines.

Data Engineer - Trianz

(2016-01 - 2020-12)

Client: Liberty Mutual

• Migrated legacy ETL solutions into modern Snowflake-based ELT architecture.
• Developed dimensional data models including fact and dimension tables for reporting systems.
• Built reusable dbt staging, intermediate, and mart layer models.
• Created complex SQL transformations, views, stored procedures, and Snowflake Tasks.
• Implemented ingestion pipelines using AWS Glue and AWS DMS.
• Developed secure views and data-sharing solutions for analytics consumption.
• Performed query optimization and workload tuning for large-scale analytical processing.

Database Developer - Chubb & NetApp Projects

(2008-07 - 2015-12)

• Developed SQL queries, stored procedures, functions, and ETL support solutions for enterprise applications.
• Performed database optimization, performance tuning, and production support activities.
• Worked on batch processing workflows, data validation, and reporting solutions.

Master of Science (M.Sc.) - Computer Science