Mitali K.

Data Engineer @ Shiv Nadar School

Country

India

City

Jaipur

Industry

Information Technology & Services

Skill

Azure Data Factory, Azure Databricks, Apache Spark, Microsoft SQL Server, Communication, SQL, Microsoft Word, C (Programming Language), C++, HTML, Microsoft PowerPoint, Microsoft Access, Python (Programming Language), Cascading Style Sheets (CSS)

Experience

Data Engineer

Shiv Nadar School

2025-8 - Present · 1 yr 2 mos

Intern

BM INFOTRADE PRIVATE LIMITED

2024-11 - 2025-9 · 11 mos

Jaipur, Rajasthan, India

• Designed and developed scalable ETL pipelines ingesting data from sources like Azure Data Lake Storage, SQL Server, PostgreSQL, SAP ECC (CDC), Microsoft Navision, and Business Central. • Integrated Apache Kafka for streaming data ingestion and applied transformations using Azure Synapse Pipelines and Azure Data Factory. • Utilized AWS S3 and AWS Glue for additional cloud integration tasks during cross-cloud data migration and processing. • Built a Medallion architecture (Bronze, Silver, Gold layers) with transformation logic implemented in Data Flows. • Applied Slowly Changing Dimension Type 2 (SCD2) techniques for maintaining historical data integrity. • Orchestrated control flow using Lookup, ForEach, If Condition, and Script activities in ADF. • Set up monitoring and alerting through Azure Monitor and Log Analytics for pipeline health and SLA compliance. • Designed PostgreSQL-based data marts for Power BI dashboards and ad hoc reporting.