Primary Skills- AWS: EMR, AWS Glue, Amazon Redshift, Azure Data Factory, Azure Synapse, Databricks, PySpark, Python, Snowflake, Visualization Reporting Tableau, SSRS and PowerBI Secondary skills- Advanced analytics, BODS, Business Objects, Cloudera, IBM Cognos, Crystal Framework, Data Governance, DataStage, Informatica, MicroStrategy, Netezza, on premise platform knowledge, SAS, SSIS, Teradata, WebFocus Overall, 12+ years of experience on data domain with at least 3-5 years of experience on Snowflake Lead effort to design, build and configure applications, acting as primary POC Snowflake Architecture Experience in designing and architecting Snowflake projects Clear understanding of Snowflakes advanced concepts like data sharing, data clean rooms, virtual warehouses, query performance using micro partitions and pruning, zero copy clone, time travel, resource monitors and security control methods including network, data, role based etc. In depth understanding of Snowflake Architecture including Snow SQL, Performance tuning, Compute and Storage Extensive experience writing and tuning SQL queries. Hands on experience in data virtualization tools like Starburst, Denodo etc. Experience in Hadoop eco system. Experience in building data lake on Cloudera Data Platform. Excellent in Written and Verbal Communication consultant should have experience in report migration work (Tableau to PowerBI, SSRS to PowerBI) Postgress SQL, AWS platform experience is also must required skill
