Snowflake with ETL Professional

1. Strong Snowflake
2. Strong SQL
3. strong understanding of data warehousing fundamentals and functional requirements

• 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

Key Qualifications:

• For consideration, you must bring the following minimum skills and behaviors to our team:
• 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.

In addition, preferable skills and behaviors include:

• Basic Exposure to Denodo Virtualization platform
• Basic Exposure to R12 Oracle ERP environment
• Basic understanding of Reporting tools like OBIEE, Tableau etc.
  Education:
• BS/MS in computer science, Information Systems or a related technical field or equivalent industry expertise.