Hitesh Pruthi
Database Developer
Mumbai
Summary
Dedicated Database Developer with a strong passion for data analysis and a proven track record in PL/SQL development and performance tuning. Expertise includes designing, implementing, and optimizing complex SQL queries, ETL processes, and data warehousing solutions. Recognized for an analytical mindset and the ability to transform data into actionable insights, consistently delivering impactful solutions that enhance data management and business decision-making. Additionally, possesses a solid understanding of Python and PySpark, further enriching the capability to drive data-driven initiatives.
Overview
8
8
years of professional experience
3
3
Certifications
Work History
PLSQL / ETL Developer
Moksha Softlabs Pvt Ltd
09.2021 - Current
- Deployed Onsite at IDFC first bank: Card domain (Core System Prime)
- Roles & Responsibilities:
- Led migration activities for the Prime Credit Card System at IDFC Bank.
- Developed optimal technical programs as per client needs having financial impacts, for example giving cashback/Reward Points to customer when customer have completed specific requirements/rules.
- Designed and developed customized Extract, Transform, and Load (ETL) applications based on client specifications.
- Developed a Pyspark-based predictive data processing model in Azure Databricks by importing Prime Tables as DataFrames to compute each customer's total payable value, and update results into extension fields for real-time reflection in customer statements.
- Worked on end-to-end batch processing of large-scale transaction data (approx. 25 lakh records) by preparing and loading datasets for secure upload and scalable processing on Azure Databricks, utilizing PySpark-based workflows for business analytics and accessibility.
- Created and optimized CTL files to load DWH datasets using SQL Loader utiltiy, ensuring efficient data ingestion and validation within Oracle database enviornments.
Database Consultant
Clover Infotech
05.2020 - 09.2021
- Deployed Onsite at IndusInd Bank: Credit Card System (Core System – Vision plus)
- Roles & Responsibilities:
- Analyzed transaction failures by reviewing middleware logs and reporting issues to the respective team.
- Data loading in core system for MIS Reporting.
- Data validation and irregular pattern analyzation.
- Database patching and tuning activities.
Oracle Support Engineer
Tejosma Technologies
09.2019 - 05.2020
- Roles & Responsibilities:
- Communicated technical development stages and provided design support to stakeholders.
- Participated in discussion meetings with clients.
- Collaborated closely with team members on tasks such as troubleshooting and debugging.
- Contributed to continuous improvement and quality assurance efforts.
Service Delivery and support engineer
Serviceberry Technologies Pvt. Ltd
02.2018 - 05.2019
- Roles & Responsibilities:
- Performed root cause analysis and general troubleshooting.
- Monitored systems in operation and quickly resolved errors.
- Conducted patch deployments and data center–disaster recovery (DC-DR) drills.
- Served as an on-site support engineer for Bank of Baroda for one year
Education
Bachelor of Engineering - Information Technology
Universal College of Engineering
04.2017
Diploma - Information Technology
Thakur Polytechnic
04.2014
Skills
- Database programming in PL/SQL
- Development of CTL files
- SQL data loading
- Python
- Pyspark development
- Data Warehousing
- ETL process management
- Data analysis expertise
- Data structure design
- Cloud Computing
- Oracle
- Systematic problem-solving
Interests
Sports Analytics, Travel, Reading
Websites
Certification
Oracle Cloud Infrastructure 2025 Certified AI Foundations Associate
Timeline
PLSQL / ETL Developer
Moksha Softlabs Pvt Ltd
09.2021 - Current
Database Consultant
Clover Infotech
05.2020 - 09.2021
Oracle Support Engineer
Tejosma Technologies
09.2019 - 05.2020
Service Delivery and support engineer
Serviceberry Technologies Pvt. Ltd
02.2018 - 05.2019
Diploma - Information Technology
Thakur Polytechnic
Bachelor of Engineering - Information Technology
Universal College of Engineering