Snowflake + SQL

9 hours ago


Bengaluru, India Black & White Business Solutions Full time

**Job Information**:
Industry

**IT Services**
***

Province

**Karnataka**
***

City

**Bangalore North**
***

Postal Code

**560001**
***

Country

**India**

We have opening for Snowflake + SQL with one of our client. Pls find the details below.

Should have 10-14 years of experience in Snowflake (Cloud Data Warehousing) & ELT DBT ( Data Build Tool) and (Informatica) Development and Design & Development experience:
Primary Technical skills:

- Snowflake (Cloud Data Warehouse):

- Good understanding of Snowflake ECO system
- Good experience on Data modeling and Dimensional Modeling and techniques and will be able to drive the Technical discussions with IT & Business and Architects / Data Modelers
- Need to guide the team and provide the technical solutions
- Need to prepare the technical solution and architectures as part of project requirements
- Virtual Warehouse (Compute) - Good Understanding of Warehouse creation & manage
- Data Modeling & Storage - Strong knowledge on LDM/PDM design
- Data Loading/Unloading and Data Sharing
- Should have good knowledge
- SnowSQL (CLI)
- Expertise and excellent understanding of Snowflake Internals and Integration
- Strong hands on experience on SNOWSQL queries and Stored procedures and performance tuning techniques
- Good knowledge on SNOWSQL Scripts preparation the data validation and Audits
- SnowPipe - Good knowledge of Snow pipe implementation
- Expertise and excellent understanding of S3 - Internal data copy/movement
- Good knowledge on Security & Readers and Consumers accounts
- Good knowledge and hands on experience on Query performance tuning implementation techniques
- DBT ( Data Build Tool) hands on experience with all modules:

- In depth hands on experience in DBT CLI and DBT Cloud and GitHub version control and code repository knowledge.
- Design and develop DBT models and build the data pipeline processes to perform complex ELT processes as per DBT scripting.
- Good knowledge and hands on experience on dbt concepts such as Models, Materialization, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, Analyses, write complex SQL queries
- Informatica
- 10.x and above with all modules:

- ETL- Design & Development and Troubleshooting/debugging experience
- Repository Manager
- SQL Knowledge:

- Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions
- Strong knowledge on stored procedures
- Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse
- Ability to participate in RFI/RFPs discussions and provide technical solutions and effort estimations
- Excellent presentation and communication skills, both written and verbal
- Ability to problem solve and architect in an environment with unclear requirements

**Nice to have skills**:

- Cisco Process and Data understanding like IB Data, Service contract Management, Auto Renewals, Services Domain, Booking, Quotes, Digital Case Services, Quote to Cash, Invoicing, Licensing, and Provisioning, Sales Compensation, Software and Recurring Revenue etc.
- Snow Pro-Core - Certification - Snowflake
- Experience/Knowledge with reporting technologies (i.e. Tableau, Power BI) is an added advantage.
- Good to have Hi-Tech Manufacturing domain experience.

Experience 8 to 12 Years

Budget 26 LPA

NP 0 to 15 Days


  • SQL DBA + Snowflake

    2 days ago


    Bengaluru, Karnataka, India Vimerse Infotech Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Vimerse Infotech IncCompany Overview:Vimerse Infotech Inc is a leading information technology and services company with a focus on delivering innovative solutions to clients globally.Role and Responsibilities:Looking for a senior-level SQL DBA with experience in Snowflake to join our team. The successful candidate will be responsible for working...

  • Solutions Architect

    2 weeks ago


    Bengaluru, India Snowflake Full time

    Where Data Does More. Join the Snowflake team. We are looking for a Solutions Architect to be part of our Professional Services team to deploy cloud products and services for our customers' Global Competency Centers located in India. This person must be a hands-on, self-starter who loves solving innovative problems in a fast-paced, agile environment. The...

  • Snowflake Developer

    2 weeks ago


    Bengaluru, India Zyoin Group Full time

    Description : Job Title : - Snowflake DeveloperExperience : - 6 to 9 yearsNotice period : - Immediate to 30 daysMail to mention : - Responsibilities : - Develop and maintain scalable data pipelines and ETL/ELT processes using Snowflake SQL and related tools.- Design and implement data warehouse models (Star, Snowflake schemas) to support analytics and...


  • Bengaluru, Karnataka, India Tata Consultancy Services (TCS) Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Location : BangaloreExperience: 8+ yearsMust have :Snowflake, Advanced SQL, ETL - Matillion, Data Warehouse, AWS Step Functions , GlueRoles:Design, build, and maintain robust ETL pipelines using AWS data technologies and Snowflake to support data warehousing and analytics.Develop and optimize complex SQL queries for data transformation, cleansing, and...

  • Solutions Architect

    1 week ago


    Bengaluru, Karnataka, India Snowflake Full time

    Build the future of the AI Data Cloud. Join the Snowflake team. The person we’re looking for shares our passion about reinventing the data platform and thrives in the dynamic environment. That means having the flexibility and willingness to jump in and get done what needs to be done to make Snowflake and our customers successful. It means keeping up to...

  • Solutions Architect

    2 weeks ago


    Bengaluru, India Snowflake Full time

    Job Description Snowflake is about empowering enterprises to achieve their full potential u2014 and people too. With a culture that's all in on impact, innovation, and collaboration, Snowflake is the sweet spot for building big, moving fast, and taking technology u2014 and careers u2014 to the next level. We are looking for a Solutions Architect to be part...


  • Bengaluru, India Snowflake Full time

    Snowflake is about empowering enterprises to achieve their full potential — and people too. With a culture that’s all in on impact, innovation, and collaboration, Snowflake is the sweet spot for building big, moving fast, and taking technology — and careers — to the next level. Our customers are very happy with our technology and are quickly...


  • Bengaluru, India Snowflake Full time

    Snowflake is about empowering enterprises to achieve their full potential — and people too. With a culture that’s all in on impact, innovation, and collaboration, Snowflake is the sweet spot for building big, moving fast, and taking technology — and careers — to the next level. Our customers are very happy with our technology and are quickly...


  • Bengaluru, India Snowflake Full time

    Snowflake is about empowering enterprises to achieve their full potential — and people too. With a culture that’s all in on impact, innovation, and collaboration, Snowflake is the sweet spot for building big, moving fast, and taking technology — and careers — to the next level. Snowflake Support is committed to providing high-quality resolutions to...


  • Bengaluru, India Snowflake Full time

    Job Description Snowflake is about empowering enterprises to achieve their full potential u2014 and people too. With a culture that's all in on impact, innovation, and collaboration, Snowflake is the sweet spot for building big, moving fast, and taking technology u2014 and careers u2014 to the next level. Our customers are very happy with our technology and...