Priyanka Meshram
Navi Mumbai
Summary
Detail-oriented, organized, and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.
Overview
8
8
years of professional experience
Work History
Engineering LEAD
Persistent Systems
10.2022 - Current
- Worked on SnowPipe, Tasks, Streams, Dynamic tables.
- Used Zero clone future for testing.
- Worked on stored procedures, copy into, stages, Storage integration, file formats etc.,
- Performed batch data loads and continuous data loads.
- Worked in permanent tables, transient tables, View, Materialized view.
- Good knowledge on masking policy, UDFs, RBAC.
- Worked on Task dependencies
- Worked with DBT Models, Macros, Snapshots, Tests etc.
- Used DBT to build schema’s and transform data in the warehouse by leveraging Snowflake.
- Worked on Snowflake transformations.
- Used Jinja to extend the functionality of DBT and leveraged macros from packages.
- Worked on custom materialized.
- DBT Setup and Configuration
- Worked on Environment variables.
- Worked on GitHub workflow for deployment.
- Used GitHub action for deployment.
Worked on IICS tool – Source Analyzer, Transformation Developer, Mapping Designer and Mapplet Designer. - Involved in the development of Informatica mappings and also tuned for better performance. In the Mappings most of the Transformations were used like the Source Qualifier, Expression, Filter, Aggregator, Look Up, Update, and joiner, Sequence Generator, Sorter, Rank and Router.
- Used Unconnected Look Ups with the combination of Update Strategy migration development.
DBT Developer
Sellcraft Global Solutions
04.2021 - 08.2022
- Understanding the requirements.
- For Data transformation, modelling and loading we used cloud DBT tool.
- Worked on DBT macros, models, packages, seeds, snapshots, DBT commands, automation testing, job scheduling, security using CI/CD pipeline, document generation, environment setup and configuration, connection with database, DBT upgradation.
- Development of the requirement within the given time line.
- Support for Testing Team , SAT , UAT and PRODUCTION.
- Resolving issues ASAP.
- Prod job scheduled using Tidal and maintained all deployment process on CREQ tool.
Software Developer/DBT Support
Golden Source International Pvt. Ltd
09.2018 - 01.2021
- Understanding the requirements.
- To perform analysis on various vendor fields, layouts in order to prepare logical mapping to appropriate data model placeholder.
- To perform a detailed impact analysis into the Golden Source product against any Change notification from different vendors.
Assistant Manager
Reliance Communications
06.2016 - 09.2018
- Understanding the requirements.
- Development of the requirement within the given time line.
- Conduct Unit Testing and Documentation .
- Support for Testing Team , SAT , UAT and PRODUCTION.
- Resolving issues ASAP.
Education
B.E - Computer Science
MUMBAI UNIVERSITY
Bharati Vidyapeeth, Kharghar01.2016
HSC -
DR.D.Y.PATIL JUNIOR COLLEGE
Nerul01.2012
S.S.C -
Maharashtra State Board
Navi Mumbai01.2010
Skills
- SQL
- Oracle PL/SQL
- DBT
- Snowflake
- Sybase
- Unix Command
- Python
- MySQL
- Toad
- Plus
- Eclipse
- SQL Developer
- Putty
- Jenkins (build process)
- JIRA
- AWS Cloud
- Postgress
- Tidal
- Clear Quest
- Clear Case
- GitHub
- SVN
Personal Information
- Date of Birth: 02/10/94
- Gender: Female
- Nationality: Indian
- Marital Status: Married
Awards
- STELLAR AWARD WINNER, Golden Source International Pvt. Ltd, Oct 2019 - Apr 2020, for excellent performance
- Awarded Top Talent 2024.
- Recognized three times with the Bravo Team Award.
- Honored three times with the HighFive Team Award.
- Certified in SnowPro Core.
Disclaimer
I hereby assure that the above details provided are true, correct and complete to the best of my knowledge.
Technicalsummary - Skills
- SQL, Oracle PL/SQL, DBT, Snowflake, Sybase, Unix Command, Python, MySQL, Toad, SQL
- Plus, Eclipse, SQL Developer, Putty, Jenkins, JIRA, DBT, Snowflake, Azure Devops, Postgress, Tidal, Clear Quest, Clear Case, GitHub, SVN, Azure Devops, Microsoft Windows XP, 7, 10, MAC, Oracle 11 G
Languages
English
Advanced (C1)
Hindi
Advanced (C1)
Marathi
Advanced (C1)
Timeline
Engineering LEAD
Persistent Systems
10.2022 - Current
DBT Developer
Sellcraft Global Solutions
04.2021 - 08.2022
Software Developer/DBT Support
Golden Source International Pvt. Ltd
09.2018 - 01.2021
Assistant Manager
Reliance Communications
06.2016 - 09.2018
B.E - Computer Science
MUMBAI UNIVERSITY
HSC -
DR.D.Y.PATIL JUNIOR COLLEGE
S.S.C -
Maharashtra State Board
Similar Profiles
Abhinaw KumarAbhinaw Kumar
Project Lead Rust Developer at Persistent SystemsProject Lead Rust Developer at Persistent Systems
Rishi AroraRishi Arora
Product Manager at Persistent SystemsProduct Manager at Persistent Systems
Chitralekha SahooChitralekha Sahoo
Project Manager at Persistent SystemsProject Manager at Persistent Systems