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 potential 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 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.
Deloitte USI, Gurgaon
June 2025 β Present
Deloitte USI, Gurgaon
June 2022 β June 2025
Deloitte USI, Gurgaon
January 2021 β June 2022
Infosys Limited, Hyderabad
November 2018 β January 2021
I had the privilege of studying at one of the top universities. Continuous learning and personal development are my primary motivations.
SP Jain School of Global Management
Feb 2022 - Feb 2024
SRM Institute of Science & Technology
July 2014 - Apr 2018
While my primary focus is data engineering, my diverse experience in complex project environments has allowed me to cultivate a broader set of skills that complement my technical expertise and contribute to holistic project success. I've actively engaged in areas that enhance efficiency, manage risk, and foster team growth.
Throughout my career at Deloitte, I have been fortunate to receive several recognitions for my contributions and dedication.
Associated with: Deloitte India (Offices of the US)
"Kapil leads the data conversion for US Jupiter. He has been extremely proactive and instrumental in redefining our data conversion strategy which has reduced our data defects significantly!"
Associated with: Deloitte India (Offices of the US)
"You have played an instrumental role in the success of Jupiter Storefront project. Keep up the good work."
Associated with: Deloitte India (Offices of the US)
"Kapil, a technical powerhouse, innovatively solves challenging problems, supporting the OSF DM team in timely design and development. He also leads coordination with MF for seamless onboarding, showcasing his leadership and deep technical acumen."
Associated with: Deloitte India (Offices of the US)
"Vantage Points May 2024"
Associated with: Deloitte India (Offices of the US)
"Appreciate your effort in supporting and helping in Salesforce Recruitment. #Keep up the amazing work."
Associated with: Deloitte India (Offices of the US)
"Kapil resolved a very user critical issue for all US business and able to guide other team members on incidents when they are stuck. Good in data analysis and able to co-ordinate with clients in the absence of leads."
Associated with: Deloitte India (Offices of the US)
"Vantage Points December 2022"
Associated with: Deloitte India (Offices of the US)
"Thank you so much for all your contribution in DME ( DV, E2E, MFAT, Prod load) and S4(DV, E2E load) and also leading CE member firm load from planning to execution so far. Your contribution is very valuable to data migration team. Keep up the good work!"
Associated with: Deloitte India (Offices of the US)
"Vantage Points May 2022"
Associated with: Deloitte India (Offices of the US)
"Thank you for your hard work, focus and dedication towards the success of Collab Connect Q3 and Q4 releases. I am aware of the many challenges, and your efforts have established trust with the client, raised our team's performance and positioned us well for continuing work at Cisco. Thanks again and look forward to continued success. Cheers, Gopal."
Here are some of the recommendations from colleagues and managers:
Global Senior Project Delivery Leader
β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 his status and working with them directly regarding any updates that may be needed. Kapil has recently took the initiative to pursue 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.β
Talend Developer
β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.β
Senior Consultant
"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"
Program Manager @ Deloitte Consulting
"I've had the pleasure to work closely with Kapil on a large global Sales Cloud implementation project, where Kapil was one of the Data Consultant. Kapil proved himself a very diligent and hard worker who would always deliver an excellent quality of work. The project we worked on was a difficult project where we had to handle large amounts of confidential data and Kapil always followed rigorous data quality standards to ensure there was minimal issues with data migration. During the time I've spent with him he has proven himself to be a very capable data consultant and a great team member."
Senior Data Engineer@Deloitte USI
"Kapil manages the work in well articulated way and makes sure the whole process executes in a structured manner. This quality has always helped in the timely delivery of the deliverables and good client satisfaction."
Specialist at Carrier Corp
"Kapil is a very skillful and dedicated resource.He is an impactful resource and a key member of data migration process.He has very good client handling skills and he is a complete team player."
Salesforce Architect
"Kapil has great technical skills and is an excellent problem solver especially with Data Migration and Analytics. He was a member of SFDC Deloitte Digital Sales transformation team. We were implementing a workplace collaborative technology solution and I had a chance to work with him closely. Kapil has always has come up with detailed and methodical under pressure and go live deadlines. He has a good technical understanding of the Salesforce ecosystem and follows the SFDC best practices and provides detailed documentation, when needed. I can always depend on him and look forward to working in future projects with him. Hope to see him make lot of progress in his professional career !."
Business Analytics Developer, CDP at Ralph Lauren
"I was impressed by Kapil's ability to handle any situation calmly and patiently, even with the toughest clients. This natural skill of his has helped us as a team. Kapil is one of the best colleagues I have had the opportunity to work with. He is one of the most dedicated professionals I've worked with and is willing to put that extra help whenever you need it. His expertise as a developer is considerable, and it helped our team come up with more efficient solutions."
Specialist Master (Manager) Deloitte
"Kapil is an amazing co-worker. He has good knowledge in ETL domain and has expertise in Salesforce data migration as well. we worked together on a one of Sales transformation project. Kapil was always very methodical and detailed. I would always reach out to him for any SFDC data migration expertise."
Manager @ Deloitte
"Kapil is a technically sound and a passionate resource in the Consulting space. He has good knowledge in ETL landscape and Data Analytics. I have personally seen Kapil grow as a professional and I truly appreciate his dedication towards work."