Junior Data Warehouse Test Engineer

Junior Test Engineer Job Duties: Roles & Responsibilities Execute data validation queries to compare: Source (Yellowbricks / Informatica outputs) vs Target (Databricks / Snowflake / dbt outputs). Perform: Row-count checks between source and target tables. Aggregate validations (sums, counts, averages, distinct counts, min/max). Sample and cell-level comparisons for critical entities and fields. Validate schema consistency (data types, lengths, precision/scale, nullable fields, constraints). Log discrepancies, analyze patterns, and work with developers to support root-cause analysis. Understand Informatica mappings and workflows and their expected outputs. Validate dbt models (staging, core, marts) on Snowflake against legacy Informatica outputs. Test Databricks notebooks/jobs that replicate Yellowbricks logic — ensuring correct transformations, joins, filters, and aggregations. Validate CDC / incremental loads: new, changed, and deleted records are handled correctly. Execute functional...