Snowflake Administration

Job Overview:

• The Snowflake Platform Administrator is tasked with the responsibility of securing, managing, and supporting the Snowflake data platform across various business sectors.
• This position emphasizes platform administration, access governance, integration enablement, and operational support to guarantee dependable and compliant data ingestion and replication within enterprise systems.
• By collaborating closely with cross-functional stakeholders, the administrator facilitates smooth data transactions between Snowflake and integrated platforms, including Kafka, Confluent Cloud, ADLS, and other downstream systems.
• At a senior level, this role also plays a part in optimizing the platform, tuning performance, enhancing cost efficiency, and enforcing governance while ensuring scalable and secure data platform operations in multi-cloud settings.

Core 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 by implementing standardized Snowflake integration patterns.
• Ensure adherence to RBAC, SSO security, and audit control measures.
• Assist onboarding teams with connector creation, configuration, and validation processes.
• Work in close partnership with cross-functional stakeholders to ensure a secure and scalable Snowflake platform architecture.
• Possess knowledge of Terraform, as a few Terraform scripts are utilized.
• Demonstrate the ability to understand and develop stored procedures.
• Have a foundational understanding of Python and JavaScript.
• Familiarity with GitHub and Jira is required.
• Manage roles at the 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 management.
• Maintain environment domain-based roles and database structures, ensuring segregation for DEV, QA, and PROD domains.
• Oversee access lifecycle management, granting and revoking roles and privileges via ServiceNow request workflows, while ensuring compliance documentation updates.
• Support the lifecycle management of Snowflake objects, including 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 configurations for data access and sharing, focusing on secure data sharing and external integrations with role-based access segregation.
• Enforce RBAC policies across account, database, schema, and object levels, ensuring domain-based access segregation.
• Collaborate with Security teams on firewall rules, VPN approvals, and access governance.
• Perform data validation and quality assurance activities.
• Engage in 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 administering the Snowflake platform.
• Manage the daily administration of Snowflake environments, including databases, schemas, and warehouses.
• Oversee compute warehouses, focusing on scaling, performance, and cost optimization.
• Ensure the platform's 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.
• Understanding of data mesh and domain-driven architecture.
• Experience with VPN, Proxy, SSH tunnels, and static IP configurations.
• Coordinate with Infra and Networking teams.
• Monitor and troubleshoot data pipelines.
• Experience in incident and change management.
• Familiarity with Snowflake and Confluent Kafka is a strong advantage.
• Exposure to cloud platforms like AWS, GCP, or Azure.
• Knowledge of data governance, security, and compliance standards.
• Experience in Agile environments and CI/CD practices.
• Familiarity with ServiceNow workflows.
• Exposure to the data ecosystem and Manta.

Additional Information:

• Infosys is a global frontrunner in next-generation digital services and consulting.
• We assist clients in over 50 countries in navigating their digital transformation journeys.
• With more than four decades of experience in managing the systems and operations of global enterprises, we adeptly guide our clients through their digital evolution.
• We enable the enterprise with an AI-powered core, helping prioritize the execution of change.
• Our approach empowers businesses to implement agile digital solutions at scale, achieving unprecedented performance and customer satisfaction.
• Our continuous learning agenda promotes improvement through developing and transferring digital skills, expertise, and innovative ideas from our ecosystem.
• All employment aspects at Infosys are based on merit, competence, and performance.
• We are dedicated to embracing diversity and fostering an inclusive environment for all employees.
• Infosys is proud to be an equal opportunity employer.

Preferred Skills:

Technology->Data on Cloud-DataStore->Snowflake