ABAL Technologies Inc 2 часа назад

ETL QA Tester

45 – 46 $в час
  • Remote
  • Удалённо
  • Контракт
PythonAISQLETLCloudELTSnowflakeData Warehouse

Описание

Responsibilities

  • Design, develop, and execute comprehensive test plans, test cases, and source-to-target (S2T) mapping validations across staging, transformation, and target layers.
  • Validate batch and incremental data loads, Change Data Capture (CDC), Slowly Changing Dimensions (SCD), schema changes, and data reconciliation within Snowflake.
  • Validate AI/LLM-assisted data workflows, prompt outputs, unstructured data processing, and analytical functions built using Snowflake Cortex AI.
  • Write and optimize complex SQL queries (joins, CTEs, window functions, set operators) to perform data profiling, completeness checks, and anomaly detection.
  • Log, track, and triage data defects in collaboration with data engineers and business analysts within an Agile/Scrum environment.

Requirements

  • Proven hands-on experience in ETL/ELT and Data Warehouse (DWH) testing.
  • Strong working knowledge of Snowflake architecture, virtual warehouses, SnowSQL, and data loading utilities.
  • Practical experience working with or testing Snowflake Cortex AI functions and AI-driven data pipelines.
  • Advanced SQL skills with demonstrated ability to write complex validation and reconciliation scripts.
  • Solid understanding of data modeling concepts (Star/Snowflake schemas, facts, dimensions) and data lineage.

Nice to have

  • Experience with test automation frameworks (e.g., Python/Pytest, dbt tests).
  • Familiarity with cloud platforms (AWS, Azure, or Google Cloud Platform) and orchestration tools (Airflow, dbt).
  • SnowPro Core Certification