Logo of Huzzle

Snowflake + SQL + Fivetran

image

Virtusa

15d ago

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

AI generated summary

  • You need strong SQL skills, Snowflake utilities experience, Fivetran connector management, problem-solving ability, and excellent communication skills. Agile familiarity and Snowflake Certification preferred.
  • You will write SQL queries, develop ETL scripts, manage Snowflake utilities, design data pipelines, configure Fivetran connectors, and collaborate within a global team.

Requirements

  • 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.
  • 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

  • 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
  • Work Effectively within a global team environment

FAQs

What technical skills are required for this position?

The role requires strong skills in Snowflake, SQL, Python, Unix scripting, and experience with Fivetran connectors for data integration.

Is a Snowflake certification necessary for this role?

While a Snowflake certification is preferred, it is not strictly required.

What programming languages are beneficial for this job?

Python and Unix scripting are beneficial for developing scripts for data extraction, loading, and transformation.

What kind of experience is needed with Snowflake?

Candidates should have hands-on experience with Snowflake utilities, including SnowSQL, SnowPipe, Tasks, Streams, and stored procedures, as well as designing and implementing data pipelines.

What is the work environment like at Virtusa?

Virtusa embodies teamwork and values a collaborative global team environment, promoting personal and professional development.

Are strong communication skills important for this position?

Yes, excellent communication and documentation skills are essential for effective collaboration and problem-solving.

How does Virtusa approach equal opportunity in hiring?

Virtusa is committed to equal opportunity for all and does not discriminate on any basis covered by law; employment decisions are based on qualifications, merit, and business need.

What type of projects can I expect to work on at Virtusa?

You can expect to work on exciting projects that utilize state-of-the-art technologies, fostering opportunities for growth and development.

Does the role involve working with Agile delivery processes?

Yes, familiarity with the Agile delivery process is an important aspect of this role.

How important is problem-solving capability for this position?

Complex problem-solving capability and a continuous improvement approach are critically important for success in this role.

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.