profile-pic
Vetted Talent

Pallavi S

Vetted Talent

Oriented Snowflake Developer with passion for leveraging data to drive business decisions. Seeking to utilize my 3 years of experience in Snowflake development, Advance SQL proficiency, and expertise in ETL processes to contribute to the success of dynamic organization. Dedicated to delivering scalable and efficient data solutions that meet and exceed business objectives

  • Role

    Data Engineer

  • Years of Experience

    3 years

Skillsets

  • Data Warehousing
  • ETL processes
  • Snowflake development

Vetted For

9Skills
  • Roles & Skills
  • Results
  • Details
  • icon-skill_image
    Senior Data Engineer With Snowflake (Remote)AI Screening
  • 64%
    icon-arrow-down
  • Skills assessed :Azure Synapse, Communication Skills, DevOps, CI/CD, ELT, Snowflake, Snowflake SQL, Azure Data Factory, Data Modelling
  • Score: 58/90

Professional Summary

3Years
  • Aug, 2021 - Present4 yr

    Snowflake Developer

    Tata consultancy services

  • Snowflake Developer

    TCS

  • Junior ETL Developer

    TCS

Applications & Tools Known

  • icon-tool

    Snowflake

  • icon-tool

    Advance SQL

  • icon-tool

    Talend

  • icon-tool

    Python

  • icon-tool

    Azure Data Factory

  • icon-tool

    Unix

  • icon-tool

    Jenkins

  • icon-tool

    Github

  • icon-tool

    SQL Server

  • icon-tool

    Tableau

  • icon-tool

    Putty

Work History

3Years

Snowflake Developer

Tata consultancy services
Aug, 2021 - Present4 yr

    Experienced in working on Enhancement  and Development using Snowflake. Proficient in designing, optimizing, and  maintaining Snowflake data warehouses. Experienced in Snowflake architecture,  including schema design and data loading  optimization. Development of SQL scripts to clean,load  and run data tasks.Capable of leveraging  SQL for data analysis, modeling and  database administration tasks Expertise in writing complex SQL queries,  including joins, subqueries and window functions. Experienced in designing, developing, and  deploying ETL processes using Talend Data Integration or IBM DataStage. Capable of extracting, transforming and loading data from various sources to target systems. Skilled in implementing data quality checks and error handling mechanisms within ETL workflows.

Snowflake Developer

TCS
    Create, test, and implement enterprise-level apps with Snowflake. Solve performance issues and scalability issues in the system. Build, monitor, and optimize ETL and ELT processes with data models. Engineered efficient ETL processes using Snowflake tasks and streams, automating data ingestion and transformation workflows.

Junior ETL Developer

TCS
    Experience in Designing, Developing, Testing, Documenting of ETL Jobs and monitoring the application to process data using SQL and Unix for processing data. Proficiency in writing and debugging complex SQL queries. Engaged in Patching and testing of the Data in production monthly and quarterly. Reports are viewed and processed on Tableau.

Major Projects

6Projects

ECOLAB ,Manufacturing Domain

TCS
Mar, 2023 - Present2 yr 5 months

    Designed, implemented and Orchestrated Scalable robust Snowflake Data Warehouses. Innovatively crafted schema designs and data loading strategies, ensuring optimal performance and scalability of Snowflake environments. Loading data from Azure factory into Snowflake using Pipelines. Developement of SQL scripts.

ECOLAB

    Designed, implemented and Orchestrated Scalable robust Snowflake Data Warehouses. Innovatively crafted schema designs and data loading strategies, ensuring optimal performance and scalability of Snowflake environments.

ABB

    Create, test, and implement enterprise-level apps with Snowflake.

Fifth Third Bank

    Experience in Designing, Developing, Testing, Documenting of ETL Jobs.

ABB, Manufacturing domain

TCS
Aug, 2022 - Mar, 2023 7 months

    Role : Snowflake developer Client : US Language : SQL server Tools: Snowflake, Qlik compose, SQL server Create, test, and implement enterprise-level apps with Snowflake Solve performance issues and scalability issues in the system Build, monitor, and optimize ETL and ELT processes with data models. Engineered efficient ETL processes using Snowflake tasks and streams, automating data ingestion and transformation workflows.

FTB, Banking Domain

TCS
Aug, 2021 - Aug, 20221 yr

    Role : Junior ETL developer Client : US Language : SQL server Tools: IBM Datastage, Talend, AQT, Unix, Service now Experience in Designing, Developing, Testing, Documenting of ETL Jobs and monitoring the application to process data  using SQL and Unix for processing data. Proficiency in writing and debugging complex SQL queries Engaged in Patching and testing of the Data in production monthly and quarterly. Reports are viewed and processed on Tableau. Extract, Transform, Load process, and technological infrastructure implementation. debugging and fixing issues during development and implementation of given requirements.

Education

  • Bachelor of engineering

    KSIT (2021)

  • Bachelor of Engineering

    K S INSTITUTE of Technology

Interests

  • Gyming
  • Travelling