Sharan Kumar Kantale

Data Engineer

Bengaluru, Karnataka, India6 yrs experience

Highly Stable

Key Highlights

Expert in designing automated ETL pipelines.
Proven track record in data quality improvement.
Strong background in Business Intelligence and Data Engineering.

Stackforce AI infers this person is a Data Engineering and Business Intelligence expert in the Media industry.

Contact

Skills

Core Skills

Data EngineeringBusiness IntelligenceEtl DevelopmentData Analysis

Other Skills

AWS EC2AirflowAnalyticsApache AirflowApache SparkData AnalyticsData WarehousingDatabasesDatabricksExtract, Transform, Load (ETL)GitGitHubHiveInformatica CloudInformatica Powercenter

About

Data Engineer/Analyst with around 6 years of experience and strong gasp in SQL, Dashboarding, ETL and BI tools. Hands-on experience in SQL, Tableau, Hive, Spark, Databricks, Informatica Powercenter and Unix Shell Scripting. Have strong knowledge in Data Analytics, BI Reporting, Data warehousing concepts, Advanced SQL and ETL Development. Inclined towards Data. Doesn't matter whether it is Data Analytics or Data Engineering or Data Science. I love it all. Also inclined towards Product Analytics and Product Management. Apart from that, I write jokes of all kind and interested in reading the same. I also read articles related to Finance, Stock Market, Life Lessons. Any kind of questions or suggestions or feedbacks for me, feel free to DM :)

Experience

6 yrs

Total Experience

2 yrs

Average Tenure

Current Experience

Disney+ hotstar

Senior Analytics Executive

Aug 2022 – Sep 2025 · 3 yrs 1 mo · Bengaluru, Karnataka, India · Hybrid

◦ Working as primary Data/BI Analyst for International Analytics team of regions MEA, SEA.
◦ Designed and automated Marketing dashboards like SMS, Email, Push Notifications, Inapp notifications
from end to end including ETL pipeline, scheduling, dashboarding.
◦ Engineered and designed large scale ETLs (> 1 TB/day) on Presto, Hive, Spark, Databricks and
automated them on Apache Airflow with Python and AWS EC2 thereby reducing the cost by 25%.
◦ Designed and built real time and batch dashboards on Tableau, Looker, Databricks and Redash
from sources like SQL, AWS S3, Excel, Text files etc to capture key metrics like AU, watch time,
subscriptions on daily, weekly and monthly level reducing the reporting time by 16 hours per week.
◦ Collaborated with Marketing team to analyze results from A/B tests for price rise changes and
notification campaigns, improving CTR by 40% and VVs by 30%.
◦ Deep dived, back tracked and did root cause analysis on user journey for multiple issues to boost metrics
like CTR, Subs%, Conversion rate, Churn, drop off of the platform on various levels.
◦ Implemented data quality checks and alerting mechanisms that reduced data loss incidents by 40%.
◦ Led migration of the entire Git codebase from Hive to Spark SQL.

SQLTableauHiveSparkDatabricksApache Airflow+4

Ey

Senior Analyst

Oct 2021 – Jul 2022 · 9 mos · Bengaluru, Karnataka, India · On-site

◦ Been part of Business Intelligence project as an ETL developer Leading US Insurance client.
◦ Framed complex SQL queries, SQL scripts for Data extraction and Data Analysis of large scale data
(>1 Billion records) using CTEs, windowing, filter, sub query, joins, aggregation, sorting.
◦ Fine-tuned ETL processes resulting in reduction of time consumption from 22 to 6 hours per week on
tools like Informatica Powercenter, Informatica cloud, Talend.
◦ Been part of Agile methodology by following sprint timelines and engaging in Scrum calls.

SQLInformatica PowercenterInformatica CloudTalendETL DevelopmentData Analysis

Lumen technologies

Data Engineer

Aug 2019 – Oct 2021 · 2 yrs 2 mos · Bengaluru, Karnataka, India · On-site

◦ Been part of Datawarehousing project as a Data Engineer with leading US Telecomm company.
◦ Built end to end ETL pipelines for the staging and transforming of huge data of more than 500 Million
records using Informatica powercenter, PL/SQL, Unix shell scripting.
◦ Handled issues in different environments like Test, QA, Production in ETL pipelines. Coordinated with
Testers, Production support team, Admins for the code releases, bug fixes and emergency code releases.

Informatica PowercenterPL/SQLUnix Shell ScriptingData Engineering