Swagata Srimani
Data Engineering Analyst
Kolkata
Summary
Data Engineer with over 2 years of experience in developing cloud-based data warehousing solutions, specializing in Snowflake, SQL, Tosca Automation Tool and QLIK Replicate. Expertise in data migration, data architecture and data modelling. Proven track record in developing and optimizing end-to-end data pipelines, improving ETL (Extract, Transform, Load) processes, and enhancing data migration and processing speeds by 60%. Strong analytical skills with a commitment to delivering actionable insights and working effectively within on-shore & off-shore team environments.
Overview
2
2
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Data Engineering Analyst
Accenture
Kolkata
11.2024 - Current
- Developed a scalable cloud-based data pipeline for seamless data migration and data processing using technologies like Snowflake Data Warehouse, SQL and QLIK Replicate
- Designed a metadata-driven generic framework using a Snowflake JavaScript stored procedure & various metadata tables in Snowflake for automating the daily and monthly data loading of over 1,000 tables, reducing manual effort by 80% and optimizing the ETL process
- Performed DDL changes (add column, remove column, rename column, change datatype) to the tables as per client requirement
- Leveraged snowflake stored procedures and snowflake tasks for flow orchestration, and used virtual warehouse sizing to manage workflow dependencies, reducing execution time by 30% and ensuring efficient resource management
- Participated in regular code reviews, employed best practice design principles, and utilized GIT for regular deployments, improving collaboration and maintaining high code quality in a DevOps environment
- Established effective communication channels among team members, resulting in improved collaboration on projects.
- Presented analysis findings to stakeholders through clear visualizations and concise explanations, facilitating better understanding of complex concepts.
Data Engineering Associate
Accenture
Kolkata
11.2022 - 11.2024
- Developed a comprehensive end-to-end ETL pipeline for cloud data migration from AWS S3 to Snowflake Data Warehouse, transforming the data with SQL queries, improving data loading speed by 40%
- Managed micro batch data pipeline from AWS S3 to Snowflake (through Snow pipe), reducing latency and downtime by 50% during data migration, ensuring continuous data availability
- Validated data integrity and data accuracy post-migration using Tosca Automation, reducing testing time by 50% and ensuring compliance with data quality standards
- Mentored interns, aiding in onboarding process and instructing new personnel on applicable guidelines and techniques.
- Designed cross-functional interactions to reduce dependency and redundancy between diverse operational teams.
Education
Bachelor of Technology - Computer Science And Engineering
Guru Nanak Institute of Technology
Kolkata, India 08.2018 - 08.2022
Skills
- Snowflake
- SQL
- AWS S3
- Qlik Replicate
- Stored procedures
- Views
- UDF
- Tasks
- Tables
- Stages
- Snowpipe
- Tosca Automation Tool
- Data Migration
- Data Processing
- ETL
- Excel
- GIT
- Gitlab
- Jira
- Splunk
- Confluence
Certification
Snowflake SnowPro Core Certification https://www.credly.com/badges/7cef6316-5abe-443b-a222-b2c246b58dea/linked_in_profile
Timeline
Data Engineering Analyst
Accenture
11.2024 - Current
Snowflake SnowPro Core Certification https://www.credly.com/badges/7cef6316-5abe-443b-a222-b2c246b58dea/linked_in_profile
10-2023
Data Engineering Associate
Accenture
11.2022 - 11.2024
Bachelor of Technology - Computer Science And Engineering
Guru Nanak Institute of Technology
08.2018 - 08.2022
Similar Profiles
Uttara MerupulaUttara Merupula
Team Leader at AccentureTeam Leader at Accenture
Anchitha K RAnchitha K R
Senior Software Engineer at AccentureSenior Software Engineer at Accenture
PHANI TEJA NALLAMOTHUPHANI TEJA NALLAMOTHU
Senior Manager, Technology Architecture at AccentureSenior Manager, Technology Architecture at Accenture