onsite
Junior Test Engineer - NTT DATA
QA Engineer
Junior Test Engineer focused on data validation across ETL pipelines, ensuring consistency between source systems and target data warehouses using SQL, Informatica, Databricks, Snowflake, and dbt.
About the role
Key Responsibilities
- Execute data validation queries to compare source outputs (Yellowbrick, Informatica) with target outputs (Databricks, Snowflake, dbt).
- Perform row‑count checks, aggregate validations (sums, counts, averages, distinct counts, min/max), and sample/cell‑level comparisons for critical entities.
- Validate schema consistency, including data types, lengths, precision/scale, nullable fields, and constraints.
- Log discrepancies, analyze patterns, and collaborate with developers to support root‑cause analysis.
- Understand Informatica mappings and workflows, and validate dbt models across staging, core, and marts.
Requirements
- Strong SQL skills for complex query development.
- Experience with Informatica PowerCenter and basic understanding of its mappings.
- Familiarity with modern data warehouses such as Snowflake and Databricks.
- Knowledge of dbt for data transformation and modeling.
- Attention to detail and excellent analytical problem‑solving abilities.
Skills
sqldatabrickssnowflakedbt