ETL Tester

Job Description

Should have good knowledge of Advanced SQL ( Ranking, Analytical function)

Should have good knowledge of Snowflake, Pyspark/Scala ,Snwoflake, Azure Databricks.

Should have good knowledge Data validation of Full & Incremental load

Should have good knowledge of Data warehousing Concepts

Should have good knowledge of Writing advanced sql and oracle query

Fact & dimension modeling

ETL Testing hands-on

Need to Row number and Rank Function in sql server

Fact and Dimensional concepts.

Should be knowing SQL Server functions

Good understanding of data warehouse concept.

Analytical skill to play with Data

Should be able to understand and capture the project requirements

Should be able to understand and analyze the code flow/work flow

Should be able to debug/analyze the production logs/errors.

Should be able to do the unit testing of code

Should be able to do the documentation of services.