Ganesh Kumar Email & Phone Number

•Total 14+ hands on experience with building product ionized data ingestion and processing pipelines using Java, Spark, Scala etc and also experience in designing and implementing production grade data warehousing solutions on large scale data technologies •Over 14+ years of experience as an IT Professional with expertise in working on analysis, design, implementation, upgrade, customization, maintenance, automation and enhancements using agile methodologies. Mainly worked on writing queries & performance tuning in Oracle (10g/ 11g/ 12c, 19c), SQL Server 2016, I have good experience on Snowflake (Cloud) and Mongo DB.•Strong experience in migrating other databases to Snowflake.•Work with domain experts, engineers, and other data scientists to develop, implement, and improve upon existing systems.•Experience in analyzing data using HiveQL•Participate in design meetings for creation of the Data Model and provide guidance on best data architecture practices•Experience with Snowflake Multi-Cluster Warehouses.•Experience in Splunk reporting system.•Understanding of SnowFlake cloud technology.•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.•Professional knowledge of AWS Redshift•Experience in building Snowpipe.•Experience in using Snowflake Clone and Time Travel.•Experience in various data ingestion patterns to hadoop.•Participates in the development improvement and maintenance of snowflake database applications•Experience in various methodologies like Waterfall and Agile.•Extensive experience in developing complex stored Procedures/BTEQ Queries.•In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles•Build the Logical and Physical data model for snowflake as per the changes required•Define roles, privileges required to access different database objects.•In-depth knowledge of Snowflake Database, Schema and Table structures.•Define virtual warehouse sizing for Snowflake for different type of workloads.•Worked with cloud architect to set up the environment•Coding for Stored Procedures/ Triggers.•Designs batch cycle procedures on major projects using scripting and Control•Develop SQL queries SnowSQL•Develop transformation logic using snowpipeline.•Optimize and fine tune queries•Strong experience in migrating other databases to Snowflake.