Default profile banner
MG

Mansi Gupta

@mansig

Data Engineer at L&T Construction

Chennai, India

L&T ConstructionJabalpur Engineering College

Mansi Gupta is an experienced Data Engineer with expertise in designing and developing scalable data pipelines. She has a proven track record of utilizing Apache Spark and PySpark to process large volumes of data and build robust BigData lake architectures using HDFS. Her skills include developing critical APIs and integrating various systems, complemented by proficiency in Python, SQL, and cloud tools.

Experience

Data Engineer

L&T Construction

Full-time•Aug 2021 - Present•Chennai, India

Designed and developed scalable data pipelines using Apache Spark to process a large volume of data on a daily basis, incorporating both incremental and full refresh strategies to update the data lake. Developed a versatile script for seamless ingestion of data from various APIs into the data lake, enhancing data accessibility and integration capabilities. Utilized PySpark to develop denormalized tables of EIP 4.0 modules on a document level, enabling streamlined reporting and analysis of data. Spearheaded the development of a robust On-premise BigData lake architecture using HDFS and Apache Spark, orchestrating a multi-node cluster for efficient data ingestion and processing operations. Played a pivotal role in creating essential APIs and stored procedures for the Asset Management System module of EIP 4.0, enabling seamless integration and efficient management of assets. Developed critical APIs for the Logsheet mobile application, facilitating the seamless capture and retrieval of asset details for enhanced efficiency in asset management.

Intern

Infosys Ltd.

Internship•Feb 2021 - May 2020•Chhatarpur, India

Designed and implemented an agile methodology framework in Excel, streamlining project management processes and enhancing team collaboration and productivity. Acquired proficiency in MSBI tools and successfully implemented them in projects, leveraging their capabilities for efficient data integration, analysis, and reporting.

Education

Jabalpur Engineering College

B.Tech

Computer Science and Engineering

Aug 2017 - Jun 2021•Grade: 7.89/10

Licenses & Certifications

AZ-900 Microsoft Certification

Microsoft

• No expiration

Power BI Beginners

• No expiration

Container Orchestration using Kubernetes

• No expiration

Skills

Python
C
SQL
PySpark
MSSQL
MySQL
Apache Spark
Hadoop
SSMS
Azure Data Studio
Power BI
Jupyter
ASP.net core Web API
Windows
Unix/Linux