I am Kapil Khattar, a highly accomplished and results-driven Senior Data Engineer and Consultant with over six years of extensive experience in designing, implementing, and leading complex data solutions. My specialization lies in large-scale Salesforce CRM data migration, ETL processes, and advanced data transformation, ensuring precision and integrity in mission-critical environments.

My career trajectory, predominantly within Deloitte USI, has been defined by driving significant business impact through data. As a Data Migration Lead for the pivotal Jupiter Project, I spearheaded the unification of Deloitte’s global and US opportunity management systems into a single CRM platform. This involved directing end-to-end data migration strategies that consistently delivered seamless transitions with zero critical discrepancies and maintaining over 95% data accuracy, fundamentally enhancing real-time pipeline visibility and forecasting capabilities.

I bring a robust technical skill set, proficiently leveraging Python for sophisticated automation and data processing, SQL for complex querying and optimization, Informatica PowerCenter for enterprise-level ETL, and Azure Data Factory for scalable cloud data orchestration. My approach is centered on crafting resilient, automated, and high-performance data pipelines that directly translate into operational efficiencies and strategic advantages.

Beyond technical execution, I am deeply committed to elevating data governance standards, optimizing system performance, and proactively identifying and mitigating data risks to ensure robust compliance. My contributions extend to impactful firm initiatives, including leading technical recruitment for AI & Data roles, and developing innovative solutions for challenges such as designing fuzzy/exact matching logic for large-scale data de-duplication and automating Salesforce CRM knowledge object migrations to overcome platform limitations.

Driven by a passion for delivering high-impact data solutions, I thrive on tackling intricate data challenges, leading collaborative teams, and bridging the gap between complex technical requirements and tangible business outcomes. I am dedicated to continuous learning and contributing to the advancement of data engineering practices.

About Me

Experience

Senior Consultant
Deloitte USI, Gurgaon
June 2025 – Present

• Led data migration for Global StoreFront 1.0 & 2.0 /US StoreFront as part of the Jupiter Project, ensuring seamless transition with zero critical discrepancies and 95%+ accuracy.

• Unified Deloitte’s global and US opportunity management systems into a single CRM platform, enabling real-time pipeline visibility and enhanced forecasting.

Consultant
Deloitte USI, Gurgaon
June 2022 – June 2025

• Spearheaded data migration for 10+ global regions, focusing on consolidating and standardizing sales data, ensuring 95% cutover accuracy with zero critical issues.

• Built Python-based automation for error reporting, cutting manual efforts by 70%.

• Created reusable code templates, reducing development cycles by 50%.

• Strengthened data governance and compliance by identifying data risks early.

Analyst
Deloitte USI, Gurgaon
January 2021 – June 2022

• Led four successful production deployments for Salesforce CRM data migration in a telecom client engagement.

• Automated SQL-based data cleansing processes, reducing delivery time by 3 days.

Systems Engineer
Infosys Limited, Hyderabad
November 2018 – January 2021

• Designed ETL pipelines for a US-based financial services client.

• Improved reporting accuracy and system reliability through performance tuning and data governance.

”Kapil and I have worked together implementing a Global CRM system to all Deloitte markets. As the data migration lead Kapil is responsible for loading all market data into the new application in order for the markets to effectively manage their business. Kapil is highly detailed and organized regarding his planning and execution of the data loading. Kapil works extremely well with market leaders communicating status and working with them directly regarding any updates that may be needed. Kapil has recently took the iniative to purse and obtain his MBA. I mentored and worked closely with Kapil on this initiative. He was able to complete his work while still providing excellent service to his customers. I would be happy to have Kapil on my project team and for any new project work in the future.”

Neil Eliff I Prince 2 I Professional Scrum Master
Global Senior Project Delivery Leader

”The resource that a team can rely on. I witnessed his attention to details, problem solving skills and ability to collaborate makes him an asset to any team. I highly recommend Kapil for any data engineering role.”

Amit Kumar
Talend Developer

”Kapil is very dedicated and skillful resource, Takes any issue in positive way and resolves it getting complete insight of the issue. Manages his work Quite Well"

Aman Raj
Senior Consultant

Education

I had the pleasure to study at one of the best universities. Continuous learning and improvement is my main drive.

Carlioso University
Digital Marketing
Jan 2019 - Present

Malibu University
User Experience Design
May 2018 - Jan 2019

Other skills

While working as a project manager, I was able to find other interesting & exciting areas where I love to dive deep. I did my best to develop those skills while working with other talented people, designers, engineers, project managers, clients, and artists.

User Interface Design

User Experience Design

Interaction Design

Creative Direction

Frontend Development

Research

Passions

After all, I had the pleasure to meet and work with talented and creative people with different passions. That encouraged me to have other activities which are not related to work

Sports

Copywriting

Photography

Music

Awards

2019 Best Project Development 1st place

2018 Product Awards 2nd place

2018 Most Popular Project 1st place

Save a copy of my CV

Press the button below to download my CV in .pdf format. I’m really cool guy.