Ruchika Kokate

Ruchika Kokate

Azure Data Engineer
India

نبذة عني

Data Engineer with nearly 5 years of experience designing and delivering scalable data pipelines, cloud data platforms, and analytics solutions across Azure, Databricks, and AWS ecosystems. Specialized in Azure Data Fact…

الخبرة

Consultant - Data Engineer

Deloitte
May 2025 - حتى الآن · 1 سنة 5 أشهر

<p>Modernizing manual Excel-based KPI reporting into automated Databricks pipelines, using Delta tables as the governed and traceable reporting layer.<br>
Building data workflows to ingest inputs from Aspen and SharePoint Excel files, apply business rules, and publish curated outputs to Power BI.<br>
Developing PySpark, Spark SQL, and SQL logic for SLA metric calculations, sanity checks, reconciliation, archive handling, and historical data loads.<br>
Implementing validation and reconciliation controls to detect incorrect manual changes, reduce data inconsistencies, and improve trust in business-critical reporting.<br>
Automating monthly data refresh, validation, archive handling, and SLA/KPI calculations, reducing dependency on offline Excel-based manual processing.<br>
Preparing architecture and unit testing documentation to support sprint-based delivery, controlled development, production readiness, and auditability.<br>
Coordinating releases and deployments using Bitbucket, Jenkins, VS Code, and Jira within a client-facing Agile delivery model.</p>

Associate Consultant - Data Engineer

Infosys
Sep 2024 - May 2025 · 8 أشهر

<p>Built scalable Databricks-based PySpark ETL pipelines to ingest and transform multi-source data into Delta Lake on AWS S3.<br>
Designed modular batch pipelines to deliver curated, analytics-ready datasets for reporting, analytics, and downstream consumption.<br>
Developed reusable transformation logic using PySpark and Spark SQL for data cleansing, standardization, validation, and business rules.<br>
Implemented Delta Lake features including schema enforcement, versioning, and ACID transactions to improve data reliability and consistency.<br>
Optimized Spark jobs using partitioning, query tuning, and efficient join strategies to improve processing performance and pipeline stability.<br>
Added logging, validation checks, and failure-handling mechanisms to improve production monitoring and reduce execution issues.<br>
Worked with business and analytics stakeholders to translate reporting needs into scalable and maintainable data engineering solutions.</p>

Application Development Analyst

Accenture
Jun 2021 - Sep 2024 · 3 سنوات 3 أشهر

<p>Developed ETL pipelines using Azure Data Factory and Azure Databricks to process ECOM and EPOS data for business reporting and analytics.<br>
Built PySpark, Spark SQL, and SQL transformations to read, cleanse, validate, and write data across Azure Data Lake and downstream systems.<br>
Created ADF workflows using Linked Services, Datasets, Copy Activity, and orchestration activities to automate data movement.<br>
Developed SQL queries, joins, subqueries, and validation checks to support complex reporting and reconciliation requirements.<br>
Supported production validation, data cleanup, process documentation, and issue resolution to maintain reliable data delivery.<br>
Collaborated with business stakeholders in Agile sprint cycles to understand requirements and deliver data engineering solutions.</p>

المهارات

Python PySpark SQL Databricks Spark SQL Delta Lake Databricks Workflows Azure Data Factory Azure Databricks Azure Data Lake Storage Azure Blob Storage Azure SQL Azure Synapse Analytics Azure Logic Apps AWS S3 SharePoint SQL Server Snowflake Hive APIs SFTP Salesforce Aspen Bitbucket Jenkins Git Jira VS Code CI/CD
الإبلاغ عن هذا الملف الشخصي؟