About

Kapil Khattar is a Data Engineer with over 3 years of professional IT experience in Data Migration, ETL Development, and Database Management activities. He is currently working as a Data Engineer: Analyst at Deloitte India (Offices of the US) and is part of the Data Migration Team for Sales Force CRM Project. Kapil is recognized consistently for his performance excellence and has a strong knowledge of Informatica, Salesforce CRM Data Migration, and SQL, backed by specialization in Business Intelligence. Kapil's skills include Salesforce CRM Data Migration using Azure Data Factory, Business Intelligence Training in Hive, Pig, MongoDB, PowerBI, Core Java, Advance SQL, Unix, and Shell Scripting, and expertise in tools/technology such as Informatica PowerCenter, Teradata SQL, MS SQL Server, WinSCP, Putty, Jira, Confluence, CA Workload Station, PgAdmin (PostgreSQL), and Data Loader. He is also proficient in Python (Programming Fundamentals, OOPS, Data Structures) and MS OFFICE - Excel, Word, and PowerPoint. Prior to joining Deloitte, Kapil worked as a System Engineer at Infosys where he was responsible for Data Governance, Data Integration, Regression Testing, ESP Jobs Scheduling, PROD artifacts, and Information Governance Catalogue. He also worked on SCD Type-2 tables and provided UAT/QA support. He has experience in developing and supporting workflows, sessions, and mappings as per business requirements, development, and implementation of ETL Process using various Teradata Utilities like BTEQ, FastLoad, Multiload, creating test case documents for the developed scripts, developing and testing Bteqs and UNIX Shell Scripts using Putty, data warehousing, validation, and testing, data analysis in case of any data issues of production, and analyzing high-priority incidents of Production and resolving them within SLA. Kapil also worked as a Content Writer at Vidooly where he wrote content for YouTube videos and optimized videos by adding appropriate search tags and keywords. Kapil holds a Bachelor of Technology - BTech in Computer Engineering from SRM University and completed his Senior Secondary CBSE from DAV Public School. He also completed his Secondary CBSE from DAV Public School. Overall, Kapil has 4.44 years of relevant experience and a strong technical skill set in Data Engineering, SQL, ETL, Salesforce, MongoDB, Azure, Python, Java, Integration, Apache