Pratik Thole

Background

About Pratik Thole

Around 2 years of Professional IT experience with Data Warehousing and Business Intelligence background in Designing, Developing, Analysis Implementation and post Implementation support of Data Warehousing applications with Snowflake, Talend. •Experience in retail domain project in migrating Netezza database to Snowflake Cloud Database and IBM Datastage jobs to Talend Open Studio. •Experience in working on different activities as development, unit testing, pre-production, production tasks, reporting issues and bug fixing. •Hands on Experience on working with complex queries, slowly changing dimensions (SCD) and developing stored procedures. •In-depth knowledge on unique snowflake features like timetravel, fail safe, catching, coning, virtual warehouse, microportioning and clustering, Query History and data sharing. •Proficient in Design and Development of process required to Extract, Transform and Load the large and complex structured and semi-structured data sets into the data warehouse using Snowflake Cloud Database, Cloud Storage. •knowledge on building a complete data pipeline using stream, task and snowpipe and loading data into Internal and External Stages. •Experience on working with different database object as Transient, Temporary, Permanent tables and materialized, non-materialized and secure views. •knowledge on different security features as discretionary access control (DAC), role-based access control (RBAC), masking policies. •Experience in developing ETL jobs using Talend Open Studio and working with IBM Datastage jobs.