Pooja A
Snowflake Data Engineer
Chennai
Summary
- 8 years of IT experience and 5 years in Snowflake. Expertise in data migration, ETL pipelines, Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy Cloning. Skilled in PL/SQL, SQL, Python, and Power BI, delivering high-quality, analytics-ready data for BFSI and enterprise projects.
- Performed Oracle to Snowflake data migration using flat files for application upgrade projects.
- Built and maintained Snowpipe pipelines to automate data loading from AWS Cloud to Snowflake.
- Skilled in loading and managing large datasets (JSON, CSV) from AWS S3 using COPY, INSERT, PUT, and GET commands in Snowflake.
- Proficient in complex SQL query development using CTEs, joins, and window functions for ETL and analytics.
- Created unique identifiers for records using Snowflake sequences for consistent primary keys.
- Strong experience in Agile environments, delivering projects efficiently while collaborating with multiple teams and adapting to changing requirements.
Overview
8
8
years of professional experience
Work History
Senior Analyst
HCL Technologies
05.2025 - 11.2025
Company: Hcl Technologies ltd (May 2025 to November 2025)
Current Project : AIB Banking
Domain : BFSI
Environment : Oracle, AWS S3, Snowflake DB
Roles and responsibilities
- Engineered end-to-end ETL workflows in Snowflake, integrating data from Oracle and AWS S3.
- Leveraged External Tables to query data directly from AWS S3 when direct access was restricted.
- Built Secure Views and Materialized Views to share data efficiently with partner applications.
- Utilized Time Travel to restore historical data and Zero-Copy Cloning for rapid testing and development.
- Managed data loading configurations including Copy on Error, File Formats, and other Snowflake copy options.
- Processed and validated high-volume banking datasets across source and target systems.
Analyst
Accenture Solutions Private Ltd
04.2022 - 03.2025
Company : Accenture Solutions Pvt. Ltd. (April 2022 to March 2025)
Previous Project - Bank of America
Domain : BFSI
Environment : Oracle, AWS S3, Snowflake DB
Role & Responsibilities
- Implemented Streams and Task trees to capture DML changes and maintain reliable backups.
- Executed Oracle to Snowflake migrations for BFSI clients, including rewriting procedures and objects for smooth transitions.
- Ingested semi-structured and unstructured data (JSON, Parquet) into Snowflake using VARIANT and Flatten functions.
- Developed staging and validation workflows to ensure accurate migration of large datasets.
- Verified Power BI dashboards against Snowflake data to ensure accurate reporting.
- Partnered with business and technical teams to deliver trusted, analytics-ready datasets.
Process Associate
Tata Consultancy Services
10.2016 - 04.2022
Company : Tata Consultancy Services
Previous Project : Citi Bank
Domain : BFSI
Environment : Oracle, AWS S3, Snowflake DB
Roles and responsibilities
- Implemented and managed Snowflake core objects to enable a successful Oracle-to-Snowflake migration.
- Designed and managed Snowflake objects: Databases, Schemas, Tables, Views, Stages, Pipes, Warehouses, and Roles.
- Crafted advanced SQL queries for extraction, transformation, validation, and troubleshooting.
- Configured Snowpipe for automated, near real-time data ingestion.
- Developed Snowflake Procedures, Functions, and UDTFs to streamline transformations and implement business logic.
- Created and maintained DBT models to transform, cleanse, and structure data for analytics.
- Supervised ETL pipelines, resolved issues, and ensured consistent, high-quality data delivery.
Education
Bachelor of Arts - Commerce
Shree Muthu Kumaraswamy College
Chennai, India 04.2001 -
Skills
SQL
SNOWFLAKE SQL
ORACLE
ETL CONCEPTS
SQL SERVER
PL/SQL
Tools :
SNOWFLAKE
SQL
IICS
SSMS
DEVELOPER
JIRA
CONTROL M
GIT
Additional Information
Declaration :
I affirm that the information provided above is true to the best of my knowledge and belief.
Timeline
Senior Analyst
HCL Technologies
05.2025 - 11.2025
Analyst
Accenture Solutions Private Ltd
04.2022 - 03.2025
Process Associate
Tata Consultancy Services
10.2016 - 04.2022
Bachelor of Arts - Commerce
Shree Muthu Kumaraswamy College
04.2001 -