Kedar Jatkar

Data Engineer

INFOCEPTS: DATA &AI

Nagpur

06.2021 - Current

Ensured compliance with the California Privacy Regulation Act avoiding $30,000 penalties through automation
Migrated to a multi-schema Snowflake database, enhancing privacy, security, and reporting efficiency while reducing cross-database joins by 40%.
Audited and corrected 50+ Snowflake objects, deploying updated scripts to improve query efficiency by 15%.
Migrated critical reports from MicroStrategy to Snowflake, reducing data retrieval time by 30% for faster business analysis.
Replaced legacy process with a direct Snowflake data-sharing method using 4 views, cutting report generation from 8 MSTR reports to 4 Snowflake views resulted in a 50% reduction with seamless vendor access.
Led migration of 100+ Denodo views to Snowflake, improving performance by 35% with zero critical issues and full data integrity.
Optimized a complex view, cutting execution time from 2 hours to under 5 minutes, increasing efficiency by 98%.
Improved SQL query performance in Snowflake by up to 90% through optimization and indexing.
Utilized advanced Snowflake features: cloning, time travel, and Snowpipe to optimize data management and access.
Created and maintained over 50 Tidal jobs, diagnosing and resolving script errors to ensure smooth production runs.
Performed unit testing for all deployments, reducing post-production issues by 90%.
Managed QA validation and deployment via GitHub, creating detailed test docs for 100+ deployments to ensure flawless execution.
Optimized existing queries to improve query performance by creating indexes on tables.
Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
Integrated multiple sources of structured and unstructured datasets into a single platform.
Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.