Hi, I’m
GAURAV SIKARWAR
Summary
Dedicated professional committed to driving company growth through effective problem-solving and challenge management. Proven ability to deliver results while gaining valuable experience in diverse environments. Focused on leveraging skills to contribute to organizational success.
Overview
1
Certification
8
years of professional experience
Work History
Tech Mahindra Ltd
Senior Software Engineer
06.2024 - Current
Job overview
- Designed and led the development of scalable, enterprise-grade ETL pipelines using AWS services (Glue, Lambda, DynamoDB, CloudWatch, SQS) and Python, enabling unified analytics across diverse data sources.
- Built end-to-end data integration frameworks with Python-based API connectors for real-time and batch ingestion, ensuring high data quality and reliability.
- Implemented CI/CD pipelines with Bitbucket and DevOps tools, streamlining deployment and version control of ETL workflows.
- Architected and optimized Snowflake data models and schemas to support cross-domain reporting, improving query performance and data consistency.
- Collaborated with cross-functional teams to define matching rules, cleansing logic, and golden record standards, enhancing data quality for customer identity resolution.
BCT Consulting
Data Engineer
05.2023 - 06.2024
Job overview
- Designed and maintained scalable ETL pipelines using AWS Glue and AWS Data Pipeline to ingest, transform, and load high-volume datasets from diverse sources into Amazon Redshift.
- Built and deployed PySpark-based data processing workflows for JSON, CSV, RDBMS, and streaming data across Kubernetes and on-prem environments.
- Optimized ETL and PySpark workloads through performance tuning, improving overall processing efficiency and achieving up to a 40% increase in speed.
- Implemented robust data quality processes-including cleansing, normalization, aggregation, and enrichment-to enhance reliability and analytics accuracy.
Capgemini Engineering
Consultant
08.2021 - 10.2022
Job overview
- Improved overall data processing efficiency by applying advanced optimization and tuning strategies, resulting in up to a 30-40% increase in throughput.
- Designed and deployed scalable ETL pipelines with AWS Glue, Data Pipeline, and PySpark for high-volume, multiformat data ingestion into Amazon Redshift.
- Implemented data quality measures and provided production support, ensuring reliability and low-latency in pipeline operations.
- Developed and deployed PySpark transformation workflows and streaming datasets on-premises, enhancing data processing capabilities.
Global Logic Pvt Ltd
Senior Software Engineer
06.2018 - 08.2021
Job overview
- Designed and optimized data pipelines using NumPy, Pandas, and Regular Expressions for efficient data processing.
- Implemented custom Python libraries to extract and process structured and unstructured data from multiple online sources.
- Developed and maintained automated web crawling and data extraction systems, enhancing data accessibility and analysis through Python, JavaScript, and HTML.
- Conducted debugging, performance tuning, and monitoring, ensuring high system reliability and seamless operations.
Education
BHARATI VIDYAPEETH DEEMED UNIVERSITY
MCA
01-2017
DR. BHIMRAO AMBEDKAR UNIVERISTY
BCA
01-2015
Skills
- PYTHON
- PYSPARK
- MYSQL
- Snowflake
- Data warehousing
- Data modeling
- Microservices architecture
- Continuous Integration
- AWS, Azure
- AI technologies
Certification
- AWS Certified Cloud Practitioner.
- AWS Certified Solutions Architect - Associate.
- AWS Certified AI Practitioner, AWS Certified.
- Machine Learning Engineer - Associate certificate.
- Snow Pro Core.
Timeline
Senior Software Engineer
Tech Mahindra Ltd
06.2024 - Current
Data Engineer
BCT Consulting
05.2023 - 06.2024
Consultant
Capgemini Engineering
08.2021 - 10.2022
Senior Software Engineer
Global Logic Pvt Ltd
06.2018 - 08.2021
BHARATI VIDYAPEETH DEEMED UNIVERSITY
MCA
DR. BHIMRAO AMBEDKAR UNIVERISTY
BCA