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