• Assisted the Business Analysts in attaining consensus with the stakeholders in terms of gathering requirements, understand the business KPIs of interest and design wireframes of dashboard using Tableau desktop• Integrated data from various sources such as cloud/distributed/RDBMS/flat-files and built ETL pipelines using StreamSets• Defined the granularity of the Datamart and created dimensional data model using ER-Studio with appropriate SCD types• Created the physical data warehouse on SQL Server and laid out the data retention strategies• Developed complex/efficient SQL for the calculation of KPIs and generated visualizations from Tableau data extracts• Automated and scheduled the Data refresh process across the Datamart using SQL procedures and Streamsets pipelines thus reducing the manual effort for daily, weekly and monthly dataloads for legacy sources• Worked on defining the Data quality checks across the sources and helped reduce the manual QA effort for pre-load and post-load Data validations.• Developed strategies at code level to achieve Data governance.• Worked on creating an Audit framework internal to the Internal Benchmarking Database

Senior ETL Developer – Client: Westpac – Consumer Line of Business• Built interfaces in Informatica with Teradata as the source and hydrated the centralized client data lake• Performed analysis on the existing EDW framework and designed generic delta check modules on the Staging tables• Designed and architected an application that calculates the waiver charges incurred on a customer and performed data modeling, data mapping and system specification activities• Enhanced database schemas for a platform migration effort while carefully transitioning RDBMS structures to conform with the bigdata standards• Experienced firsthand performance tuning situations, fine-tuned numerous complex queries using strategies like adding indexes, revisiting the joins, collecting stats, reviewing the query execution plans, etc. and helped in reducing CPU runtime• Suggested optimal data modeling techniques aligning to the customer requirements after performing thorough analysis on the client data• Adapted to agile development framework and worked on time critical sprints with uncompromisable deliverablesETL Developer – Client: Bank of America – EDM Deposits and Channels• Built data warehouse applications and data pipelines to ETL/ELT Data using DMExpress tool and Teradata as backend• Developed data pipelines to hydrate the target tables that helped bank in federal US regulatory reporting• Efficiently transformed the raw data from up-stream flat files to business measure on HDFS using Map-Reduce• Developed high performing SQL queries on multiple tables using complex joins and aggregate functions.• Performed staging of data from multiple systems and developed ETL transformations for populating Operational data store and storing historical Risk data in Risk Data Warehouse• Implemented platform migration on two legacy applications with intensive CDC processing• Participated in full lifecycle analysis including requirement gathering, effort estimation, architecture and delivery