Kanwar Sangwan Email Address

Lead Data Engineer

Factual focuses on making location data accessible to the mobile world. Factual Es data about places across the globe reveals a deeper understanding of people based on their geographic behavior.

Over 10 years of experience in Data Engineering, Data Migration, Data warehouse and Business Intelligence systems as a Developer, Designer and Architect Worked in Finance, Billing, Payment, Compensation, Publishing and Website traffic quality domains Experience in designing, customizing and implementing / maintaining large-scale data warehouse environments using variety of ETL tools (custom f/w, SAP Data Integrator) and Business Intelligence tools (Tableau, Business Objects) Experience with various MPP databases like HP Vertica , Teradata Well versed with AWS and Redshift Knowledge on Hadoop echo system including HDFS, HBASE, HIVE Knowledge of Spark Experience in handling challenges with high volume datasets Expertise in Performance tuning of ETL workflows to reduce load times. Made changes to the ETL loading process, underlying SQL queries and in some cases, to the underlying Database as needed (Physical model changes, partitioning, hints etc.) Experienced in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace , Cost-Based Optimization CBO Well versed with Agile and Waterfall methodologies Capable of looking across the entire business model to develop and promote a strategic vision of the data environment Led offshore teams. Performed tasks like distributing work, technical discussions, peer review, participating in test cycles, establishing code, testing standards, UAT support and post go live support Proven leadership, communication and client relationship skills with the ability to model, synthesize and present critical information to key decision makers Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements