Senior QA Test Engineer - Data migration and integration - Chennai - Contractor in USD

All European Careers; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

A recruitment agency is seeking a Senior QA Test Engineer for an international project in Chennai. The ideal candidate will have over 8 years of experience in testing roles, strong SQL skills, and a deep understanding of ETL processes. Responsibilities include collaborating with teams to define testing strategies, executing test plans, and validating data migrations. This long-term position requires fluency in English and advanced proficiency in various QA tools.

Qualifications

• 8+ years’ experience in a development/testing role.
• Strong understanding of ETL processes, data models, and API integrations.
• Experienced in large data and reporting applications.

Responsibilities

• Collaborate with teams to understand migration/integration requirements.
• Create comprehensive QA test plans and strategies.
• Execute manual and automated tests for migrations and integrations.

Skills

Strong SQL query skills

Familiarity with data profiling tools

Proficiency in QA tools

Strong troubleshooting skills

Tools

HP ALM

Jira

Azure DevOps

Selenium

Job description

For an international project in Chennai, we are urgently looking for a Senior QA Test Engineer.

We are looking for a motivated contractor. This position is long-term. Candidates need to be fluent in English.

Tasks and responsibilities:

• Collaborate with business analysts, data architects, and developers to understand migration/integration requirements and data flows;
• Define a comprehensive test strategy tailored to data migration and integration;
• Create a detailed QA test plan covering functional, non-functional, regression, and reconciliation testing;
• Identify and document test environments, test tools, data sets, and dependencies;
• Data completeness checks;
• Referential integrity checks;
• Prepare synthetic and anonymized test data where needed;
• Document expected results for each test case, including SQL validation scripts;
• Execute manual and automated tests for migration batches and integration workflows;
• Use SQL queries, ETL tool logs, API response validations, and reconciliation reports to verify requirements;
• Perform volume/stress testing for large data sets and high-frequency integrations;
• Validate incremental loads, delta migrations, and real-time sync behavior;
• Test rollback and recovery procedures for failed migrations or integrations;
• Log defects in the defect tracking tool (e.g., Jira, Azure DevOps, HP ALM) with detailed root cause evidence;
• Reconcile row counts and key business metrics pre- and post-migration;
• Perform cross-application consistency checks for integrated data;
• Verify audit trails, logging, and monitoring mechanisms;
• Validate data security, masking, and compliance requirements;
• Design and implement automated validation scripts in SQL, Python, or using QA automation tools;
• Optimize regression testing using automation frameworks;

Profile:

• +8 years’ experience in a development /testing role;
• Experienced IT professional working on large data and reporting applications as well a strong understanding of Operational data stores, Data Warehouses and/or Data Mart;
• Strong SQL query skills for complex data validation and reconciliation;
• Deep understanding of ETL processes, data models, and API integrations;
• Familiarity with data profiling, cleansing, and quality tools;
• Proficiency in QA tools (HP ALM, Jira, Azure DevOps, Selenium, etc.);
• Knowledge of data governance, data privacy regulations (GDPR, HIPAA, etc.);
• Strong troubleshooting and defect analysis skills;