Open to opportunities

Mohit Motwani

@mohitmotwani1

Message

Data Engineer with expertise in analytics and ETL pipelines.

India

Message

What I'm looking for

I am seeking a role that fosters innovation and offers opportunities for growth in data engineering and analytics.

I am a Data Engineer with over 3 years of experience specializing in data modeling, analytics, and the development of ETL and ELT pipelines. My journey has been marked by a commitment to innovation and efficiency, exemplified by my ability to streamline workflows and significantly reduce turnaround times. I have a proven track record of saving resources and enhancing operational efficiency through scalable solutions.

At CoinDCX, I designed and implemented a Lambda ingestion pipeline that achieved near-zero downtime and resulted in substantial cost savings. My experience at Citi further honed my skills in data profiling and quality checks, where I successfully improved data accuracy and processing times. I am passionate about leveraging advanced technologies, including AI and big data tools, to drive impactful results.

Experience

Work history, roles, and key accomplishments

Current

Software Engineer – Data

Current

CoinDCX

Sep 2024 - Present (10 months)

Designed and implemented an end-to-end Lambda ingestion pipeline with actionable alerts, schema evolution, and auto-repair, achieving ~0% downtime across systems and 20% cost savings. Developed and launched a customer-facing, AI-powered LLM chatbot with personalized, proactive problem-solving capabilities, enhancing customer satisfaction by 25%.

Python Spark AWS Lambda LLM Data Modeling ETL ELT Automation

Big Data Engineer

Citi

Aug 2023 - Present (1 year 11 months)

Implemented an automated solution for data profiling and quality checks in Python and PySpark, resulting in a 15% improvement in data accuracy and reducing data processing time by 25%. Optimized SQL queries and Spark jobs through performance tuning techniques such as bucketing, salting, partitioning, and caching, resulting in a 20% improvement in overall job efficiency.

Python Pyspark SQL Spark Data Quality Performance Tuning ETL Data Processing Big Data

Data Analyst

Citi

Jul 2022 - Present (3 years)

Realized a 40% reduction in average Turnaround Time (TAT) through developing and automating a key ETL data pipeline and achieved significant resource optimization by saving 1.5 FTE. Achieved cost savings of $50,000 by implementing data-driven decision-making strategies to reduce over-remediation.

ETL Data Pipelines Data Analysis SQL Data Driven Statistical Analysis

Subject Matter Expert (Statistics)

TutorBro

Aug 2019 - Present (5 years 11 months)

Mentored and facilitated clients on statistical concepts, resulting in a 15% increase in client satisfaction. Assisted with queries on probability, distributions, hypothesis testing, Regression, and ANOVA.