26 Aug
|
Infosys
|
Bengaluru
Job Summary
Educational Requirements Bachelor of Engineering
Service Line Data Analytics Unit
Responsibilities
- Manage Snowflake accounts, warehouses, databases, schemas, and roles.
- Configure and maintain virtual warehouses (compute layers).
- Handle user access, RBAC, and security policies.
- Monitor system usage and ensure platform stability.
- Optimize Snowflake queries, warehouse sizing, and auto-scaling.
- Identify and resolve performance bottlenecks.
- Implement clustering, partitioning, and caching strategies.
- Monitor query performance using Query Profile and History.
- Track and optimize Snowflake credit usage.
- Implement cost-saving strategies: auto suspend/resume; right-sizing warehouses; query optimization.
- Generate usage reports and cost dashboards.
- Implement data security best practices.
- Role-based access control (RBAC).
- Row-level and column-level security.
- Manage data encryption and masking policies.
- Ensure compliance with organizational security standards.
- Data Integration Pipeline Support:
support data loading using Snowpipe, bulk loads (COPY INTO), external stages (S3, Azure Blob).
- Collaborate with ETL teams (Informatica, Airflow, dbt, etc.).
- Troubleshoot data ingestion and transformation issues.
- Backup and Recovery: utilize Time Travel and Fail-protected features; perform data recovery and disaster recovery planning; ensure data availability and integrity.
- Monitoring and Troubleshooting: monitor system health, workloads, and query activity; troubleshoot query failures, data load issues, and performance degradation; handle incident management, RCA, and SLA adherence.
Technical and Professional Requirements
- Primary skills: Snowflake admin
Preferred Skills
- Technology->Database Administration->Sybase Admin
- Domain->Healthcare->Administrative tools
- Technology->Data on Cloud-DataStore->Snowflake
📌 Snowflake Admin (Bengaluru)
🏢 Infosys
📍 Bengaluru