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 Marts
• Testing: SIT, Regression, Integration, UAT Support
• Defect Management: Jira, Azure DevOps or similar
• Methodologies: Agile, Scrum, SDLC, STLC

Nice to Have

• Experience with Snowflake, Databricks, Redshift, BigQuery, or Azure Synapse.
• Experience with cloud ETL tools such as Azure Data Factory, AWS Glue, or Databricks.
• Knowledge of Python for data validation and test automation.
• Experience automating ETL and database testing.
• Knowledge of data warehouse concepts, dimensional modeling, SCD, and CDC.
• Experience validating batch and real-time/streaming data pipelines.
• Understanding of data quality, lineage, governance, and metadata management.
• Experience working with large and complex datasets.
• Experience with CI/CD and automated data testing.
• Experience in Banking, Financial Services, Insurance, Healthcare, or other enterprise environments.
• Strong analytical, troubleshooting, communication, and problem-solving skills.

About NTT DATA

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. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.

Whenever possible, we hire locally to NTT DATA offices or client sites. This ensures we can provide timely and effective support tailored to each client’s needs. While many positions offer remote or hybrid work options, these arrangements are subject to change based on client requirements. For employees near an NTT DATA office or client site, in-office attendance may be required for meetings or events, depending on business needs. At NTT DATA, we are committed to staying flexible and meeting the evolving needs of both our clients and employees. NTT DATA recruiters will never ask for payment or banking information and will only use @nttdata.com, @nttdatafed.com and @talent.nttdataservices.com email addresses. If you are requested to provide payment or disclose banking information, please submit a contact us form, https://us.nttdata.com/en/contact-us.

NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. 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 click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.