Logo of Huzzle

Snowflake SQL

image

Virtusa

1mo ago

  • Job
    Full-time
    Senior Level
  • Data
    IT & Cybersecurity
  • Chennai

AI generated summary

  • You need strong Snowflake SQL skills, experience with utilities (SnowSQL, SnowPipe), Fivetran integration, data pipeline design, excellent communication, problem-solving abilities, and Snowflake certification preferred.
  • You will write Snowflake SQL, develop ETL scripts, manage Fivetran connectors, design data pipelines, and utilize Snowflake utilities while collaborating effectively within a global team.

Requirements

  • Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data.
  • Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
  • Design and implement scalable and performant data pipelines for ingesting, processing and transforming data from various sources into Snowflake.
  • Proven experience in configuring and managing Fivetran connectors for data integration.
  • Establish connectivity from Fivetran to Snowflake.
  • Excellent SQL coding skills
  • Excellent communication & documentation skills.
  • Complex problem-solving capability and ever improvement approach.
  • Must be analytic, creative and self-motivated.
  • Work Effectively within a global team environment.
  • Snowflake Certification - would be preferred.
  • Familiar with Agile delivery process.
  • Excellent Communication skills

Responsibilities

  • Snowflake SQL Writing
  • SQL queries against Snowflake
  • Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data.
  • Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
  • Design and implement scalable and performant data pipelines for ingesting, processing and transforming data from various sources into Snowflake.
  • Proven experience in configuring and managing Fivetran connectors for data integration.
  • Establish connectivity from Fivetran to Snowflake.
  • Excellent SQL coding skills
  • Excellent communication & documentation skills.
  • Complex problem-solving capability and ever improvement approach.
  • Must be analytic, creative and self-motivated.
  • Work Effectively within a global team environment.

FAQs

What are the primary responsibilities of the Snowflake SQL position?

The primary responsibilities include writing SQL queries against Snowflake, developing scripts in Unix and Python for data extraction, loading, and transformation, and designing and implementing scalable data pipelines.

What skills are required for the Snowflake SQL role?

Required skills include excellent SQL coding abilities, experience with Snowflake utilities, familiarity with Fivetran connectors, problem-solving capabilities, and effective communication and documentation skills.

Is Snowflake certification required for this position?

Snowflake certification is preferred but not mandatory.

What tools and technologies will I be working with in this role?

You will be working with Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, metadata management, and various programming languages including Python.

Can you describe the work environment at Virtusa?

Virtusa values teamwork, professional development, and personal growth. You will be joining a global team that focuses on collaboration and fostering new ideas.

Is experience with Agile delivery processes necessary for this role?

Yes, familiarity with the Agile delivery process is beneficial for this position.

What are the opportunities for growth in this position?

There are numerous opportunities for professional growth and development through exciting projects and working with state-of-the-art technologies.

How does Virtusa promote diversity in its workforce?

Virtusa is committed to equal opportunity and does not discriminate based on race, religion, gender identity, sexual orientation, or any other basis protected by law.

What is the structure of the team I will be working with?

You will be part of a global team that values collaboration and works together to tackle complex challenges.

Is there an emphasis on continuous improvement in the job role?

Yes, the position emphasizes complex problem-solving capability and a continuous improvement approach.

Business transformation that lasts starts with Engineering First.

Technology
Industry
10,001+
Employees
1996
Founded Year

Mission & Purpose

Virtusa Corporation provides digital engineering and technology services to Forbes Global 2000 companies worldwide. Our Engineering First approach ensures we can execute all ideas and creatively solve pressing business challenges. With industry expertise and empowered agile teams, we prioritize execution early in the process for impactful results. We combine logic, creativity and curiosity to build, solve, and create. Every day, we help clients engage with new technology paradigms, creatively building solutions that solve their most pressing business challenges and move them to the forefront of their industry.