Experienced Data Engineer (7+ yrs) with a knack for building robust data pipelines using Python, SQL, & Snowflake.
Eager to join your team, I offer precise technical leadership to meet goals
Overview
8
years of professional experience
4
years of post-secondary education
Work History
GARTNER
Gurugram, Haryana
Senior Data Engineer
03.2021 - Current
Job overview
Spearheaded a Snowflake to Redshift migration by optimizing data storage processes, achieving a 40% cost reduction
Executed ETL operations using Python and SQL, ensuring 99.9% data integrity and enhanced pipeline stability
Developed Raw and Analytics models using Snowflake and dbt-spark, improving data processing efficiency by
Designed and deployed data pipelines using dbt-spark on an EMR cluster, with S3 for storage and Redshift for reporting, resulting in 25% faster data access
Implemented and managed AWS services including IAM, Step Functions, ECR, EMR, Batch, EMR Serverless
CloudWatch, and EC2, optimizing cloud infrastructure performance by 15%
Authored SQL scripts for metadata management in PostgreSQL databases, enhancing data retrieval speed by 30%
Optimized system performance by refactoring Python and dbt codebases, reducing runtime by 20%
Created PowerBI Dashboards tailored to business requirements, resulting in a 30% improvement in data-driven decision-making
Assessed and recommended tools, technologies, and best practices, leading to a 25% increase in data processing efficiency
Improved data quality by implementing rigorous data cleaning, validation, and transformation processes, reducing errors by 40%
Analyzed data trends using advanced analytics techniques, providing insights that informed strategic decisions and boosted revenue by 15%
Established and maintained data analytics protocols, standards, and documentation, ensuring consistent data quality and compliance
Designed and implemented robust database solutions and models, improving data access efficiency by 25%
Managed and refined data handling processes, enhancing data accuracy and retrieval speed by 20%
Oversaw cloud infrastructure, implementing security measures and cost-saving strategies, leading to a 15% reduction in operational costs.
Grazitti Interactive
Mohali, Punjab
Data Engineer
11.2019 - 02.2021
Job overview
Engineered robust ETL pipelines in collaboration with the Analytics team, ensuring data integrity and pipeline stability
Executed large-scale data migrations for Marketo and Salesforce platforms with precision
Developed an automated solution for the Salesforce Pardot platform, slashing manual efforts by 95%
Crafted an automated ETL data pipeline utilizing Python, Pandas, and SQL, boosting batch processing efficiency by 30%
Articulated data insights effectively to align with project goals and support decision-making processes
Leveraged PowerBI to create compelling data visualizations, facilitating strategic discussions with stakeholders.
Tata Consultancy Services
Bangalore, Karnataka
Data Engineer
11.2016 - 10.2019
Job overview
Designed and implemented scalable data pipelines for ingesting, processing, and analyzing large datasets
Collaborated with stakeholders to provide planning support for roadmap initiatives
Identified areas for efficiency and process improvement and implemented effective solutions
Worked with big data technologies to manage and query vast amounts of data
Ensured data quality and integrity through rigorous testing and validation
Implemented high-quality engineering solutions to support automation efforts
Collaborated with Sr
Managers and engineers for optimal solution collaboration
Built new solutions throughout the organization
Utilized Python and SQL for data engineering tasks
Conducted code reviews to identify and rectify bugs and vulnerabilities
Familiar with cloud-based data infrastructure on AWS.
Education
Seth Jai Prakash Mukund Lal Institute of Technolog
Radaur,Yamunanagar
Bachelor Of Technology from Mechanical Engineering
08.2012 - 06.2016
Skills
SQL
Python
Extraction Transformation and Loading (ETL)
Data Build Tool(Dbt)
Data Warehousing
Snowflake
Apache Spark
Timeline
Senior Data Engineer
GARTNER
03.2021 - Current
Data Engineer
Grazitti Interactive
11.2019 - 02.2021
Data Engineer
Tata Consultancy Services
11.2016 - 10.2019
Seth Jai Prakash Mukund Lal Institute of Technolog
Bachelor Of Technology from Mechanical Engineering