Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Priyanka Kodlipet Jalendra

Northlake

Summary

Experienced Senior Data Engineer with over 15 years of expertise in developing and implementing advanced data solutions using Snowflake, Azure, and BI technologies. Proven ability to excel in fast-paced, dynamic work settings and consistently deliver top-notch, scalable data solutions.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Senior Azure Data Engineer

Kroger
09.2024 - Current
  • Redesign Snowflake ETL framework with an event-driven Dynamic ETL Framework
  • Objectives of this new design are: transition from scheduled ETL to event-driven to eliminate delays getting data into Snowflake, Split large transactional files into multiple smaller files that can be processed into Snowflake faster, in parallel, using cheaper compute, eliminate inter-table dependencies in the bronze and silver layer, to reduce the impact zone of issues and better align processing with demand
  • Architecture & Design: Designed an event-driven ETL framework using Snowflake, integrated with cloud services such as Azure Event Grid, Snowpipe, and external stages (Azure Blob).
  • Automation & Ingestion: Implemented Snowpipe and auto-ingestion mechanisms to load files from cloud storage automatically upon arrival, significantly reducing latency.
  • Scalability & Modularity: Developed parameterized and reusable SQL and stored procedures in Snowflake for transformation logic, enabling support for multiple data sources and event types.
  • Event Orchestration: Integrated with orchestration tools such as [Apache Airflow / Azure Data Factory / AWS Step Functions], to handle event triggers, retries, and conditional flows.
  • Monitoring & Alerting: Built robust monitoring using Snowflake’s INFORMATION_SCHEMA and cloud-native tools to capture failures, monitor file loads, and send real-time alerts.

Senior Data Engineer

Kroger
04.2023 - 09.2024
  • · Implement efficient Extract, Transform, Load (ETL) processes using Azure Data Factory, Databricks, or other relevant tools.
  • Optimize data workflows to ensure the timely and accurate delivery of data to end-users and downstream systems.
  • Integrate diverse data sources, both on-premises and cloud-based, to create a unified and comprehensive view of the organization's data.
  • Implement data quality checks and validation processes to ensure the integrity and accuracy of data.
  • Monitor and optimize the performance of data pipelines and databases, identifying and addressing bottlenecks and inefficiencies.
  • Collaborate with cross-functional teams, including data scientists, analysts, and software developers, to support their data needs and ensure alignment with business objectives.
  • Automated repetitive tasks and business processes using Logic Apps, such as order processing, email notifications, and data validation.
  • Implemented Event-driven architecture to reduce the latency between processes by triggering dependent processes immediately when a process completes. we leverage Azure Event Grid Topic to publish / subscribe to custom events.

Senior Azure Data Engineer

Nestle Waters, Cognizant Technology Services
08.2020 - 08.2022
  • Worked as a Senior Azure Data Engineer as well as a lead from offshore in Migrating solutions involving Azure Data Factory & Azure Data Bricks to Azure Synapse Analytics.
  • Worked on providing solutions using Azure Data Factory & Azure Data Bricks to ingest data from source layer to enterprise layer in Azure Data Lake.
  • Implemented Incremental load using Azure pipeline to handle change data capture.
  • REST API data ingestion through Azure Data Bricks & Azure Data Factory Pipeline development for different sources for different types of files.
  • Worked on configuring Integration runtime, scheduling triggers for ADF, using key vaults for storing credentials.
  • Significant experience in designing, developing, and deploying complex big data solutions using Azure Databricks.
  • Comprehensive understanding of Azure SQL for transactional and analytical data processing.
  • Knowledge of DevOps principles and experience with CI/CD pipeline implementation using Azure DevOps.
  • Provided ongoing support and maintenance for data solutions in production.
  • Collaborated with cross-functional teams to drive business outcomes and achieve project goals.
  • Worked on SQL & MSBI to extract, transform, and load data from various sources into a centralized database.
  • Used SQL stored procedures extensively for the enhancements & change requests for the ETL load.

Business Intelligence Lead

Nestle Waters, Cognizant Technology Services
12.2017 - 08.2020
  • Excels in Root Cause analysis of the data in on prem system & providing the appropriate solution & eliminates the re iteration of the issue.
  • Managed and implemented two Server Migration SQL 2012 and SQL 2016 of SQL Data Warehouse applications including server capacity planning, coordinating DBA team, parallel processing and data validation, deliverables scheduling, GO live execution and Hypercare.
  • Maintained code repository using Azure DevOps throughout development, code review and deployment ready phases.
  • Made sure on-premises Data Warehouse data available for Azure cloud data ingestion.
  • Performed enhancements, automation and streamlined on-premises application.
  • Responsible for the design & development of MSBI packages, unit testing & code deployment in on prem system.
  • Used critical thinking to break down problems, evaluate solutions and make decisions.
  • Led projects and analyzed data to identify opportunities for improvement.

