Source description
About the role
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 ( ) Thanks and Regards, OM HR TA NTT Data. .
More at NTT DATA