Ritika Verma
Pune
Summary
- Driven Data Warehouse & Business Intelligence Developer with close to 5 years of professional experience in designing and developing Data Warehouses using Snowflake, Microsoft Azure, Teradata, and SQL.
- Core Expertise Comprehensive knowledge of Snowflake Cloud, Snowflake Database (schema and table structures), Snowflake Data Sharing, Cloning, and Time Travel, and Snowflake SQL.
- Comprehensive knowledge of ETL Processes and Tools. Efficient Module Lead with skills in academic leadership and quality management.
- Communicates well with managerial and administrative staff, boosting team effectiveness.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Module Lead Developer
Amdocs
Pune
01.2024 - Current
- Working for client on E-Datamart project
- 80% snowflake query Opitimization
- Source to Target Mapping was done
- Handle Production deployments and support
- Worked on Snowflake streams and dashboards
Technical Lead
Amdocs
Pune
04.2023 - 01.2024
- Led a project from inception to completion, meeting all given deadlines for the sprints.
- Established optimized conditions for Development, Non-prod, and Production scenarios.
- Created a wrapper to archive and store source files at the end of each execution.
- Took responsibility for leading and collaborating with the team to overcome challenges and meet deadlines.
- Demonstrated expertise in configuring and establishing project infrastructure within Azure Linux VM
Software Developer
Amdocs
Pune
11.2020 - 03.2023
- Responsible for migrating data from Teradata to Snowflake
- Responsible for using the copy command to bulk load raw data into the staging area
- Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, and Tasks
- Hands-on experience with Snowflake cloud data warehouse and Azure Data Lake Storage to integrate data from multiple source system into Snowflake table
- Worked on the development, enhancement, and maintenance of snowflake database applications
- Worked on automation scripts using python, which helped the project migrate more quickly
- Actively engaged in data migration activities, worked on Teradata data extraction, data transfer to staging, and data loading into Snowflake tables
- End to End Management and Monitoring of Code Movement Activities, Deployment Support.
Software Developer
Amdocs
Pune
08.2019 - 11.2020
- Gathered requirements and developed Teradata SQL queries based on the design document provided by the client
- Created scripts to load the data into the warehouse tables using Teradata utilities like Bteq, mload, TPT, fast load
- Worked on performance tuning to enhance the code and speed up execution
- Created Teradata Parallel Transporter (TPT) scripts to export the data from tables and to generate the extract files
- Carried out Unit Testing and pushed the code to GIT for further processing.
Education
Bachelor of Engineering - Computer Science
Rajeev Gandhi Proudyogiki Vishwavidyalaya
06.2019
Skills
- Snowflake
- Microsoft Azure
- SQL
- Linux Shell Scripting
- Python
- Jenkins
- Git Hub
- IBM Tivoli Workload Scheduler
- Erwin Data Model
Certification
- Completed the AZ-900: Microsoft Azure Fundamentals Certification: Microsoft Certified: Azure Fundamentals
- Received the Snowflake Web UI Essentials: Hands On Essentials - Data Warehouse
Coreexpertise
- Comprehensive knowledge of Snowflake Cloud, Snowflake Database (schema and table structures), Snowflake Data Sharing, Cloning, and Time Travel, and Snowflake SQL.
- Comprehensive knowledge of ETL Processes and Tools.
Awards
OutsideTheBoxThinker - Amdocs (Sep 2021)
Accomplishments
- Recognized for achieving 80% query optimization
Timeline
Module Lead Developer
Amdocs
01.2024 - Current
Technical Lead
Amdocs
04.2023 - 01.2024
Software Developer
Amdocs
11.2020 - 03.2023
Software Developer
Amdocs
08.2019 - 11.2020
Bachelor of Engineering - Computer Science
Rajeev Gandhi Proudyogiki Vishwavidyalaya
Similar Profiles
Nitish RaiNitish Rai
Scrum Master/Team Lead at AmdocsScrum Master/Team Lead at Amdocs
Pranjal SharmaPranjal Sharma
Advanced Software Developer at AmdocsAdvanced Software Developer at Amdocs
Ayush ShrivastavaAyush Shrivastava
Data Warehouse Developer at AmdocsData Warehouse Developer at Amdocs
Sandeep VaswaniSandeep Vaswani
Technical Business Analyst at AmdocsTechnical Business Analyst at Amdocs
Vaibhav SuryawanshiVaibhav Suryawanshi
UI Developer at Xcaliber Infotech Private LimitedUI Developer at Xcaliber Infotech Private Limited