Tech lead/Solution Architect for Customer data engineering team which is responsible for owning/supporting customer data platform , MDM and related marketing & analytical platform/processes which houses 80M+ customer’s profiles and related data of multiple countries and brands.Provide architectural guidance to business on new initiatives and provide suitable solution to re-architect Customer data systems.Lead the technical design and delivery of Customer data technology/Marketing/Digital/Privacy/Analytics projects, document end-to-end solutions, define standards , work with team to develop, review and test the changes.Lead and implemented the critical cross functional initiative to change the definition of customer to resolve 50M+ customer profiles which involves changes across upstream/downstream systems, large data clean ups and redefining identity rules. Involved and partnered with multiple teams and helped to define solution and strategy for building Customer data platform, Change email service provider & build Customer genome as part of new MarTech initiative.Involved and contributed to building in-house loyalty engine real rewards program.Implemented customer data privacy automations(GDPR/CCPA)Involved and lead GCP BQ migration and contributed to overall data platform architecture framework in GCP .Tech stack:DI : Talend, Informatica,RDBMS, SQL, Snowflake, DBTGoogle Cloud Platform: Big Query, Composer, Airflow, Data fusion ,PubsubMarketing stack : ActionIQ, Bloomreach, Amperity, GA360, Liveramp Informatica Product Suite : Informatica MDM, informatica data quality , power center, Address doctor, BES

Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake table. Experience in building Snow pipe for continuous data loads. Experience in using Snowflake Clone and Time Travel. In-depth knowledge of Snowflake Database, Schema and Table structures. Experience in working with Streams and Tasks. Worked on SAP ERP Data Experience in building ETL pipelines to fetch data from various source systems and loading into snowflake tables Defining virtual warehouse sizing for Snowflake for different type of workloads. In depth knowledge on different file formats and functions used in Copy command for data load. Experience in developing SQL queries using Snow SQL. Hands-on experience with Snowflake utilities, Snow SQL , Snow Pipe. Experience in working with Data pruning , Micro partitioning , Clustering. Experience in migrating data from Netezza to Snowflake. Implemented Change Data Capture technology using streams and tasks in order to load new records to a Data Warehouse. Building the Logical and Physical data model for snowflake as per the changes required In-depth knowledge of Cache concepts(Result Cache , warehouse cache) in Snowflake. Used COPY to bulk load the data. Created internal and external stage and transformed data during load. Used Temporary and Transient tables on different datasets. Used Informatica to load incremental data from source table to snowflake warehouse. Creating informatica mappings to load data to various fact and dimension tables. Experience in creating mappings , workflows, tasks, transformations in informatica. Experience in working with scheduling tool called control-m to schedule informatica jobs for data loads. Ability to develop scripts (Unix, Python etc.) to do Extract, Load and Transform data Experience in writing python scripts for automating various use cases for QE