- Design and implement scalable data storage solutions using Snowflake - Writing SQL queries against Snowflake, developing scripts to do Extract, Load, and Transform data.
- Write, optimize, and troubleshoot complex SQL queries within Snowflake - Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, Time travel, Cloning, Optimizer, Metadata Manager, data sharing, stored procedures and UDFs.
- Develop and maintain ETL processes using Informatica PowerCenter - Integrate Snowflake with various data sources and third-party applications - Experience in Data Lineage Analysis, Data Profiling, ETL Design and development, Unit Testing, Production batch support and UAT support.
- Involve SQL performance tuning, Root causing failures and bifurcating them into different technical issues and resolving them.
- In-depth understanding of Data Warehouse, ETL concepts and Data Modelling.
- Experience in requirement gathering, analysis, desi...