Snowflake Administration

Job Overview:

• The Snowflake Platform Administrator plays a vital role in overseeing, securing, and providing support for the Snowflake data platform across a variety of business sectors.
• This position is centered on platform administration, access governance, integration facilitation, and operational assistance to guarantee dependable and compliant data ingestion and replication throughout enterprise systems.
• Collaborating closely with cross-functional stakeholders, the administrator ensures smooth data transfer between Snowflake and integrated platforms, including Kafka, Confluent Cloud, ADLS, and other downstream systems.
• At a senior level, this role also aids in platform optimization, performance tuning, cost-effectiveness, and governance enforcement, while ensuring scalable and secure operations of the data platform in multi-cloud environments.

Primary Responsibilities:

• Serve as the Snowflake Platform Administrator within the client ecosystem.
• Oversee the administration, governance, and operational stability of the Snowflake platform.
• Facilitate data onboarding through established Snowflake integration methods.
• Ensure adherence to RBAC, SSO security, and audit controls.
• Assist onboarding teams with connector creation, configuration, and validation.
• Engage in close collaboration with cross-functional stakeholders to maintain a secure and scalable architecture for the Snowflake platform.
• Possess knowledge of Terraform, as there are several Terraform scripts in use.
• Demonstrate the ability to understand and write stored procedures.
• Have a foundational understanding of Python and JavaScript.
• Familiarity with GitHub and Jira is essential.
• Manage roles at the Snowflake account, database, schema, and object levels utilizing the RBAC model, including role hierarchy and grants.
• Administer Azure AD SSO group mappings, SCIM, and OAuth integration for automated user provisioning and access control.
• Maintain domain-based roles and database structures, ensuring segregation across DEV, QA, and PROD environments.
• Oversee access lifecycle management, including granting and revoking roles and privileges via ServiceNow request workflows, ensuring compliance documentation is updated.
• Support Snowflake object lifecycle management for databases, schemas, tables, views, stages, tasks, and streams.
• Assist with data platform onboarding and integration enablement, 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.
• Coordinate with Security teams for Firewall rules, VPN approvals, and access governance.
• Conduct Data Validation and Quality Assurance.
• Provide Monitoring and Incident Support.
• Prepare and maintain Snowflake SOLD Solution Design Documents, integration templates, and Knowledge Base articles for access and onboarding.

Technical Qualifications:

• Extensive experience in Snowflake platform administration.
• Manage daily administration of Snowflake environments, including databases, schemas, and warehouses.
• Oversee compute warehouses for scalability, performance, and cost optimization.
• Ensure platform stability, availability, and operational efficiency.
• Handle incident management, troubleshooting, and root cause analysis (RCA).
• Experience with Snowflake schemas, RBAC permissions, and Azure ADLS PrivateLink networking.
• Comprehension 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.
• Familiarity with Incident and Change Management practices.
• Experience with Snowflake and Confluent Kafka is highly advantageous.
• Exposure to cloud platforms such as AWS, GCP, or Azure.
• Knowledge of data governance, security, and compliance standards.
• Experience in Agile environments and CI/CD methodologies.
• Familiarity with ServiceNow workflows.
• Exposure to Data world and Manta.

Other Responsibilities:

• Infosys is a leading global provider of 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 in managing the systems and operations of global enterprises, we expertly guide our clients through their digital evolution.
• We achieve this by empowering the enterprise with an AI-driven core that helps prioritize change execution.
• We also enable businesses with agile digital solutions at scale to achieve unprecedented levels of performance and customer satisfaction.
• Our ongoing learning agenda fosters continuous improvement by building and transferring digital skills, expertise, and innovative ideas from our ecosystem.
• All employment opportunities at Infosys are based on merit, competence, and performance.
• We are dedicated to promoting diversity and cultivating an inclusive environment for all employees.
• Infosys is proud to be an equal opportunity employer.

Desired Skills:

Technology->Data on Cloud-DataStore->Snowflake