QA Engineer | Data Conversion & Reporting

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

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