Responsibilities
- Create test and implement enterpriselevel 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
- Build monitor and optimize ETL and ELT processes with data models
- Understand and implement the latest delivery approaches based on data architecture
- Project documentation and tracking based on understanding user requirements
- Manage documentation of data models architecture and maintenance processes
- Continually review and audit data models for enhancement
- Maintenance of ideal data pipeline based on ETL tools
- Coordination with BI experts and analysts for customized data models and integration
- Code updates new code development and reverse engineering
- Performance tuning user acceptance training application support
- Perform Risk assessment management and mitigation plans
- Regular engagement with teams for status reporting and routine activities
- Migration activities from one database to another or onpremises to cloud
Requirements
At least 5 years experience in enterpriselevel Snowflake applications:
- Data ingestion into Snowflake
- Snowflake modeling roles databases schemas
- Performance tuning and setting up resource monitors
- SQL performance measuring query tuning and database tuning
- Using ETL tools to build data warehouses
- Managing sets of XML JSON and CSV from disparate sources
Knowledge of:
- Snowflake warehousing architecture processing administration
- SQL language and cloudbased technologies data warehousing concepts data modeling metadata management
- SQLbased databases like Oracle SQL Server Teradata etc.
- Coding in languages like Python Java JavaScript
- Root cause analysis of models with solutions
Remote Work :
No