Siddhartha Gupta
Gurugram
Summary
Proven Data Engineer with a robust background at Google Operations Center, adept in optimizing data processes and enhancing data-driven decision-making. Specialized in ETL development, data warehousing, and cloud technologies, with a knack for collaborative problem-solving. Achieved significant query performance improvements and designed scalable data pipelines, demonstrating a blend of technical prowess and teamwork.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer
Google Operations Center
Gurugram
08.2023 - Current
- Optimized existing queries to improve query performance by creating indexes on tables.
- Built various dashboards with interactive visualizations using Google Plx, Looker studio.
- Developed and implemented data models, database designs, data access and table maintenance codes (FSD, Design documentation).
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
- Created stored procedures for automating periodic tasks in SQL Server.
- Conducted data analysis using SQL and Python to derive insights and support decision-making processes.
- Conducted rigorous testing and validation of data pipelines to ensure accuracy and completeness of data (System Integration Testing, User Validation Test, User Acceptance Test).
- Monitored data systems performance, identifying bottlenecks and implementing solutions to maintain system efficiency.
- Configured and maintained cloud-based data infrastructure on platforms like AWS, Azure, and Google Cloud to enhance data storage and computation capabilities.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
Associate Consultant
Capgemini
Noida
09.2020 - 08.2023
- Collaborated with stakeholders for timely task completion in project life cycles. Facilitated requirement gathering, function specification, unit design, and integration test documentation.
- Reviewed multiple datasets to produce actionable insights by merging data from various sources.
- Developer on Stellantis client project utilizing IBM Infosphere Data Stage, Pentaho Data Integration, and SSRS. Developed solutions using Python, SQL, and PL/SQL.
Education
Bachelor of Engineering - Computer Science
Chandigarh University
Mohali, India06-2020
Skills
- Data Warehousing
- Debugging and troubleshooting
- Data integration
- ETL development (PDI, Power BI)
- SQL and Databases
- SQL Programming (Views, Functions)
- Data Analysis
- API Development (Google Tangle)
- Relational databases (RDBMS)
- Business Intelligence
- Database Design
- Big data technologies (RVL, Qubos)
- Testing (Google RVL, UAT, UVT, SIT)
- Python (PySpark)
- Cloud (AWS, Azure, Google)
- Dashboard and Reporting (Looker, Plx, Tableau, SSRS)
Certification
- Microsoft AZURE fundamentals AZ-900 in 2023-10
- Certificate on completion of SQL for Data Science
training at Coursera in 2023-10 - Cloud Computing by IIT Kharagpur [NPTEL] in 2017-10
- AMCAT CERTIFIED DATA PROCESSING SPECIALIST, SOFTWARE ENGINEER-IT
SERVICES, BUSINESS ANALYST in 2019-05 - Elite Certificate in Cloud Computing by NPTEL, IIT
Madras in 2019-05 - 2 Months internship as Software Associate trainee at EME
Technologies in 2019-05 - 1 Month internship on Information Security at CyberOps
Infosec LLP in 2018-06 - Training completion Certificate for AWS Cloud
Practitioner CLF-01 in 2021-10 - Certificate for completion of ICSI | CNSS Certified
Network Security Specialist in 2021-01 - Certification of Participation for IIMT Mega All India Online challenge "KAVACH" Ideathon in 2020-09
Accomplishments
- Q4 Titan team Award on 07/05/21
- Rising Star Award on 01/01/2021
- Diamond Star Award on wining Sectorthon.
- Thank you Star Award by CHRO of Acpgemini, India
- Hermes Titan Award for best performance in 2022
- Best Trainee Award and letter of Appreciation by M.D. of EME technologies
- High Five Award for training new joinees in Google Project team in 2024
- Touch Stone Award for excel in BAU Tasks and gIdea completion in 2024
- Developed a Team website using google sites
Languages
English
First Language
Timeline
Data Engineer
Google Operations Center
08.2023 - Current
Associate Consultant
Capgemini
09.2020 - 08.2023
Bachelor of Engineering - Computer Science
Chandigarh University
Similar Profiles
Srikanth LankadasariSrikanth Lankadasari
Cloud Engineer Associate at Google Operations Center, GoogleCloud Engineer Associate at Google Operations Center, Google
Gowtham MadanalaGowtham Madanala
CUSTOMER ADVOCATE SENIOR ASSOCIATE at GOOGLE ADS & GMB, GOOGLE OPERATIONS CENTERCUSTOMER ADVOCATE SENIOR ASSOCIATE at GOOGLE ADS & GMB, GOOGLE OPERATIONS CENTER
Priya BograPriya Bogra
Digital Marketing & Research Senior Associate at Google Operations Center, GoogleDigital Marketing & Research Senior Associate at Google Operations Center, Google
CHETHAN KUMAR K.RCHETHAN KUMAR K.R
Training Delivery Senior Specialist, GOC at Google Operations CenterTraining Delivery Senior Specialist, GOC at Google Operations Center
Amanjot Kaur LambaAmanjot Kaur Lamba
Workday Integration Consultant at AccentureWorkday Integration Consultant at Accenture