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.
- Solid 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

The candidate should be able to validate:
- Report data accuracy
- Calculated fields and measures
- Aggregations and totals
- Filters and parameters
- Drill-down/drill-through functionality
- Data refresh
- Report-to-database reconciliation
- Export functionality such as Excel/CSV/PDF

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

Top of Form

Bottom of Form

📌 QA Engineer_Data Conversion & Reporting_ (Bengaluru)
🏢 LanceSoft
📍 Bengaluru