Yash Patel

Responsibilities:
 Contributed to an Agile system with bi-weekly sprints and planning sessions.
 Collaborated with cross-functional teams to identify business requirements and devise technical
solutions.
 Orchestrated the movement of data from SQL Server to Azure and subsequently to Snowflake's internal stage
before finalizing the transfer to Snowflake through the copy process.
 Designed and implemented Snowflake data warehouse solutions aligned with business requirements.
 Developed and maintained Snowflake database objects, including databases, schemas, tables, views, and stored
procedures.
 Established roles and access level privileges, overseeing Snowflake admin activities.
 Optimized queries and ETL processes for enhanced performance and efficiency.
 Analyzed and resolved performance-related issues in the Snowflake data warehouse.
 Created Snowflake data models, schemas, tables, views, and stored procedures to meet business
requirements.
 Developed ETL processes using Matillion and Informatica for extracting, transforming, and loading data from
diverse sources into Snowflake.
 Implemented data pipelines and workflows to automate data integration and processing.
 Conducted performance tuning and query optimization to enhance query performance and reduce query times.
 Ensured data security through the implementation of role-based access control, encryption, and auditing.
 Collaborated with cross-functional teams to comprehend business requirements and translate them into technical
solutions.
 Provided production support and troubleshooting for Snowflake data warehouse and ETL processes.
 Created new stored procedures and optimized existing queries and stored procedures.
 Established data sharing between two Snowflake accounts (Prod—Dev).
 Managed the migration of over 500 tables and views from Redshift to Snowflake.
 Generated reports in Looker based on Snowflake connections and validated Looker reports with the Redshift
database.
 Worked on replication and data mapping of ODS tables to Guidewire Claim Center type lists and entities.
 Validated data from SQL Server to Snowflake to ensure source-to-target accuracy.

 Provided consulting on Snowflake Data Platform Solution Architecture, Design, Development, and
Deployment, fostering a data-driven culture across enterprises.
 Drove the replacement of other data platform technologies with Snowflake, emphasizing the lowest TCO
without compromising on performance, quality, and scala

Contributed to an Agile system with bi-weekly sprints and planning sessions.
Collaborated with cross-functional teams to identify business requirements and devise technical solutions.
Orchestrated the movement of data from SQL Server to Azure and subsequently to Snowflake's internal stage before finalizing the transfer to Snowflake through the copy process.
Designed and implemented Snowflake data warehouse solutions aligned with business requirements.
Developed and maintained Snowflake database objects, including databases, schemas, tables, views, and stored procedures.
Established roles and access level privileges, overseeing Snowflake admin activities.
Optimized queries and ETL processes for enhanced performance and efficiency.
Analyzed and resolved performance-related issues in the Snowflake data warehouse.
Created Snowflake data models, schemas, tables, views, and stored procedures to meet business requirements.
Developed ETL processes using Matillion and Informatica for extracting, transforming, and loading data from diverse sources into Snowflake.
Implemented data pipelines and workflows to automate data integration and processing.
Conducted performance tuning and query optimization to enhance query performance and reduce query times.
Ensured data security through the implementation of role-based access control, encryption, and auditing.
Collaborated with cross-functional teams to comprehend business requirements and translate them into technical solutions.
Provided production support and troubleshooting for Snowflake data warehouse and ETL processes.
Created new stored procedures and optimized existing queries and stored procedures.
Established data sharing between two Snowflake accounts (Prod—Dev).
Managed the migration of over 500 tables and views from Redshift to Snowflake.
Generated reports in Looker based on Snowflake connections and validated Looker reports with the Redshift database.
Worked on replication and data mapping of ODS tables to Guidewire Claim Center type lists and entities.
Validated data from SQL Server to Snowflake to ensure source-to-target accuracy.
Provided consulting on Snowflake Data Platform Solution Architecture, Design, Development, and Deployment, fostering a data-driven culture across enterprises.
Drove the replacement of other data platform technologies with Snowflake, emphasizing the lowest TCO without compromising on performance, quality, and scalability.
Designed and created Hive external tables using a shared Meta-store with partitioning, dynamic partitioning, and buckets.
Leveraged cloud platforms, such as AWS or Azure, for seamless integration with Snowflake.
Ensured compatibility and optimal performance of Snowflake on cloud infrastructure.
Developed microservice onboarding tools using Python and Jenkins to facilitate the creation and maintenance of build jobs and Kubernetes deploys and services.

Extensive background in the Analysis, Development, Implementation, Testing, and Support of Data Warehousing, utilizing Informatica PowerCenter, Teradata, and Snowflake.
Designed and executed ETL processes in AWS Glue to seamlessly migrate Campaign data from external sources like S3 and Text Files into RedShift.
Configured Snow pipe to efficiently extract data from S3 buckets into Snowflake tables.
Managed the storage of incoming data in Snowflake's staging area.
Proficient in working with Snowflake Multi-cluster warehouses.
Implemented SCD Type 2 using Python and DBT on the claims system and executed incremental loads in the claims subject area.
Transformed BTEQ scripts to SQL scripts using Terasnow, an internal tool, and converted Informatica mappings to SQL scripts with an internal tool called ICE tool.
Monitored files in S3 and triggered jobs through UC4.
Established internal and external stages and executed data transformations during the load process.
Leveraged Snowflake's time-travel feature for data validation purposes.
Generated reports using the SAP BOBJ tool by creating universes with IDT.

Contributed to the Dimensional modeling (Star Schema) of the Data warehouse, utilizing Erwin to design business processes, dimensions, and measured facts.
Developed reference tables, applications, and workflows, deploying them to the Data integration service for subsequent execution of workflows.
Generated new database objects such as Tables, Procedures, Functions, Indexes, and Views using T-SQL in both the Development and Production environments for SQL Server 2005.
Extracted data from flat files and other RDBMS databases into the staging area, subsequently populating the Data warehouse.
Published records to downstream applications with the assistance of ETL PowerCenter, employing message queues.
Generated reports to assess the performance of Informatica CDC workflows.
Utilized PowerCenter Designer tools to develop mappings for extracting and loading data from XML files into various Flat File formats.
Employed DataStage Designer for data extraction from Flat files and UNIX file systems, treating data as flat files.
Constructed complex queries to transform source data, loading them onto SQL Server, DB2, and SYBASE platforms.
Formulated Batches for sessions of each system to load data sequentially.
Implemented a command task to initiate the desired workflow upon completion of the Batch ID session.
Extracted data from diverse sources like DB2 UDB, XML Files, Flat Files, and CSV files, loading them into the target DB2 UDB (Corporate Data Warehouse).
Developed jobs utilizing different parallel job stages like Join, Merge, Lookup, Remove Duplicates, Filter, Dataset, Lookup File Set, Change Data Capture, Switch, Modify, and Aggregator.
Extensively designed, developed, and implemented Parallel Extender jobs using Parallel Processing
Participated in Unit, Integration, System, and Performance testing phases.
Produced documentation describing program development, logic, coding, testing, changes, and corrections.
Migrated code into QA (Testing) and supported the QA team and UAT (User).
Initiated data modeling sessions to design and build/append appropriate data mart models supporting the reporting needs of applications.
Implemented Change Data Capture (CDC) to extract information from various Oracle tables and applied Pushdown Optimization in Informatica PowerCenter.
Validated test cases and produced a risk estimation sheet, offering clear information on the risk factors for downstream partners due to the change.
Collaborated with developers to prioritize and translate requirements, defects, and enhancements into product features.