Snowflake Architect

Description:

• Snowflake and Data Modelling
• Tableau/PowerBI
• DW Concepts development
• InDepth SQL knowledge / SnowSQL is a must
• Azure Cloud & Agile method

Description:

• The client is looking for a candidates having 8 to 15 years’ experience.
• In depth knowledge in Snowflake and Data Modelling + Tableau/PowerBi, DW Concepts development
• Should be good in developing models using open source (DBT or any open source) or with modelling tools. Data Warehousing
• In-and-Out clear understanding with Hands On experience in DW, Should worked on below mentioned features at least,
• Different Constraints, Referential Integrity, Denormalization. Dimensional Modelling, Different types of Schema, Fact & Dimensions, Different types of Keys
• SCD types. SQL Knowledge, InDepth SQL knowledge / SnowSQL is a must .
• Azure Cloud & Agile method
• Designing, Developing, and maintaining the data architecture, data models in snowflake
• Able to gather end user requirements and writing technical documentation
• Hands on experience with multiple Snowflake objects implementation, SnowSQL, SnowPipe, Views and Snowflake Procedures
• Strong experience write complex SQL query stored procedure etc
• Work with Project Manager and Project Lead to get his Client user accounts created
• Worked on AVRO, PARQUET files loading to snowflake
• Knowledge of SQL, Unix & advanced Unix Shell Scripting
• Hands on file transfer mechanism FTP etc