Responsible to• Extract, Load, Transform, clean, and validate data in Snowflake DWH. • Design and architecture of data warehouse, including staging area, data lakes, data warehouse, data marts, and operational data stores.• Involved in creating Stored Procedures, Functions, Views, Tasks in Snowflake DB. Designed and developed data extraction, transformation and loading process using ADF pipelines and snowflake SPs.• Work with business SMEs to translate business requirements into technical design for ETL process and BI visualization with complex DAX functions.• Have hands-on with cloud based Datawarehouse Snowflake and developing pipelines using Azure Data Factory, scheduling pipelines, storage repo and deploying from development environment to test and production with GITHUB integration.• Developing azure data factory pipelines to transform data from blob/on premise SQL DB and API calls to external source systems to Snowflake Data Warehouse.• Creating logic apps to send email notifications to different users when an event happens in various applications, services, and systems. Error handling, alerts, and notifications in pipelines with incident management integration for job failures.• Automate the data validation process with source and DWH.• Implemented RLS (Role Level Security) in Power BI reports.• Migrated SQL Server DB to Snowflake cloud DWH.• Managed the 7 members team and responsible for code review of ETL and reporting deliverables.

• 8+ years of IT Experience in Microsoft SQL Server 2008/2005 Development, Test and Production Environments in business domains like Consumer Goods and Retail.• In-depth Experience in Transact-SQL (DDL, DML, DCL), and in Design and normalization of the database tables.• Proficient in creating, modifying and implementing Stored Procedures, Functions, Views, Triggers and SSIS Export & Import.• In-depth knowledge of SSRS and SSIS.• Good hands on experience in RDBMS concepts, data models.• ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, Netezza, SQL Server and Flat File sources and load into various other Business Entities.• Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc.• Very good Experience in scheduling and deploying reports on report manger.• Expertise in Microstrategy Desktop creating reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups)• Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations in Microstrategy• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exceptional ability to quickly master new concepts and capable of working in-group as well as independently.