Senior Business Intelligence Developer

Global Foundries, Cognizant Technology Services
06.2016 - 12.2016
  • Development and enhancement of SSRS reports such as Parameterized, Chart, Graph, Linked, Dashboard, Drill-down, and Drill-through reports.
  • Worked as a senior developer and was responsible for end –end development & testing of the reports.
  • Identified the issues in the earlier stages of development which reduced rework and escalations.
  • Worked as a Proactive team player, always shouldering the adhoc work.
  • Worked on different approaches to improve the performance of the reports & thoroughly analyzed the impact analysis.

Senior Business Intelligence Developer

Microsoft Corporation, Cognizant Technology Services
12.2015 - 06.2016
  • Worked as an Individual contributor in this project.
  • Current design was taking a lot of time to load 15M data, and proposed a partitioning approach to load into DB which saved half of the time of data load.
  • As the data needs to be shown in both roll up and roll down approaches in HTML dashboards, work on the backend ETL very carefully to avoid duplication of data and any missing values.
  • Worked on a few of the query tuning approaches to improve the performance of the queries like using CTEs, proper indexing etc.
  • Worked on HTML Dashboards to show the granularity of data using different charts and layouts.
  • Optimized the stored Procedure for slow performance by referring to execution plans. This helped in eliminating Bookmark lookups and adding covering indexes, following best practices for creating indexes on columns.
  • Worked on Column store indexes for Fact tables to improve the loading of huge data.
  • Creation of tables, data relationships, queries, schedule sql agent jobs and plan backup/restore on lower environments.
  • Peer Reviewing, Unit Testing, Coordination of UAT and production rollout.
  • Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment. Developed and deployed SSIS packages in Production Server.

Senior Business Intelligence Developer

Fallon Community Health Plan, NTTDATA Global Delivery Services
01.2012 - 01.2015
  • Worked on different roles right from a developer to team lead and coordinated with the onsite team.
  • Gained good and strong knowledge on Data warehousing concepts.
  • Learned the business knowledge of the health care domain.
  • Very much involved with the data modeling team in redesigning the data model.
  • Mentored the team members and helped them to complete their tasks on time & also involved in peer reviews to identify the gaps in code development.
  • Involved in creating complex ssis packages which need to adhere to Data warehousing concepts.
  • BIML, which helped to load the data in 160 packages from source system to ODS in one shot, it completely eliminated manual tasks and saved a lot of time and $ value.
  • Worked on CDC approach which is a new feature in SQL Server 2008 R2.
  • Development and validation of use cases in SSIS packages by generating mock test data.
  • Development of packages containing tasks to load data from source to destination, used containers, event handling, variables, logging, configurations and dynamic T-SQL query formation.

Business Intelligence Developer

Tesco Hindustan Service Center
10.2008 - 01.2012
  • Created database objects like tables, stored procedures, views, triggers, constraints, user defined functions in MSSQL to facilitate data consistency and created SQL Agent jobs.
  • Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
  • Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2008 Integration services.
  • Created cascading stored procedures to avoid the code length and complexity in the single stored Procedure.
  • Was involved in Unit testing of the package & defect fixes.
  • Scheduling And Monitoring the ETL packages for Daily load in SQL Server Job Agent.

Education

BE - Computer Science

Malnad College of Engineering
05.2008

Skills

  • Snowflake
  • Azure Data Factory
  • Azure Data Bricks
  • Azure SQL
  • MSBI
  • MSSQL

Certification

  • 70-778 Analyzing and Visualizing Data with Power BI-Edx
  • Certified Azure Data Engineer DP 200, DP 201 & AZ900 Exams

Timeline

Senior Azure Data Engineer

Kroger
09.2024 - Current

Senior Data Engineer

Kroger
04.2023 - 09.2024

Senior Azure Data Engineer

Nestle Waters, Cognizant Technology Services
08.2020 - 08.2022

Business Intelligence Lead

Nestle Waters, Cognizant Technology Services
12.2017 - 08.2020

Senior Business Intelligence Developer

Global Foundries, Cognizant Technology Services
06.2016 - 12.2016

Senior Business Intelligence Developer

Microsoft Corporation, Cognizant Technology Services
12.2015 - 06.2016

Senior Business Intelligence Developer

Fallon Community Health Plan, NTTDATA Global Delivery Services
01.2012 - 01.2015

Business Intelligence Developer

Tesco Hindustan Service Center
10.2008 - 01.2012

BE - Computer Science

Malnad College of Engineering

Similar Profiles

CREATE PROFILE