QA

Lancesoft; Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Lancesoft in Bengaluru, Karnataka, is seeking a QA Engineer with data migration and reporting validation expertise. You will validate data accuracy, completeness, transformation, and reconciliation during migration projects and test BI reports and dashboards.

The role focuses on ETL testing, SQL-based validation, and ensuring data integrity across source and target systems, collaborating with data engineers and business analysts.

Qualifications

• 3–5 years of experience in QA/Data Testing.
• 3–5 years QA experience + Data Conversion/Migration Testing + Strong SQL + Source-to-Target Validation + Data Reconciliation + Reporting/BI Testing.
• Hands-on experience in Data Conversion / Data Migration Testing.
• Strong knowledge of SQL and database testing.
• Experience in source-to-target data validation and reconciliation.
• Good understanding of ETL concepts and data transformation.
• Experience testing reports, dashboards, and data extracts.
• Strong understanding of: Data mapping, Data transformation, Data validation, Data reconciliation, Data quality, Data integrity.
• Experience with JIRA or similar defect-management tools.
• Good understanding of STLC, SDLC, test case design, and defect lifecycle.

Responsibilities

• Perform functional, data validation, data conversion, migration, integration, and regression testing.
• Analyze source and target data structures and understand data mapping and transformation rules.
• Create detailed test scenarios, test cases, test data, and validation checklists.
• Validate data migration/conversion from source systems to target systems.
• Source-to-target data validation, data completeness and accuracy checks, data transformation validation, data reconciliation, and duplicate/missing-data validation.
• Execute ETL/data migration testing and validate transformation logic.
• Write and execute SQL queries for data validation and reconciliation.
• Validate reports, dashboards, and BI outputs against source/transactional data.
• Test report calculations, filters, sorting, aggregations, totals, and business rules.
• Validate scheduled reports and data refresh processes.
• Identify discrepancies between source data, converted data, and reports.
• Log and track defects using JIRA or similar tools.
• Perform defect retesting and regression testing after fixes.
• Participate in defect triage with developers, data engineers, business analysts, and reporting teams.
• Prepare data validation, reconciliation, and test execution reports.
• Support UAT, production migration, and post-migration validation activities.

Skills

QA/Data Testing

Data Conversion

Data Migration Testing

SQL

Source-to-Target Validation

Data Reconciliation

Reporting/BI Testing

ETL Concepts

JIRA

Tools

Power BI

Tableau

Looker

SAP BusinessObjects

SSRS

Qlik

Job description

Role & responsibilities

We are looking for a QA Engineer with 35 years of experience in Data Conversion, Data Migration, and Reporting validation. The candidate will be responsible for validating data accuracy, completeness, transformation, and reconciliation during data migration/conversion projects, along with testing business reports and dashboards.

Key Responsibilities

• Perform functional, data validation, data conversion, migration, integration, and regression testing.
• Analyze source and target data structures and understand data mapping and transformation rules.
• Create detailed test scenarios, test cases, test data, and validation checklists.
• Validate data migration/conversion from source systems to target systems.
• Perform:
• Source-to-target data validation
• Data completeness and accuracy checks
• Data transformation validation
• Data reconciliation
• Duplicate and missing-data validation
• Data type and format validation
• Record count validation
• Execute ETL/data migration testing and validate transformation logic.
• Write and execute SQL queries for data validation and reconciliation.
• Validate reports, dashboards, and business intelligence outputs against source/transactional data.
• Test report calculations, filters, sorting, aggregations, totals, and business rules.
• Validate scheduled reports and data refresh processes.
• Identify discrepancies between source data, converted data, and reports.
• Log and track defects using JIRA or similar tools.
• Perform defect retesting and regression testing after fixes.
• Participate in defect triage with developers, data engineers, business analysts, and reporting teams.
• Prepare data validation, reconciliation, and test execution reports.
• Support UAT, production migration, and post-migration validation activities.

Required Skills

• 3–5 years of experience in QA/Data Testing.
• Must Have: 3–5 years QA experience + Data Conversion/Migration Testing + Strong SQL + Source-to-Target Validation + Data Reconciliation + Reporting/BI Testing.
• Hands-on experience in Data Conversion / Data Migration Testing.
• Strong knowledge of SQL and database testing.
• Experience in source-to-target data validation and reconciliation.
• Good understanding of ETL concepts and data transformation.
• Experience testing reports, dashboards, and data extracts.
• Strong understanding of:
• Data mapping
• Data transformation
• Data validation
• Data reconciliation
• Data quality
• Data integrity
• Experience with JIRA or similar defect-management tools.
• Good understanding of STLC, SDLC, test case design, and defect lifecycle.

Reporting & BI Testing

Experience with one or more reporting/BI tools is preferred:

• Power BI
• Tableau
• Looker
• SAP BusinessObjects
• SSRS
• Qlik
• Other enterprise reporting platforms