Headline

Snowflake Data Engineer | SQL • DBT • ETL Pipelines • Data Warehousing • Data Modeling | Cloud Data Pipeline Design & Optimization | Data Quality & Governance | CI/CD • Git • Shell Scripting

About

Snowflake Data Engineer focusing on building scalable data pipelines, optimizing warehouse performance, and delivering reliable data for analytics and decision-making. Experience includes developing DBT models across raw, staging, and curated layers, writing complex SQL transformations (CTEs, window functions, aggregations), implementing data validations, and automating workflows. Hands-on with Snowflake features including Warehouses, Stages, File Formats, Snowpipe, Streams, Tasks, and Role-Based Access. Technical Skills: • Snowflake, DBT, SQL, PL/SQL • Data Modeling, ETL & ELT Pipelines, Data Warehousing Concepts • Git, CI/CD, Airflow / Control-M Scheduling & Monitoring • Unix Shell Scripting, Cloud Storage (S3 / Azure Blob) I work on improving data accuracy, reducing pipeline failures, and making data easier for teams to consume. Open to Data Engineering roles where I can contribute to scalable data systems and structured data workflows.

Location

Chennai

AI stack

cursor

gemini

langchain

openai

Work experience

RDE - Risk Decision Engine at HCLTech, Jan 2023 - Present · 3 yrs 4 mos, The Risk Decision Engine built a system to acquire and process Bureau data from vendors to assess customer eligibility and identify potential fraud for various financial products. As part of this project, we collect this data and store it in Snowflake tables, transforming into layered tables using the DBT to ensure data accuracy and accessibility. Providing real-time insights to support credit risk, customer eligibility and fraud detection for informed business decisions.

Data Engineer at HCLTech, Oct 2022 - Present · 3 yrs 7 mos, Chennai, Tamil Nadu, India, • Designed and built DBT models across raw → staging → curated layers, improving data usability and traceability for downstream analytics. • Developed complex SQL transformations using CTEs, window functions, aggregations, and performance-tuned queries for large datasets. • Created and maintained scalable ETL pipelines on Snowflake, including data ingestion, transformation orchestration, and scheduled workflows. • Implemented Snowflake features including Warehouses, Stages, File Formats, External Tables, Streams, and Tasks for automated processing. • Configured and monitored Snowpipe for continuous data ingestion and validated data accuracy across source and target tables. • Worked with Control-M to schedule, monitor, and troubleshoot pipeline execution dependencies and job flows. • Followed Git-based version control and CI/CD release practices for safe deployment of DBT models and data transformations.

Graduate Engineering Trainee at HCLTech, Aug 2022 - Sep 2024 · 2 yrs 2 mos, Chennai, Tamil Nadu, India

Education

Bachelor of Engineering - BE, Electrical, Electronic and Communications Engineering Technology/Technician, Panimalar Institute Of Technology

Bachelor of Technology, Electrical, Electronics and Communications Engineering, Panimalar Institute Of Technology