Mayur Hajare
Nagpur
Summary
Proficient in designing and implementing data pipelines, optimizing database performance, and ensuring data security. Expertise in SQL, Spark, and Python, with a focus on delivering scalable and reliable solutions. Strong analytical skills with a proven ability to translate complex requirements into actionable insights.
Overview
8
8
years of professional experience
1
1
Certification
Work History
IT Analyst
Tata Consultancy Services
Nagpur
10.2023 - Current
- Developed data pipelines with PySpark to process large-scale datasets efficiently.
- Ingested raw data from AWS S3 and DB2 as source and applying cleansing, filtering, and transformations using Spark.
- Utilized Parquet file format for intermediate data storage, optimizing performance and reducing costs.
- Loaded transformed data into Snowflake via the COPY INTO command for downstream analytics.
- Conducted performance tuning of PySpark jobs to enhance processing speed.
- Collaborated with cross-functional teams to gather business requirements and deliver data solutions.
- Used Git for version control and contributed to the CI/CD pipeline for automated deployments.
- Documented data flows, business rules, and technical designs for knowledge sharing.
Senior Executive
Infocepts Technologies pvt. ltd
Nagpur
05.2023 - 09.2023
- Developed complex queries for MSTR reports from Postgres database.
- Created views and Databricks jobs using Scala.
- Executed import and export of remote data to AWS S3.
- Implemented Spark with Scala and Spark SQL for efficient data processing.
- Managed data import/export into HDFS and Hive using Sqoop.
- Constructed Hive tables, performed data loading, and authored Hive queries.
- Optimized Hive queries for improved performance on large semi-structured datasets.
- Utilized Git for version control across multiple projects.
Lead Software Engineer
Persistent Systems Limited
Nagpur
07.2021 - 05.2023
- Extensively worked on SQL development, writing complex queries, joins, views, and stored procedures to support business reporting and analytics.
- Designed and optimised SQL scripts for data extraction, transformation, and loading (ETL) across large datasets.
- Created and managed Hive tables for data warehousing needs, including partitioned, external, and managed tables.
- Optimised SQL and Hive queries to improve performance and reduce execution time.
- Worked with Sqoop for data migration between relational databases, HDFS, and Hive.
Software Engineer
Sagacity Software Pvt. Ltd
Nagpur
01.2021 - 07.2021
- Interacted with clients to gather and clarify business logic requirements.
- Developed advanced PL/SQL procedures and functions to implement complex business logic.
- Crafted intricate SQL queries utilizing multiple tables for effective data retrieval.
- Analyzed requirements to create tailored procedures and functions.
- Optimized SQL performance through detailed explain plan analysis.
- Executed data loading processes using SQL*Loader for efficient data management.
Database Engineer - II
EBIXCASH Pvt. Ltd.
Nagpur
04.2018 - 12.2020
- Interact with clients and obtain the business logic.
- Creating procedures and functions using advanced PL/SQL coding to implement complex business logic.
- Writing complex queries using multiple tables.
- Optimising SQLs using explain plan.
- Data loading using SQL Loader.
- Creating a database upgrade package for various versions of Application.
- Optimising SQLs using explain plan.
- Involved in unit testing.
- Database export and import using Oracle Data Pump.
Education
Bachelor Of Engineering - Electronic Engineering
Smt.Radhikatai pandav College of Engineering
Nagpur, Maharashtra06.2016
Skills
- Big data technologies
- PySpark
- SQL and PL/SQL
- Python programming
- Version control with Git
- Data warehousing with Hive
- Data ingestion with Sqoop
- Apache Airflow
- Scala
Disclaimer
I, Mayur Hajare, hereby declare that the information contained herein is true and correct to the best of my knowledge and belief.
Certification
- AWS Certified Cloud Practitioner - 2025
- PCAP – Certified Associate in Python Programming (Python Institute) – 2023
Accomplishments
- Best team award 2025 (Tata Consultancy Services)
- Top talent award in 2022 (Persistent Systems Limited)
Timeline
IT Analyst
Tata Consultancy Services
10.2023 - Current
Senior Executive
Infocepts Technologies pvt. ltd
05.2023 - 09.2023
Lead Software Engineer
Persistent Systems Limited
07.2021 - 05.2023
Software Engineer
Sagacity Software Pvt. Ltd
01.2021 - 07.2021
Database Engineer - II
EBIXCASH Pvt. Ltd.
04.2018 - 12.2020
Bachelor Of Engineering - Electronic Engineering
Smt.Radhikatai pandav College of Engineering