6+ years of experience with a suite of BI technologies (Snowflake, SAP HANA, Python, AWS, Azure, Power BI, Tableau, Matillion, HVR).

• Should be able to design, develop and be able to perform analysis of vast data stores and uncover insights using Snowflake SQL abilities.

• Should have very good working knowledge on Snowflake internals – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts.

• Should be able to load from disparate data sets and translate complex functional and technical requirements into detailed design.

• Should have a good understanding of database design concepts - Transactional / Data mart / Data warehouse etc.

• Should have hands-on experience on Oracle, PL/SQL development and performance tuning.

• Should have very good working experience in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning Zero copy clone, time travel and understand how to use these features.

• Should be aware in deploying Snowflake features such as data sharing, events and lake-house patterns.

• Gather requirements to define Snowflake services and accordingly implement different security features.

• Perform infrastructure integration verification and individual service verification. • Setup IAM Roles and apply different policies to users/groups.

• Perform integration testing of developed infrastructure. Technical Skills Snowflake, PLSQL, ETL, Talend, Informatica, DWH

• Experience working on SnowSQL, Snowpipe, Data Replication, Data-sharing & Data-ingestion into Snowflake End to end Snowflake implementation experience is strongly desired Experience with Data Architecture, Data Governance, Data Quality, Data Security & Performance Optimization

• Experience in ad-hoc data analysis, solution design, reporting & dashboard development

• Experience in any ETL tool Informatica/Talend is preferable.

• Nice to have experience in Data Migration from RDBMS to Snowflake cloud data warehouse.

• Understand & document the DW storage & architecture

• Snowflake configuration & setup

• Develop Snowflake views, scripts and other jobs

• Unit test the Snowflake setup