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