About

Himanshu Thakkar is a highly experienced IT professional with more than 13 years of experience in software design and development of data migrations, data warehouses, and data marts. He currently works as a Manager at KPMG Global Services (KGS) and has a distinctive competence in designing complex jobs using DataStage. Himanshu has extensive experience in ETL/Data stage tool using IBM DataStage (Ver8.5), designing and developing jobs using Designer, DataStage Manager, DataStage Director, and DataStage Administrator. He also has a strong background in data modeling, star schema/snowflake schema modeling, FACT & Dimensions tables, Physical & logical data modeling. He has a solid understanding of business process analysis, metadata documentation, and development of business architecture as-is model. Himanshu has developed the Source-Target Mapping for the Dimensions and Fact Tables and has extensively used Parallel Extender to load data into data warehouse with different techniques like Pipeline and Partition in MPP environment. Himanshu has expertise in implementing DB2, Teradata, Oracle, SQL Server, PL/SQL database applications, and has used ETL Tool to create jobs for extracting the data from different databases, flat files & Mainframe files. He has extensive experience in error handling concepts, testing, debugging skills, and performance tuning of targets, sources, transformation logic. Himanshu has experience in all Testing Phases: Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing. He has strong skills in analysis Coding using SQL and PL/SQL, Developing, Writing Unix Shell Scripts, and code/script testing. Himanshu is an expert in data warehousing and data migration and has extensive experience in Shell Scripting. Himanshu has previously worked as a Senior Technical Lead and Technical Lead at PWC. He has a Bachelor's degree in Computer Science from NIT Raipur and a Higher Secondary degree in Mathematics from Deshbandhu Eng Med School. Himanshu's tech stack includes test, SQL, ETL, Snowflake, Senior Software Engineer, Data Warehouse, designer, and Integration. With 13.28 years of relevant experience, Himanshu is a highly skilled IT professional with a wealth of experience in data migration, data warehousing, and data mart development.