Vaishnavi Potdar

About Vaishnavi Potdar

Experienced Data engineer focused on the delivery of client engagements primarily within the Life Sciences/Pharma domainExperience in all facets of project life cycles from concept to completion and support. Experience in designing SFDC Data integration/Migration solutions using Cloud based technologies like Informatica cloud,Snowflake,Matillion with a proven ability to deliver client work and manage highly energized and focused teamsCore competencies include:· Performed Data profiling on Snowflake Tables with the help of IICS.Involved in Data Model Designing · Handling the processing of large JSON files via chunking them into small sizes which can be fit into VARIANT column · Experience in Building a Data Pipeline Using the Snowpipe and Firehose AUTOINGEST OPTION · Efficiently loaded the data from IDMC to snowflake using egress jobs and created a snowflake script to integrate the data using snowflake objects like tasks, streams, stored procedures, sequences etc· Efficient stored procedures on snowflake written to ingest data into target systems, performed transformations and manipulations to create a data warehouse · Created Unix scripts to connect to snowflake and execute Snowflake stored procedures through UC4· Created Technical design documents, Functional Design documents, Source Target mapping documents, unit test case documents and deployment plan for the applications · Involved in retrofit changes on snowflake and postgres · Created orchestrations in Matillion tool · Collaborated with cross-functional teams to develop and implement a new process · Analyzed and synthesized large datasets to uncover key insights and trends · Analyzed complex data sets to identify patterns and trends, providing actionable insights for clients· Expertise in SQL with related data analysis skills · Experience on IICS task development along with job scheduling and monitoring · Can Identify and understand architectural pieces, provide direction and technical expertise in design, development, and systems integration · Experience working with Agile/Scrum SDLC methodology· Ability to produce functional, technical, design documents · Sound SQL Databases knowledge like Oracle, MS SQL Server, and Snowflake Cloud DB along with Data warehouse background

Experience

1. Senior Data Engineer

   IBM

   Jan 2024 — Present

Education

• Vishwakarma Institute Of Technology

  Bachelor of Technology

  2014 — 2018