Remote - Offshore - Snowflake Lead

  • Hyderabad
  • Resource Informatics Group, Inc

Role: Snowflake Technical Lead


  • Must have played Technical role as Snowflake Technical Lead.
  • Must have prior experience with end-to-end implementation of Snowflake cloud data migration from on-premises preferably from any RDBMS like SQL Server, Oracle, Teradata etc.
  • Expertise and hands-on experience in Snowflake - data modelling, ELT using Snowflake SQL, Stored Procedure, Snowpark.
  • Should have hands-on experience in AWS Glue/Pyspark Data Frame/DataStage/Matillion/Informatica and AWS data storage and management technologies such as S3.
  • Should have Snowflake advanced concepts like setting up resource monitors, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, Streams and Tasks.
  • Hands-on experience with Snowflake utilities, Copy Command from S3, SnowSQL, SnowPipe.
  • Must be proficient in complex SQL, Unix Shell Scripting, performance tuning and troubleshooting.
  • Experience with data security and data access controls and design, RBAC Policies, Dynamic Masking, Secured Views etc.
  • Nice to have hands-on experience in Airflow, Data Unloading from Snowflake and Snowflake utilities.
  • Provide resolution to an extensive range of complicated data pipeline related problems, proactively helping the team and take the ownership for closer.
  • Must be SnowPro Core Certified Professional.
  • Snowflake Advance Architect Certified Professional (Desirable).
  • Must have experience of Agile development methodologies.
  • Should have very good written and verbal communication skills.
  • Should have played Customer facing role.