Deepika Jain
Data Warehouse Software Developer
Pune
Summary
Accomplished Data Warehouse/Business Intelligence Developer with a proven track record at Amdocs, enhancing data quality management and ETL development processes using snowflake. Excelled in migrating applications to Snowflake, leading to a 200-hour reduction per sprint cycle. Skilled in data modeling and business analysis, demonstrating exceptional problem-solving and teamwork abilities.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Data Warehouse / Business Intelligence Developer
Amdocs
11.2021 - Current
- Working as an ETL Developer for client AT&T:
- · Developed 150+ Snowflake SQL scripts. Used Snowflake features of handling files and unstructured data in external stages. Developed file to table, table to table jobs and created stored procedures.
- · Worked in team to migrate application from Teradata to Snowflake and Azure VM, converted BTEQ SQL scripts to Snowflake SQL scripts.
- · Efficiently used best practices of Snowflake for performance and query optimization.
- · Created TWS for sprint cycles and deployed jobs in production.
- · Performed ST and UAT for Snowflake jobs developed.
- · Working on production fixes where migrated tables are analyzed and resolved for data and count match. Worked as a Data Modeler for client AT&T:
- · Modeled 1000+ views and 500+ tables as per Business requirement in Snowflake Model.
- · Created logical/physical data models in Erwin via reverse engineering, forward engineering and created custom views, materialized views, and secured views in Snowflake.
- · Implemented Row level security and cross schema access on data models and defined constraints on table columns.
- · Migrated Teradata Tables and Views DDL’s into Snowflake Data Model.
- · Performed UAT for different tables and views modeled on Snowflake.
- Worked as a Data Analyst for client AT&T:
- · Analyzed and proposed End-to-End ETL development plan for project which saved approximately 200 work hours in every sprint cycle.
- · Aggressively used Excel to carry out analysis for huge volume of scripts, tables, jobs, and cleansing of data.
- · Analyzed jobs and complexity to be developed in sprint cycles.
- · Worked as developer where-in received BRs from client and developed or modified jobs accordingly in development server and deployed them over production in a CR window and validated deployments successfully.
- · Worked on Migration/Transformation Projects.
- . Used GIT for deployment activities.
Senior Systems Engineer
Infosys Ltd.
07.2018 - 11.2021
- Worked in Automation team to generate and publish iso image using shell script
- Automated various process using shell script
- Handled scripting tasks for debugging jobs.
- Worked as database admin and ran SQL queries to
Education
Bachelor of Engineering - Computer Science
Wal Chand Institute of Technology
Solapur 07.2014 - 07.2018
Skills
ETL development
Snowflake
Data dashboard design
Business Analysis
Data Quality Management
Sql
Teradata
Data Modelling
Languages
English
Upper intermediate (B2)
Hindi
Upper intermediate (B2)
Certification
Azure Fundamentals AZ-900
Timeline
Data Warehouse / Business Intelligence Developer
Amdocs
11.2021 - Current
Senior Systems Engineer
Infosys Ltd.
07.2018 - 11.2021
Bachelor of Engineering - Computer Science
Wal Chand Institute of Technology
07.2014 - 07.2018
Similar Profiles
Charles AlmsCharles Alms
Software Engineer at AmdocsSoftware Engineer at Amdocs
Surbhi SharmaSurbhi Sharma
Fiber Engineer Advance at AmdocsFiber Engineer Advance at Amdocs
Rishabh ShuklaRishabh Shukla
Software Engineer at AMDOCSSoftware Engineer at AMDOCS