Technology Consultant - Database QA / ETL Test Engineer

Req ID: 391387

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a Technology Consultant - Database QA / ETL Test Engineer to join our team in Pune, Mahārāshtra (IN-MH), India (IN).

Job Title: Technology Consultant – Database QA / ETL Test Engineer

Role Summary

We are seeking an experienced Database QA / ETL Test Engineer with strong hands-on expertise in database testing, ETL validation, SQL, data reconciliation, and data quality testing. The ideal candidate should have experience validating complex data pipelines, source-to-target transformations, and enterprise data warehouse solutions.

The role will collaborate with Data Engineers, ETL Developers, Business Analysts, and application teams to ensure the accuracy, completeness, integrity, and reliability of data across enterprise systems.

Day to Day Job Duties

• Perform end-to-end Database and ETL testing across source and target systems.
• Validate ETL/ELT pipelines, transformation logic, mappings, and business rules.
• Develop complex SQL queries for data validation, reconciliation, and defect investigation.
• Perform source-to-target data validation to ensure accuracy, completeness, and consistency.
• Validate large-volume data loads, batch processes, and scheduled ETL jobs.
• Perform database testing including tables, views, stored procedures, functions, and data integrity.
• Validate data transformation rules, aggregations, calculations, and business logic.
• Perform data quality testing, including completeness, uniqueness, accuracy, referential integrity, and consistency checks.
• Develop and execute test plans, test cases, test scripts, and regression suites.
• Identify data discrepancies, perform root cause analysis, and work with Data Engineers/ETL Developers to resolve defects.
• Perform backend validation for reports and downstream applications.
• Track and manage defects using Jira or similar tools.
• Support SIT, regression testing, UAT, and production validation.
• Prepare test execution reports, defect reports, traceability matrices, and quality metrics.
• Participate in Agile ceremonies, requirement reviews, and release activities.

Basic Qualifications

• 5+ years of experience in Database QA, ETL Testing, and Data Validation.
• 5+ years of hands-on experience with SQL, complex queries, database testing, and data reconciliation.
• 4+ years of experience testing ETL/ELT pipelines, source-to-target mappings, and data transformations.
• 3+ years of experience with data warehouse testing, data quality validation, and large-volume data processing.

Core Technical Skills

• Database Testing: SQL, Stored Procedures, Views, Functions, Data Validation
• Databases: Oracle, SQL Server, PostgreSQL, MySQL or similar
• ETL Testing: Source-to-Target Validation, Transformation Testing, Reconciliation
• ETL Tools: Informatica, DataStage, Talend, SSIS or similar
• Data Warehouse: Dimensional Models, Fact/Dimension Tables, Data Mart