Test Engineer

Overview

NTT DATA is looking for a Test Engineer to join our team remotely in Karnataka, India. We seek exceptional, innovative, and passionate individuals who want to grow with us and be part of an inclusive, adaptable, and forward-thinking organization.

• Execute data validation queries comparing source (Yellowbricks / Informatica outputs) with target (Databricks / Snowflake / dbt outputs).
• Perform row-count checks between source and target tables.
• Conduct 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 collaborate with developers for 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 and 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 tests to verify correct application of business rules after migration.
• Perform regression testing for each migration wave to ensure previously validated data remains correct.
• Support integration testing across layers: source → Databricks / Snowflake, dbt → Snowflake → downstream reports or extracts.
• Validate downstream outputs (reports, extracts, or interfaces that consume migrated data) if in scope.
• Assist in basic performance tests for key queries and jobs (e.g., comparing runtime vs baseline).
• Monitor pipeline runs for job failures, retries, and data volume anomalies.
• Execute test cases, record results, and maintain traceability to requirements.
• Log defects with clear steps, data samples, and evidence (screenshots / SQL) in defect tracking tools (e.g., JIRA, Azure Dev Ops).
• Retest resolved defects and support regression runs.
• Maintain test case repositories, test data sets, and execution logs for audit and reuse.
• Participate in daily stand-ups and defect triage with onshore/offshore teams.

• 3–6 years of experience in Software Testing / QA, with at least 2+ years in Data Warehouse / ETL testing.
• Strong SQL skills for complex queries, validations (joins, aggregations, window functions, filters).
• Hands‑on experience testing on at least one data platform:
  Snowflake, Databricks, or other cloud DW/Big Data platforms.
• Experience with Informatica (understanding mappings/workflows and expected outputs).
• Exposure to dbt or willingness to learn dbt-based validations.
• Good understanding of data warehouse concepts: facts/dimensions, SCDs, aggregations, grain, source-to-target mapping.
• Familiarity with test management and defect tracking tools (Azure Dev Ops, JIRA, Test Rail, qTest).
• Experience with Excel or similar tools for managing validation results and reconciliation artifacts.
• Strong attention to detail and a structured approach to validation.
• Ability to analyze data discrepancies and collaborate with developers to narrow down issues.

NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. As a Global Top Employer, we have experts in more than 50 countries and offer clients access to a robust ecosystem of innovation centers and partners. NTT DATA is part of the NTT Group, which invests over $3 billion each year in R&D.

Remote or hybrid work options may be available. Employees may be required to attend in‑office meetings or events depending on business needs. NTT DATA recruiters will never ask for payment or banking information and will only use  and  email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form at

NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please . If you'd like more information on your EEO rights under the law, please . For Pay Transparency information, please .