Snowflake Administration

Company: Genpact
Location: Alpharetta
Posted on: July 31, 2022

Job Description:

Azure Snowflake Administration Alpharetta, Georgia, United States C2h,Fulltime Contract
Responsibilities:

• Overall Experience per customer JD:
• Query Snowflake DB from standalone tools like Kafka Connectors, APIs, Bash Scripts
• Perform Read/Write CRUD operations on Snowflake (viz. Warehouse, Schema, DB, Tables, Views)
• Setup on-prem monitoring & HealthCheck's on Azure Snowflake instances viz. Grafana/Prometheus, Application Insights
• Integrate ETL process with Snowflake leveraging Dataops pipeline concept
• Able to write Python/Scala code to load/index data from Snowflake via OAuth2.0 connectivity
• Configuring index pipeline & setup Kafka based indexing (Partial updates/inserts)
• Configuring Kafka Connector to read Streaming Data from Topics & ingest data into Snowflake DB
• Error handling - retry/replay of connectors if upstream/downstream system fails. Report errors via Splunk dashboards, Skype/Symphony notifications
• Mandate skills:
• Must used Spark to ingest data into Snowflake from data sources like MsSQL, DB2
• Optional skills (Good to have):
• Setup monitoring alerts on Snowflake using Grafana, Splunk around DDL/DML transactions, Table sizes, etc.
• Aware about how to index or load data into Snowflake from Middleware services like Dataiku, Databricks viz. OAuth connection

Keywords: Genpact, Alpharetta , Snowflake Administration, Other , Alpharetta, Georgia