QA Engineer | Data Conversion & Reporting

Lancesoft; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Lancesoft is seeking a QA Engineer with extensive experience in Data Conversion, Data Migration, and Reporting validation to ensure data accuracy, completeness, transformation, and reconciliation during migration projects. The role includes validating data, tests for reports and dashboards, and collaborating with cross-functional teams to resolve defects.

The candidate will design test scenarios, execute SQL-based data validation, and validate BI outputs across Power BI, Tableau, and other

Qualifications

• 35 years of QA/Data Testing experience.
• Must Have: 3–5 years QA experience + Data Conversion/Migration Testing + Strong SQL + Source-to-Target Validation + Data Reconciliation + Reporting/BI Testing.
• Hands-on in Data Conversion / Data Migration Testing.
• Strong knowledge of SQL and database testing.
• Experience in source-to-target data validation and reconciliation.

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.
• 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 data and business rules.
• Log and track defects using JIRA or similar tools; perform defect retesting and regression testing.
• Prepare data validation, reconciliation, and test execution reports.
• Support UAT, production migration, and post-migration validation activities.

Skills

SQL

Data validation

Data migration

ETL testing

JIRA

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

Power BI

Tableau

Job description

About the Role

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

• 35 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

Good to Have

• Experience with ETL tools such as Informatica, Talend, SSIS, Azure Data Factory, or similar.
• Knowledge of Oracle, SQL Server, PostgreSQL, MySQL, or other relational databases.
• Exposure to API testing and JSON/XML validation.
• Experience with large-volume data validation.
• Exposure to cloud data platforms such as Azure, AWS, or Snowflake.
• Experience in Retail, eCommerce, Supply Chain, Finance, or ERP applications.
• Exposure to automation using Python, Java, Selenium, or similar tools.
• Experience working in Agile/Scrum environments.

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.

Preferred Industry Experience

Retail | eCommerce | Supply Chain | ERP | Finance | Manufacturing | Data & Analytics