MANOJ KUMAR
Chennai
Summary
Snowflake Developer / Data Engineer with 4 years of experience in Snowflake, Oracle SQL, and dbt. Skilled in scalable ELT pipeline building and Snowflake-native tools like Streams, Tasks, Snowpipe, and Time Travel. Experienced in transforming raw data into analytics-ready datasets via dbt models, emphasizing performance, scalability, and data quality
Overview
5
5
years of professional experience
Work History
Snowflake Developer
Sutherland
Chennai
02.2025 - Current
- Designed and maintained Snowflake Cloud Data Warehouse leveraging separation of compute & storage.
- Ingested data from AWS S3 into Snowflake using COPY INTO and Snowpipe.
- Created complex SQL transformations to cleanse and aggregate data.
- Built and managed dbt ELT pipelines using the staging → intermediate → mart structure.
- Implemented incremental dbt models, tests, and snapshots.
- Processed JSON and Parquet data with VARIANT and FLATTEN.
- Automated workflow execution via Streams and Tasks.
- Tuned warehouse performance using clustering and query optimization.
Tech Stack: Snowflake, dbt, AWS S3, Oracle SQL
Data Engineer / SQL Developer
Wells Fargo
Chennai
08.2021 - 03.2024
- Developed and optimized Oracle SQL queries and views for business reporting.
- Validated and reconciled data between source and target systems.
- Supported migration of on‑prem data to Snowflake Cloud Warehouse.
- Partnered with reporting teams to deliver accurate, timely data models.
Environment: Snowflake, Oracle SQL
Education
Bachelor of Arts - Mathematics
University of Madras
Chennai01-2020
Skills
- Data Warehousing: Snowflake
- Cloud Platform: AWS (S3, IAM – basic)
- Data Engineering: Data Ingestion, ELT Pipelines, Incremental Loads
- Transformations: dbt (Models, Tests, Snapshots, Incremental Models)
- SQL: Snowflake SQL, Oracle SQL, CTEs, Window Functions
- Semi‑Structured Data: JSON, Parquet, VARIANT, FLATTEN
- Snowflake Features: Virtual Warehouses, Snowpipe, Streams & Tasks, Time Travel, Zero‑Copy Cloning, Micro‑partitions, Clustering
- Security: RBAC, Secure Views
- Version Control: Git
Timeline
Snowflake Developer
Sutherland
02.2025 - Current
Data Engineer / SQL Developer
Wells Fargo
08.2021 - 03.2024
Bachelor of Arts - Mathematics
University of Madras