Kamini Rawat

Data Engineer with 3+ years of experience across Microsoft Fabric, Azure Data Factory, Azure Databricks (Databricks Unified Data Analytics Platform), Snowflake Data Warehouse, Apache Airflow, AWS and SQL. Skilled in designing and maintaining scalable data pipelines and architectures, data integration and transformation, database schema design and query performance tuning, and building data lakes and data warehouses that support business intelligence and analytics initiatives. Experienced applying analytical thinking to solve complex data challenges, collaborating with cross-functional teams to gather requirements, and implementing data governance, anonymization and security best practices to protect sensitive information.

Experienced guiding and mentoring junior team members and leading end-to-end project implementation.

Data Engineer at Kenexai (2025-01 – Present)

• Designed ETL/ELT pipelines using Azure Data Factory to automate financial transaction processing for trader and supplier data.
• Developed PySpark notebooks in Azure Databricks for data transformation, validation, and incremental loading.
• Automated workflow orchestration using Apache Airflow with scheduling, dependency management, and rigorous testing and monitoring to confirm data quality across pipeline runs.
• Integrated ERP, SQL, REST APIs, and AWS S3 data into Snowflake Data Warehouse for enterprise reporting, designing and optimizing database schemas and queries for performance tuning and efficient data storage and retrieval.
• Developed curated finance datasets and Power BI dashboards for transaction monitoring and analysis.
• Led data anonymization, RBAC, and governance efforts using Azure Databricks to protect sensitive financial information and support security best practices.
• Collaborated with cross-functional Finance teams and stakeholders to gather requirements and deliver scalable, client-focused, analytics-ready data solutions.
• Applied analytical thinking and problem-solving to optimize ETL pipelines and Spark workloads, resolving complex data challenges and improving performance and reliability.
• Guided and mentored junior data engineers on pipeline design and best practices while leading end-to-end delivery of the data platform — from requirements gathering through deployment — coordinating with the team and business stakeholders throughout.

Data Engineer at Dynatech Systems (2023-01 – 2025-12)

• Developed end-to-end data engineering solutions using Microsoft Fabric, including Data Factory, Lakehouse, OneLake, and Fabric Warehouse, building data lakes and data warehouses to support enterprise business intelligence initiatives.
• Built scalable ETL/ELT pipelines to integrate healthcare data from multiple enterprise systems.
• Developed PySpark transformations and implemented Medallion Architecture (Bronze, Silver, Gold) for analytics-ready data.
• Built semantic models and curated datasets for enterprise Power BI reporting, designing and tuning Fabric Warehouse schemas and queries for optimized performance and efficient data retrieval.
• Implemented incremental loading, data validation, reconciliation, and quality checks.
• Configured Microsoft Purview for data governance, lineage, metadata management, and compliance.
• Supported CI/CD deployment pipelines using Azure DevOps for Microsoft Fabric solutions.
• Collaborated with cross-functional healthcare SMEs and business stakeholders to gather requirements and deliver scalable, client-focused data platforms.

Business Analyst at Shaligram Infotech (2018-01 – 2019-12)

• Generated business leads through inbound/outbound calls, email campaigns, and online platforms.
• Managed client communication, requirement discussions, and project follow-ups.
• Prepared proposals and managed bidding on Upwork and Freelancer.
• Coordinated with technical teams for project estimation and proposal submissions.
• Maintained CRM records and tracked sales opportunities.

Software Engineer at Softvan Pvt. Ltd. (2017-01 – 2018-12)

Project: AI-Based Mall Customer Behavior & Emotion Analytics

• Developed an AI-powered retail analytics solution to analyze customer product interactions.
• Integrated face detection and emotion recognition for customer sentiment analysis.
• Built REST APIs and SQL databases for customer behavior analytics.
• Optimized real-time image processing and supported deployment activities.
• Collaborated with AI engineers to integrate computer vision models into production.

Bachelor of Engineering in Computer Science – LDRP Institute of Technology and Research

Diploma in Computer Engineering – VPMP Polytechnic