Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home

Jobs

Home
>
Jobs in Bengaluru
>
Infosys
>
Snowflake Developer

Snowflake Developer

Infosys

3 - 8 years

3 - 7 Lacs

Bengaluru

Posted:1 day ago| Platform:

Apply

Skills Required

python performance tuning cloud technologies sql etl hive snowflake oracle informatica powercenter data warehousing cloud platform snowpipe plsql snowflake sql unix shell scripting spark etl tool linux shell scripting aws informatica unix snowsql

Work Mode

Work from Office

Job Type

Full Time

Job Description

Educational
Bachelor of Engineering,BCS,BBA,BCom,MCA,MSc Service Line
Data & Analytics Unit Responsibilities
"

Has good knowledge on Snowflake Architecture.

Understanding Virtual Warehouses - multi-cluster warehouse, autoscaling

Metadata and system objects - query history, grants to users, grants to roles, users

Micro-partitions

Table Clustering, Auto Reclustering

Materialized Views and benefits

Data Protection with Time Travel in Snowflake - extremely imp

Analyzing Queries Using Query Profile - extremely important (Explain plan)

Cache architecture

Virtual Warehouse(VW)

Named Stages

Direct Loading

SnowPipe, Data Sharing,Streams, JavaScript Procedures & Tasks

Strong ability to design and develop workflows in Snowflake in at least one cloud technology (preferably, AWS)

Apply Snowflake programming and ETL experience to write Snowflake SQL and maintain complex, internally developed Reporting system.

Preferable knowledge in ETL Activities like data processing from multiple source systems.

Extensive Knowledge on Query Performance tuning.

Apply knowledge of BI tools.

Manage time effectively. Accurately estimate effortfortasks and meet agreed-upon deadlines. Effectively juggle ad-hocrequests and longer-term projects.Snowflake performance specialist- Familiar withzero copy cloningand usingtime travelfeatures to clone table- Familiar in understandingSnowflake query profileand what each step does andidentifying performance bottlenecks from query profile- Understanding of when a table needs to be clustered- Choosing the right cluster keyas a part of table design to help query optimization- Working with materialized views andbenefits vs cost scenario- How Snowflake micro partitions are maintained and what are the performance implications wrt micro partitions/ pruningetc- Horizontal vs vertical scaling. When to do what.Concept of multi cluster warehouse and autoscaling- Advanced SQL knowledge including window functions, recursive queriesand ability to understand and rewritecomplex SQLs as a part of performance optimization"
Additional Responsibilities:
Domain*Data Warehousing, Business IntelligencePrecise Work LocationBhubaneswar, Bangalore, Hyderabad, Pune Technical and Professional :
Mandatory skills*SnowflakeDesired skills*Teradata/Python(Not Mandatory) Preferred
Skills:

Cloud Platform-Snowflake Technology-OpenSystem-Python - OpenSystem

More Jobs at Infosys

Automation Test Engineer_Java with Selenium

Chennai, Bengaluru, Hyderabad

3 - 8 yrs

INR 5 - 13 Lacs

Api Tester

Chennai, Pune, Bengaluru

6 - 8 yrs

INR 0 - 1 Lacs

Azure Developer- Bengaluru

Chennai, Bengaluru, Hyderabad

2 - 7 yrs

INR 5 - 15 Lacs

Python Developer-Bengaluru

Chennai, Bengaluru, Hyderabad

2 - 5 yrs

INR 4 - 8 Lacs

Scala Developer

Chennai, Bengaluru, Hyderabad

5 - 10 yrs

INR 6 - 14 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Infosys

IT Services and IT Consulting

Bangalore Karnataka

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Snowflake Developer