Hi,
Please find the job description below and let me know if any consultant is available:
Client: Infosys
Job Title: Snowflake App Admin
Location: Rosemead, CA
Position type: Contract
Contract duration: 6 Months+ extension possible
Detailed job description -
Certified in Snowflake SnowPro Core
Implement Time Travel on Warehouses and Schemas
Implement Multi-cluster warehouse
Assure highest performance when repeating queries from a collection of BI tools, reports and dashboards
Backup and Recovery
Migration of components between Dev, QA and Production environment through DevOps setup on GitHub
Migration of historical data from Oracle DB into Snowflake using AZ Copy into Blob and Snowflake
Expertise in Snowflake – data modeling, ELT/ETL using Snowflake SQL and Talend (optional)
Technical Skills
Snowflake App Admin experience
Cloud DW Admin
Snowflake SQL
Azure Cloud
Big Data Admin experience
Compute Management
• Scaling Virtual Warehouses Up & Out
• Creating and Managing Virtual Warehouses
Snowflake Objects & Commands
• Built-in Design and Comparison to Traditional SQL Commands
• DDL Commands to Work with Different Database Objects
• Different Functions and Operators Available in Snowflake
• Account, Session, & Object Parameters
Storage Management
• Table Design Considerations
• DML and Cloning Considerations
• Storage Optimization
Performance Methodology & Management
• Query Profile Analysis
• Query Best Practices
• Caching
• Troubleshooting Tools & Tuning Performance Metrics
• Data Clustering
• Search Optimization Service
• Materialized Views
Implement Role-based Access & Design
• System Roles & Custom Roles
• Role Hierarchy
• Best Practices
• Column-Level Data Security to Protect Sensitive Data
Thanks & Regards
Abhishek Chellumala
VEDAINFO INC
Office:-310-929-1616 EXT 113
Direct:-+1 310-589-4470
E-Mail:-Abhishek@vedainfo.com
No comments:
Post a Comment