Dear Aspirants,
Greetings from NTT Data!!!!
Excelllent opening for ETL Lead Test Engineer.
Salary : upto 22 LPA.
Work : Hybrid - ( Chennai / Bangalore / Hyderabad )
JD for Reference:
- Execute data validation queries to compare:
- Source (Yellowbricks / Informatica outputs) vs Target (Databricks / Snowflake / dbt outputs).
- 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: recent, changed, and deleted records are handled correctly.
- Execute functional tests to verify correct application of business rules after migration.
- Perform regression testing for each migration wave to ensure that previously validated data and flows remain correct.
- Support integration testing across layers:
- Source Databricks / Snowflake
- dbt Snowflake downstream reports or extracts
Interested candidate share your updated resume to (
[email protected] )
Thanks and Regards,
OM
HR TA
NTT Data.
📌 ETL Lead Test Engineer (Hyderabad)
🏢 NTT DATA
📍 Hyderabad