Job Description
Req ID: 348697
We are currently seeking a Junior Test Engineer to join our team in Remote, Karnātaka (IN-KA), India (IN).
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 note...