Dharmpreet Mand

Background

About Dharmpreet Mand

15 years of experience – 14 year of ETL Developer Experience - Experienced in leading teams for Large Complex Transformational Programs- Strong Project Management experience managing Data Warehouse projects from inception to completion- Diverse Experience – Working in Toronto; Worked in California, Singapore, Shanghai and India- Worked with various Customers – Bank of Nova Scotia, Capital Group Companies, Bank of America, Citigroup, British Petroleum, Pfizer- Experience of working with key stake holders to understand requirements, translate those into design and implement the solution- Thorough understanding of all phases of Software Development Life Cycle (SDLC)- An Effective Communicator with excellent relationship, team building & interpersonal skills- Extensive experience in activities related to the development, implementation, manage and support of ETL processes for large-scale data warehouses- Strong in data analysis, impact analysis, troubleshooting data issues and remediation planning/execution- Experienced in test case preparation, Unit/Integration Test, System and Regression Testing- Having functional knowledge of Banking Domain- Proficient in ETL Tools – Hortonworks platform, Microsoft Analytical Platform System, Informatica PowerCenter and iWay DataMigrator- Strong Databases Skills – Hive, Beeline, SQL, DB2, PL/SQL – Oracle and SQL Server- Strong experience on creating End-to-End Tidal and AutoSys Job Schedules and job flow- Familiar With AWS Elastic Map Reduce, AWS S3, AWS EC2, AWS EBS, AWS RDS, AWS Cloud Watch, AWS Red Shift and the Machine learning concepts