Zensar Technologies
Website:
zensar.com
Job details:
DEENA KUMAR K
Lead
Bangalore, India | +91-8197436789 | Deena.msbi99@gmail.com
PROFESSIONAL SUMMARY
Azure Data Engineer with 13+ years of experience delivering enterprise-scale data integration and analytics platforms. Expertise in Azure Data Factory, Azure Databricks (PySpark), Delta Lake, Unity Catalog governance, Delta Tables, and real-time streaming with Kafka/Event Hub. Proven ability to optimize performance, improve SLA compliance, and support production-grade deployments across UAT/PROD environments.
CORE TECHNICAL SKILLS
- Azure Data Factory (ADF), Azure Databricks, ADLS Gen2, Azure Synapse
- PySpark, Spark SQL, Delta Lake, Partition Optimization
- Medallion Architecture (Bronze/Silver/Gold), Delta Tables (DT), Unity Catalog
- Kafka, Azure Event Hub Streaming Pipelines
- Git, Jira, Monitoring & Debugging
- SQL Server, T-SQL, SSIS, SSRS, SSAS, Performance Tuning
PROFESSIONAL EXPERIENCE
Tech lead – Zensar Technologies (Client: Cisco Systems)
Mar 2022 – Present
- Designed scalable Azure Data Factory pipelines for full & incremental ingestion into Cloud Data Warehouse.
- Built Databricks PySpark notebooks processing multi-TB datasets with optimized partitioning and Spark tuning.
- Implemented Delta Lake + Medallion Architecture improving data quality and reliability.
- Enabled governance using Unity Catalog and automated ETL with Delta Live Tables.
- Integrated Kafka/Event Hub streaming sources for near real-time analytics use cases.
- Improved SLA compliance and reduced pipeline failures by ~30% through proactive monitoring and RCA.
MSBI Senior Software Engineer – Theorem India (Client: KBR)
Apr 2021 – Mar 2022
- Developed enterprise ETL solutions using SSIS, SQL Server, SSAS, and SSRS.
- Migrated ETL workloads from SQL Server 2008 → 2012 with minimal downtime.
- Optimized indexing and query performance improving batch load efficiency by ~25%.
MSBI Senior Software Engineer – IQVIA (Swiss BI)
May 2019 – Apr 2021
- Delivered pharma analytics pipelines supporting 1700+ pharmacies and 120+ business clients.
- Automated daily batch loads and optimized long-running SQL workloads for reporting datasets.
MSBI Senior Software Engineer – IQVIA (P&G)
Apr 2018 – May 2019
- Built ingestion pipelines in Azure Data Factory loading data into ADLS and Azure SQL DW.
- Developed transformations using T-SQL and Azure Data Lake Analytics for customer insights.
MSBI Senior Software Engineer – Accenture (Pharma Sales Analytics: MIBI & SDM)
Nov 2015 – Apr 2018
- Developed BI solutions using SSIS, SSRS, SSAS, MDX, and SQL Server for pharma sales reporting.
- Built ETL pipelines to process distributor sales data and generate integrated SDM analytics.
- Designed OLAP cubes with complex MDX calculations to support dashboards and insights.
- Performed SQL performance tuning and migration from SQL Server 2008 to 2012.
- Supported deployments, unit testing, documentation, and resolved critical production issues.
BI MSBI Senior Software Engineer – Accenture (CISO SOC / SIEM Dashboard)
May 2014 – Sep 2015
- Designed database schema and ETL workflows for security compliance and vulnerability dashboards.
- Built SSIS packages ingesting incident and server compliance data into reporting systems.
- Developed stored procedures and optimized SQL queries for performance improvements.
- Delivered reusable ETL components and supported enhancements across SIEM modules.
ETL & BI Developer – Cognizant (Wells Fargo)
Jan 2014 – May 2014
- Developed SSIS ETL packages to load banking datasets into reporting environments.
- Migrated SSIS packages from SQL Server 2005 to 2008 with configuration and logging setup.
- Created and deployed SSRS reports with automated subscriptions.
- Tuned SQL queries and stored procedures for improved performance.
BI Developer – Cognizant (Think Finance – Lending Analytics)
Dec 2012 – Nov 2013
- Supported enterprise data warehouse reporting for multiple online lending products.
- Monitored ETL job health, fixed production issues, and ensured stable batch processing.
- Developed new SSRS reports and optimized heavily used stored procedures.
- Assisted in SQL Server migration testing from 2008 to 2012.
EDUCATION
B.Sc. Computers – Sri Venkateswara University (2009)
Bottom of Form
Click on Apply to know more.