Ashwin Basrur

Background

About Ashwin Basrur

Self-motivated DW/ETL Architect/BI Manager/Staff Data Engineer with over 18+ years of experience in fast-paced, delivery-focused Fortune 500 environments with 16+ years of experience working in USA • Experience in Information Technology on handling multiple engagements in various capacities as managing Engineering Teams, Data Warehouse architect, ETL Architect, BI Manager, Modeler, Staff Data Engineer and Developer. • Experience in Healthcare, Banking, Mortgage, Utility, Marketing, Finance and Entertainment Domains with dataset size more than 130+ tb • Worked on various multi-site projects teams spread across US, Europe, Australia & India handling complex onsite-offshore engagements involving large data volumes. • Strong experience on Project Management, Systems Integration, Data warehouse architecture, Database Design, ETL Design, ETL Optimization, Data Profiling, Data quality process design, Best practice implementation, ETL Development, Production support and team co-ordination. • Data modelling experience using Erwin tool involving Dimensional and Fact tables in Operational Data Store and Enterprise Data Warehouse. • Unix/Python Scripting experience & AWS(EC2, S3, Glue, Lambda, Redshift)/Azure Cloud(ADF, BLOB Gen2, Synapse) • Working experience on Redshift, Hadoop-Hive, HDFS, Greenplum 4.2, Vertica 8.1, Teradata 13.10, Oracle 9i, and SQL 2012/2016 Server. • Strong ETL experience using Informatica Power Center 7.x & 8.6, 9.1, 9.6.1, Datastage 8.1 • Have experience of working on Business Objects 6.5, Tableau 10 and Web intelligence reports. • Experience on working on No SQL and other tools like Redis in memory DB, Kafka & Splunk • Established long-term and value-added relationships with assigned business partners to educate and develop the analytic capability of business customers and the organisation. • Lead and mentor the data team ensuring strategic alignment and rapid executional excellence. Specialities: Cloud technologies (AWS and Azure) Enterprise Data Services Data Warehousing, Data profiling, Vertica/Greenplum/Redshift/Teradata/Oracle/SQL Server/Postgresql/Mysql Hadoop-Hive Sqoop Redis, Splunk, Kafka ETL Informatica Unix/Python IBM Information Server DataStage Project Management/RFP/SOW/Client Engagement