Mandatory skills: Snowflake, DBT , SQL, Python
Job Description:
· Create, test, and implement enterprise-level apps with Snowflake.
· Design and implement features for identity and access management.
· Create authorization frameworks for better access control.
· Implement novel query optimization, major security competencies with encryption.
· Solve performance issues and scalability issues in the system.
· Transaction management with distributed data processing algorithms.
· Possess ownership right from start to finish.
· Build, monitor, and optimize ETL and ELT processes with data models.
· Migrate solutions from on-premises setup to cloud-based platforms.
· Knowledge of SQL language and cloud-based technologies
· Data warehousing concepts, data modeling, metadata management
· Data lakes, multi-dimensional models, data dictionaries
· Migration to AWS or Azure Snowflake platform
· Performance tuning and setting up resource monitors.
· Snowflake modeling – roles, databases, schemas
· SQL performance measuring, query tuning, and database tuning
- · ETL tools with cloud-driven skills