Senior QA Engineer - ETL & BI Testing

RandomTrees; Chennai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

RandomTrees in Chennai, India is seeking a QA Engineer with deep expertise in ETL and BI testing to validate data migrations and conversions involving Oracle, Snowflake, Informatica, and dbt. You will focus on data reconciliation, transformation validation, data quality, and BI report accuracy to ensure data integrity across environments.

You will develop and execute test strategies for data reconciliation, lineage, and transformation validation.

Qualifications

• 5-9 years of experience in QA, ETL testing, data validation, or BI testing.
• Strong SQL skills and hands-on experience testing Snowflake databases.
• Good understanding of dbt models, tests, snapshots, and data quality frameworks.
• Experience validating data transformations, reconciliation, and incremental loads.
• Familiarity with AWS S3 for handling test datasets.
• Strong analytical, troubleshooting, and problem-solving skills.

Responsibilities

• Validate dbt models, tests, and snapshots to ensure data accuracy and consistency.
• Test Slowly Changing Dimension (SCD) logic, incremental data loads, and ETL workflows.
• Perform BI report validation, including metrics, calculations, and data accuracy checks.
• Execute regression and smoke testing across multiple pods and environments.
• Identify, document, and track data discrepancies and defects, and collaborate with technical teams to resolve issues.
• Use AWS S3 to manage and validate test datasets.
• Support data migration and conversion testing, ensuring completeness and consistency between source and target systems.

Skills

SQL

Analytical skills

Troubleshooting

BI testing

Tools

Snowflake

dbt

Informatica

AWS S3

Oracle

Job description

About The Role

We are looking for a QA Engineer with strong expertise in ETL and BI testing to validate data migrations and conversions involving Oracle, Snowflake, Informatica, and dbt. The role focuses on data reconciliation, transformation validation, data quality, and BI report accuracy to ensure data integrity across Develop and execute test strategies for data reconciliation, data lineage, and transformation validation.

• Validate dbt models, tests, and snapshots to ensure data accuracy and consistency.
• Test Slowly Changing Dimension (SCD) logic, incremental data loads, and ETL workflows.
• Perform BI report validation, including metrics, calculations, and data accuracy checks.
• Execute regression and smoke testing across multiple pods and environments.
• Identify, document, and track data discrepancies and defects, and collaborate with technical teams to resolve issues.
• Use AWS S3 to manage and validate test datasets.
• Support data migration and conversion testing, ensuring completeness and consistency between source and target systems.

About The Role

We are looking for a QA Engineer with strong expertise in ETL and BI testing to validate data migrations and conversions involving Oracle, Snowflake, Informatica, and dbt. The role focuses on data reconciliation, transformation validation, data quality, and BI report accuracy to ensure data integrity across Develop and execute test strategies for data reconciliation, data lineage, and transformation validation.

• Validate dbt models, tests, and snapshots to ensure data accuracy and consistency.
• Test Slowly Changing Dimension (SCD) logic, incremental data loads, and ETL workflows.
• Perform BI report validation, including metrics, calculations, and data accuracy checks.
• Execute regression and smoke testing across multiple pods and environments.
• Identify, document, and track data discrepancies and defects, and collaborate with technical teams to resolve issues.
• Use AWS S3 to manage and validate test datasets.
• Support data migration and conversion testing, ensuring completeness and consistency between source and target systems.

Requirements

• 5 - 9 years of experience in QA, ETL testing, data validation, or BI testing.
• Strong SQL skills and hands-on experience testing Snowflake databases.
• Good understanding of dbt models, tests, snapshots, and data quality frameworks.
• Experience validating data transformations, reconciliation, and incremental loads.
• Familiarity with AWS S3 for handling test datasets.
• Strong analytical, troubleshooting, and problem-solving skills.

Good To Have

• Experience in large-scale data migration and conversion testing.
• Exposure to Oracle, Informatica, and BI reporting tools.

(ref:hirist.tech)