👋 Hi there! I’m an experienced data engineer with a passion for turning raw data into actionable insights. Here’s a glimpse into my world:Technical Skills: Proficient in Python, SQL, Snowflake, DataStage, DataBricks, and Azure Data Factory (ADF). I thrive on architecting robust data pipelines and optimizing workflows.Ecosystem Explorer: I navigate the Datalake and Pyspark ecosystem with ease, extracting value from diverse data sources. Whether it’s batch processing or real-time streaming, I’m up for the challenge.Toolbelt: Airflow, GitHub Actions, and Jenkins are my trusty companions. I believe in automating the mundane so that creativity can flourish.Education: I hold a Bachelor of Technology (Electrical Engineering) from Punjab Engineering College (PEC), Chandigarh, complemented by a minor degree in Computer Science and Engineering.Let’s connect! 🌟
-
Lead Data EngineerOptumGurugram, Hr, In -
Senior Data EngineerOptum Jul 2022 - PresentGurugram, Haryana, India– Skilled in leveraging Databricks Lakehouse for scalable data processing, ETL pipelines, and collaborative analytics.– Successfully transformed over 150+ DataStage ETL processes into Python-based Databricks workflows, resulting in optimized performance, enhanced data processing efficiency, and a remarkable 40% reduction in processing time.– Realized TCO reduction of $4M+ per year in infrastructure cost by migrating a 30TB+ database from Sybase IQ database into Snowflake.– Designed… Show more – Skilled in leveraging Databricks Lakehouse for scalable data processing, ETL pipelines, and collaborative analytics.– Successfully transformed over 150+ DataStage ETL processes into Python-based Databricks workflows, resulting in optimized performance, enhanced data processing efficiency, and a remarkable 40% reduction in processing time.– Realized TCO reduction of $4M+ per year in infrastructure cost by migrating a 30TB+ database from Sybase IQ database into Snowflake.– Designed and implemented Azure Data Factory pipelines, seamlessly orchestrating the loading of 300+ tables from diverse sources directly into Snowflake.– Enabled near real-time data extraction via Confluent Kafka Connect, handling seamless ingestion from over 600+ Kafka topics directly into Snowflake tables.– Proficient in Terraform for Azure, with hands-on experience in designing and creating comprehensive data architecture infrastructure for data teams.– Managed a team of 5 interns in which 2 focused on DataOps solutions, while 3 built an operations dashboard.– Architected & monitored data pipelines with 99.995% availability for 60+ clients, yielding impact $3Mn+.– Guided team to manage and solve 50+ tickets, enhancing data reporting accuracy for 10+ clients.– Executed 15+ team-building initiatives through meets, workshops, and events, enhancing team cohesion.– Led 10+ sprint planning sessions as Scrum Master, ensuring adherence to Scaled Agile methodology. Show less -
Data EngineerOptum Aug 2020 - Jun 2022Gurugram, Haryana, India– Developed and maintained scalable data pipelines through SQL optimization, data quality checks, and the implementation of best practices in data modeling, thus reduction of 2 TB of duplicates and improved overall runtime by 30%.– Reduced cost by $100k+ annually by migrating 1700 job schedules from TWS into a flexible open-source scheduler Airflow.– Achieved a 20% improvement in data quality by Analyzed and provided root cause analysis (RCA) for over 100+ tickets raised by business… Show more – Developed and maintained scalable data pipelines through SQL optimization, data quality checks, and the implementation of best practices in data modeling, thus reduction of 2 TB of duplicates and improved overall runtime by 30%.– Reduced cost by $100k+ annually by migrating 1700 job schedules from TWS into a flexible open-source scheduler Airflow.– Achieved a 20% improvement in data quality by Analyzed and provided root cause analysis (RCA) for over 100+ tickets raised by business users due to incorrect data.– Created and optimized a CDO Rally dashboard using Python’s Flask and MongoDB, reducing data retrieval time by 40% and improving metric accuracy by up to 25%.– Successfully led the migration of DataStage jobs, ensuring seamless transitions and maintaining data quality throughout.– Enhanced Jenkins pipelines, streamlining CI/CD processes for efficient software delivery.– Revamped data extraction design, reducing data footprint by ~2TB, saving cost of $1.5M/year.– Enhanced DevOps to monitor 2000+ workflows, delivering solutions for ~99.995% data availability. Show less -
InternWestern Digital Jan 2019 - Jun 2019Bengaluru, Karnataka, India -
InternAtal Tinkering Lab, Chandigarh Jun 2018 - Jul 2018Chandigarh Area, India Worked on Arduino and Raspberry Pi 3 Worked on various projects such as Trafficer, Baby Incubator, Home Automation, Obstacle Bot, and Smart water management system Organised workshop for school students
Lovish Bansal Education Details
-
Electrical Engineering -
Mount Carmel School9-10 Th -
The British School Chandigarh12Th
Frequently Asked Questions about Lovish Bansal
What company does Lovish Bansal work for?
Lovish Bansal works for Optum
What is Lovish Bansal's role at the current company?
Lovish Bansal's current role is Lead Data Engineer.
What schools did Lovish Bansal attend?
Lovish Bansal attended Punjab Engineering College, Punjab Engineering College, Mount Carmel School, The British School Chandigarh.
Who are Lovish Bansal's colleagues?
Lovish Bansal's colleagues are Pankaj Kumar, Becky Vega, Carmina Eloise Lumio, Shubham Shinde, Lavanya Ashok, Zalina Kazakova, Ms, Rdms, Cecilia Catano.
Not the Lovish Bansal you were looking for?
-
Lovish Bansal
Bengaluru -
Lovish Bansal
Bengaluru -
lovish Bansal
| Aspiring Business Administration Student | Jmit | Strategic Thinker | Team Player | Learner Mindset | Tally Erp | Future Entrepreneur | Finance InternLadwa -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial