Logo of Huzzle

Snowflake with ETL, Pentaho (MT46T RM 2917)

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

AI generated summary

  • You need 4-6 years in ETL, strong Snowflake, SQL skills, 2 years in Pentaho, data warehousing knowledge, data extraction experience, and exposure to BI tools. BS/MS in a relevant field preferred.
  • You will develop and test ETL solutions, extract and integrate data from various sources, collaborate with QA, and learn new technologies while maintaining a strong user focus.

Requirements

  • Strong Snowflake
  • Strong SQL
  • strong understanding of data warehousing fundamentals and functional requirements
  • Over all 4 to 6 years of strong hands on experience in ETL development
  • Should have at least 2 year of experience with Pentaho Data Integration and Snowflake Database.
  • Extensive expertise on Databases, data acquisition, ETL strategies and tools and technologies using Pentaho DI
  • Should have experience of extracting data through various file formats like XML files, Json and Flat file sources etc
  • Strong programming skills, relational database skills with expertise in Advanced Sql and PL/Sql, Oracle 10 & 11g, MySQL DBs etc.
  • Strong hands on experience in tuning the Sal queries/ETL mappings.
  • Exposure to Standard support ticket management tools.
  • Mastery in Business Intelligence and Data warehousing concepts and methodologies.
  • Extensive experience in data analysis and root cause analysis and proven problem solving and analytical thinking capabilities.
  • Understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control and Office software.
  • Experience with scripting language like Python, Shell, JavaScript, HTML5 is a plus.
  • Broad understanding of multiple existing and next generation Business intelligence tools and technologies.
  • Should have at least 2 year of experience with Pentaho Data Integration and Snowflake Database.
  • Basic Exposure to Denodo Virtualization platform
  • Basic Exposure to R12 Oracle ERP environment
  • Basic understanding of Reporting tools like OBIEE, Tableau etc.
  • BS/MS in computer science, Information Systems or a related technical field or equivalent industry expertise.

Responsibilities

  • Develop, document, and test ETL solutions using industry standard tools.
  • Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient ETL processes.
  • Collaborate with Quality Assurance resources to debug ETL development and ensure the timely delivery of products.
  • Should be willing to explore and learn new technologies and concepts to provide the right kind of solution.
  • Target and result oriented with strong end user focus
  • Effective oral and written communication skills
  • Highly motivated, a Go-Getter who needs no supervision

FAQs

What is the job title for this position?

The job title is Snowflake with ETL, Pentaho (MT46T RM 2917).

What are the key technologies required for this role?

The key technologies required are Snowflake, ETL, Pentaho, SQL, and data warehousing.

What is the minimum years of experience required for this position?

A minimum of 4 to 6 years of strong hands-on experience in ETL development is required.

Is experience with Pentaho Data Integration mandatory?

Yes, at least 2 years of experience with Pentaho Data Integration and Snowflake Database is mandatory.

What are the main responsibilities of this role?

Responsibilities include developing and testing ETL solutions, extracting and integrating data from various sources, collaborating with Quality Assurance, and participating in data analysis and data modeling.

What types of data formats should the candidate be familiar with?

The candidate should have experience extracting data from various formats such as XML, JSON, and flat files.

Are there any specific programming skills required?

Yes, strong programming skills in SQL and PL/SQL, as well as expertise in databases like Oracle and MySQL, are required.

Is there any preference for additional skills?

Yes, basic exposure to Denodo Virtualization platform, R12 Oracle ERP environment, and reporting tools like OBIEE and Tableau are preferable.

What type of educational background is needed for this job?

A BS/MS in computer science, Information Systems, or a related technical field is required, or equivalent industry expertise.

Where is this job located?

This job is located in Chennai.

What is the notice period required for this job?

The notice period required is 0-30 days.

Is there any flexibility regarding remote work?

Yes, remote work is supported but in a hybrid format.

Do we provide Medicare support for employees?

Yes, we provide Medicare support.

People | Proces | Technology

Consulting
Industry
11-50
Employees
2017
Founded Year

Mission & Purpose

Source Right is a company that provides strategic sourcing and recruitment services, specialising in connecting businesses with top talent and optimal sourcing solutions. Their ultimate mission is to streamline and enhance the recruitment process for their clients by leveraging their expertise and innovative methodologies to secure high-quality candidates efficiently. The purpose of Source Right is to deliver customised recruitment and talent acquisition solutions that align with their clients' specific needs, improving organisational effectiveness and supporting long-term business success.