Saurabh Kishor
Bengaluru
Summary
Dynamic Lead Consultant with KPI Partners India Pvt Ltd, specializing in ETL pipeline development and data optimization. Achieved a 75% reduction in execution time for data loads while enhancing data quality and governance. Proficient in Databricks and SQL, with strong problem-solving skills to drive impactful analytics solutions.
Overview
15
15
years of professional experience
3
3
Certification
Work History
Lead Consultant / Principal Consultant
KPI Partners India Pvt Ltd
08.2025 - 10.2025
- Developed Databricks notebooks for ingesting and transforming data from OAC datasets into Delta Lake tables, enhancing data accessibility.
- Performed schema mapping and data validation between Oracle and Databricks to ensure data consistency.
- Migrated analytics workloads by repointing dashboards to Databricks datasets, facilitating streamlined reporting.
- Collaborated with BI and data architecture teams to uphold data quality standards and governance practices.
- Environment: Databricks, Oracle, SQL
Lead Consultant
KPI Partners India Pvt Ltd
01.2025 - 06.2025
- Optimized Incorta load plans, reducing execution time from 4 hours to under 1 hour.
- Enhanced data pipeline performance by rewriting inefficient SQL queries, resulting in faster data processing.
- Executed data validation and reconciliation with production datasets, ensuring data integrity and accuracy.
- Resolved critical production issues ensuring system reliability.
- Streamlined schema structures and removed unused objects, improving database efficiency.
- Environment: Incorta, SQL
Lead Consultant
KPI Partners India Pvt Ltd
07.2016 - 12.2024
- Developed and maintained ETL pipelines using Informatica to support enterprise reporting systems.
- Built data models and reporting layers for Finance and Salesforce analytics.
- Managed DEV, UAT, and PROD deployments to ensure seamless release cycles.
- Resolved production data issues and implemented enhancements across BI applications.
- Led offshore development teams and coordinated with onsite stakeholders to align project goals.
- Environment: OBIEE 11g, Informatica 9.5, Oracle 11gR2, Snowflake, DBT, GCP
Senior Consultant
KPI Partners India Pvt Ltd
05.2016 - 07.2016
- Automated ETL workflows using DAC scheduling and monitoring.
- Implemented delta load mechanisms for fact tables improving load efficiency.
- Customized Informatica mappings to address procurement data issues.
- Environment: Informatica, Oracle, DAC
Senior Consultant
KPI Partners India Pvt Ltd
01.2016 - 02.2016
- Corrected precision issues in ETL data transformations, resulting in reliable data for analysis.
- Managed RPD and WebCat migrations across environments to ensure seamless integration and functionality.
- Resolved data inconsistencies in revenue snapshot fact tables to enhance accuracy of financial reporting.
Senior Consultant
KPI Partners India Pvt Ltd
09.2015 - 12.2015
- Implemented snapshot facts and custom dimensions to enable detailed revenue analytics.
- Designed aggregate tables that enhanced reporting performance for data analysis.
- Supported Tableau reporting platform by providing optimized datasets for improved reporting.
Senior Consultant
KPI Partners India Pvt Ltd
02.2015 - 07.2015
- Developed ETL workflows for integrating Salesforce CRM data into data warehouse, enhancing data accessibility.
- Implemented incremental and full data load strategies to optimize data processing efficiency.
- Led consulting projects for clients in various industries.
- Analyzed client needs to develop tailored solutions.
- Facilitated workshops to gather requirements and insights.
Lead Analyst
Invenger Technologies
Mangalore
09.2010 - 12.2014
- Designed and implemented enterprise data warehouse architecture.
- Developed ETL pipelines for ODS and Data Mart layers.
- Built dimensional models using star schema and slowly changing dimensions.
- Automated reporting processes for insurance analytics.
Education
Master of Computer Application -
IGNOU
Delhi01-2007
Skills
- ETL development
- Data Pipeline Optimization
- Data Modeling
- Databricks
- Snowflake
- Google BigQuery
- Informatica PowerCenter
- DBT
- Delta Lake
- Incorta
- Oracle 11g
- SQL Server
- SQL
- PL/SQL
- Python
- Unix Shell Scripting
- Unix
- Linux
- Windows
- Agile Project Management
- End-to-end delivery
- Domain Knowledge
- Problem Solving
- ERWIN
- DAC
- WinSCP
- Putty
Certification
- Oracle Certified Associate (OCA)
- Incorta Essentials
- Incorta Developer Certification
Personal Information
Title: Data Warehousing & Business Intelligence Specialist
Timeline
Lead Consultant / Principal Consultant
KPI Partners India Pvt Ltd
08.2025 - 10.2025
Lead Consultant
KPI Partners India Pvt Ltd
01.2025 - 06.2025
Lead Consultant
KPI Partners India Pvt Ltd
07.2016 - 12.2024
Senior Consultant
KPI Partners India Pvt Ltd
05.2016 - 07.2016
Senior Consultant
KPI Partners India Pvt Ltd
01.2016 - 02.2016
Senior Consultant
KPI Partners India Pvt Ltd
09.2015 - 12.2015
Senior Consultant
KPI Partners India Pvt Ltd
02.2015 - 07.2015
Lead Analyst
Invenger Technologies
09.2010 - 12.2014
Master of Computer Application -
IGNOU