Coordinate with offshore team members and onshore team members for data warehouse physical model deliveryCoordinate different IT teams and design solutions for the following non-functional-requirements of the Snowflake data warehousing project:- Resource & Cost Monitoring by using dbt-snowflake-monitoring package- Outage Detection & Alerting by building snowflake external function and API integration with ServiceNow- Disaster Recovery and Failover Strategy by applying snowflake DR and Failover zone strategy- Logging strategy by using Datadog, QRadar application to collect snowflake log in and query events

Enhance and maintain existing data acquisition solution from multiple data sources (SAP, Shopify, SFTP, etc.) using Azure Databricks, Azure Data Factory and Azure Datalake.

• Design data solutions using MS Azure BI stack that enable clients to see the whole picture and provide insightful and accurate analysis that helps to build successful businesses.• Design migration strategy for clients to migrate their On-Prem ETL solution to Azure Cloud based solution with better scalability and flexibility and lower cost.• Work with team members to implement the data solution using Azure Data Lake, Azure Databricks, Azure Synapse, Azure SQL DB, Azure Data Factory and Azure DevOps

• Gathering front-end requirements to develop T-SQL scripts to generate usable endpoint tables for amplifying statistical analysis capabilities and enabling data visualization in front-end. Creating Index, Views, complex Stored Procedures, appropriate user defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.• Maintain and troubleshooting of SSIS Packages, stored procedures as well as optimizing SQL Server Performance• Follow the specifications provided by the Data Architect for development of SQL Server Integration Services based solutions for migrating data in both OLTP and Data Warehouse environments. Maintain and enhance complex Stored Procedures to meet business requirement• Work with other developers, data architects, DBAs, project managers, and client business users to develop ETL specifications and resolve client questions around problems and enhancements.24 hours on-call to monitor data ETL process and coordinate with other developers to troubleshoot ETL process failure.

• Involved in the full lifecycle of BI development including requirements gathering, design, development, testing, and providing end user support for a full stack Microsoft BI Platform.• Creating Data Models, Data Sets, Customize Reports and Schedule Report Jobs in OBIEE BI Publisher. • Build BI Server repositories from scratch, performed business modeling and mapping, created security profiles, create variables, send for testing, deploy to OBIEE Presentation Services• Key contributor to Business Intelligence (BI) & Data Management Strategy including: Information Architecture, Data Architecture, Master Data Management Architecture, Metadata Architecture and Information Delivery Life Cycle (IDLC).• Lead and worked as primary ETL Developer of our Business Intelligence team to assist in the design and development of data feeds, interfaces, data warehouses and enterprise reporting platform.• Follow the specifications provided by the Data Architect for development of SQL Server Integration Services based solutions for migrating data in both OLTP and Data Warehouse environments.• Work with other developers, data architects, DBAs, project managers, and client business users to develop ETL specifications and resolve client questions around problems and enhancements.• Prepare an analysis document with the recommended solution. Analyze, Design, Develop, and Test dimensional models. Create, test and maintain models within SSIS and other ETL tools.• Analyze, develop, test, maintain and support very complex data/process models, reports and processes in the Microsoft ETL environment using SSIS and SSRS.• Design, develop, and support complex integration processes (including interfaces) using SQL Server technology such as T-SQL stored procedures and C# code.• Build new data sets and data structures as required to support business needs, and for managing the distribution, replication, and archival of data.