Snowflake Administration

Job Overview:

• The Snowflake Platform Administrator is tasked with overseeing the management, security, and support of the Snowflake data platform across various business sectors.
• This position emphasizes platform administration, access governance, integration enablement, and operational support to ensure consistent and compliant data ingestion and replication throughout enterprise systems.
• By collaborating closely with diverse stakeholders, the administrator facilitates seamless data integration between Snowflake and associated platforms such as Kafka, Confluent Cloud, ADLS, and other downstream systems.
• In a senior capacity, the role also contributes to platform optimization, performance tuning, cost efficiency, and governance enforcement, while ensuring scalable and secure operations of data platforms in multi-cloud environments.

Core Responsibilities:

• Serve as the Snowflake Platform Administrator within the client ecosystem.
• Take ownership of the administration, governance, and operational integrity of the Snowflake platform.
• Facilitate data onboarding using established Snowflake integration patterns.
• Ensure adherence to RBAC, SSO security, and audit controls.
• Assist onboarding teams with connector creation, configuration, and validation.
• Engage in close collaboration with stakeholders to maintain a secure and scalable Snowflake platform architecture.
• Possess knowledge of Terraform, as a few Terraform scripts are utilized.
• Demonstrate the ability to understand and write stored procedures.
• Have a solid understanding of Python and Java scripts.
• Familiarity with GITHUB and Jira is essential.
• Manage roles at the Snowflake account, database, schema, and object levels using an RBAC model, including roles, role hierarchy, and grants.
• Administer Azure AD SSO group mappings, SCIM, and OAuth integration for automated user provisioning and access control.
• Maintain environment domain-based roles and database structure, ensuring segregation between DEV, QA, and PROD environments.
• Oversee access lifecycle management, including granting and revoking roles and privileges via ServiceNow request workflows while ensuring compliance documentation is updated.
• Support the lifecycle management of Snowflake objects, such as databases, schemas, tables, views, stages, tasks, and streams.
• Assist with data platform onboarding and integration enablement, including schema setup, access provisioning, and initial environment configuration.
• Manage data access and sharing configurations, secure data sharing, external integrations, and role-based access segregation.
• Enforce RBAC policies across account, database, schema, and object levels, ensuring domain-based access segregation.
• Collaborate with Security teams regarding Firewall rules, VPN approvals, and access governance.
• Conduct data validation and quality assurance.
• Provide monitoring and incident support.
• Prepare and maintain Snowflake Solution Design Documents, integration templates, and knowledge base articles for access and onboarding.

Technical Qualifications:

• Extensive experience in Snowflake platform administration.
• Manage daily administration tasks for Snowflake environments, including databases and schemas.
• Oversee compute warehouses, focusing on scaling, performance, and cost optimization.
• Ensure stability, availability, and operational efficiency of the platform.
• Handle incident management, troubleshooting, and root cause analysis (RCA).
• Experience with Snowflake schemas, RBAC permissions, and Azure ADLS PrivateLink networking.
• Understanding of Data Mesh and domain-driven architecture.
• Experience with VPN, Proxy, SSH tunnels, and static IP configurations.
• Coordinate efforts with Infrastructure and Networking teams.
• Monitor and troubleshoot data pipelines.
• Proficient in incident and change management processes.
• Experience with Snowflake and Confluent Kafka is a significant advantage.
• Familiarity with cloud platforms such as AWS, GCP, or Azure.
• Knowledgeable in data governance, security, and compliance standards.
• Experience in Agile methodologies and CI/CD practices.
• Familiarity with ServiceNow workflows.
• Exposure to Data world and Manta.

Additional Information:

• Infosys is a global leader in next-generation digital services and consulting.
• We assist clients in over 50 countries in navigating their digital transformation journeys.
• With more than 40 years of experience managing global enterprise systems, we adeptly guide our clients through their digital transitions.
• We empower enterprises with an AI-driven core to prioritize and execute change effectively.
• Our agile digital solutions at scale enable unprecedented levels of performance and customer satisfaction.
• Our commitment to continuous improvement is reflected in our always-on learning agenda, which builds and transfers digital skills, expertise, and innovative ideas.
• All employment aspects at Infosys are determined by merit, competence, and performance.
• We are dedicated to fostering diversity and creating an inclusive environment for all employees.
• Infosys is proud to be an equal opportunity employer.

Preferred Skills:

Technology->Data on Cloud-DataStore->Snowflake