Experience: 10+
Mandatory skills: Snowflake, DBT , SQL, Python, Datastage or Informatica, Unix
Detailed Job Description:
- 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
Roles and Responsibilities:
- 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 Client 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.