ETL Testing

The QA Tester will ensure accuracy and reliability of data products and data marts in Azure SQL and Azure Databricks. Responsibilities include developing test plans, executing functional, regression, and integration testing, validating SQL-based transformations, and comparing source and final data for accuracy. The role involves logging bugs, collaborating with engineers, maintaining regression tests, and documenting results. A strong understanding of QA methodologies, SQL, and Azure data platforms is essential for this collaborative role.

Must Have

• Review technical specifications and data model designs to develop comprehensive test plans and test cases
• Execute functional, regression, and integration testing for new data products, transformation logic, and platform enhancements
• Validate SQL-based transformations and logic implemented in Azure SQL and Databricks
• Write SQL queries to validate data transformations, joins, filters, aggregations, and calculations across staging, transformation, and reporting layers
• Compare results between source systems and final data products for accuracy and completeness
• Ensure data reconciliation and integrity across pipelines and versions
• Log, document, and track bugs or data anomalies
• Collaborate with data engineers and developers to troubleshoot and verify resolution of issues
• Proactively raise risks and blockers during test cycles to ensure timely delivery
• Maintain regression test cases as data products evolve
• Identify repetitive test cases suitable for automation and assist in building out test scripts as needed
• Ensure previous features and deliverables continue to work after new releases
• Document test plans, cases, and results clearly for audit and traceability
• Participate in Agile/Scrum ceremonies and provide QA status updates
• Collaborate with cross-functional teams to ensure product quality at each development stage
• Strong SQL skills, with the ability to write complex queries for data validation and reconciliation
• Understanding of relational database design, ETL processes, and data modeling concepts
• Experience testing data products or platforms built on Azure SQL and/or Databricks
• Familiarity with testing concepts such as QA, UAT, regression, exploratory, and post-production deployment testing
• Ability to work with datasets of varying complexity, volume, and sensitivity
• High attention to detail and ability to detect inconsistencies or inaccuracies in data
• Strong written and verbal communication skills for documenting and explaining findings
• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or a related field
• 4+ years of experience in a QA role focused on data platforms or data-centric applications

Good to Have

• Prior experience in data platform testing, preferably in financial services or enterprise environments
• Familiarity with Azure Data Factory or other Azure-native data tools
• Knowledge of scripting for automation or test frameworks
• Experience with Agile methodologies and tools

Perks & Benefits

• Health Insurance
• Meal Vouchers
• Learning Aids
• Client/Customer Interactions
• Working with great minds

Company Description

We are an Artificial Intelligence (AI) focused product engineering company, providing our customers in healthcare, retail & e-commerce, manufacturing, and hospitality sectors with cutting-edge products & solutions, harnessing Big Data Analytics, Vision Analytics, and IoT.

Ever since our inception in March 2010, Tech Vedika has been

• Great Place To Work Certified™(May 2022-May 2023) Organization
• Top 50 I Mid-Size India’s Best Workplaces for Women 2022 !
• Top 10 Most Disruptive Face & Image Recognition Solution Providers’2020 – Analytics Insights
• Top 10 Healthcare Analytics Solution Providers’ 2019\- Healthcare Outlook Magazine
• Top 20 most amazing AWS Service Providers – CIO Review India 2018

We strive for simple, elegant tech solutions to perform complex tasks. As a scalable technology partner, we enable organizations to improve operational efficiency and unleash new business potential.

Job Description

Position Summary:

The QA Tester will play a critical role in ensuring the accuracy, integrity, and reliability of data products and data marts built by the engineering team within Azure SQL and Azure Databricks environments. This individual will be responsible for validating new features, identifying defects, and ensuring system stability through rigorous testing practices including regression, functional, integration, and data validation testing.

The ideal candidate brings a strong understanding of QA methodologies and a working knowledge of SQL and modern data platforms, particularly within the Azure ecosystem. This position requires close collaboration with data engineers, business analysts, and product stakeholders.

Key Responsibilities:

Test Planning and Execution

• Review technical specifications and data model designs to develop comprehensive test plans and test cases.
• Execute functional, regression, and integration testing for new data products, transformation logic, and platform enhancements.
• Validate SQL-based transformations and logic implemented in Azure SQL and Databricks.

Data Validation

• Write SQL queries to validate data transformations, joins, filters, aggregations, and calculations across staging, transformation, and reporting layers.
• Compare results between source systems and final data products for accuracy and completeness.
• Ensure data reconciliation and integrity across pipelines and versions.

Issue Tracking and Communication

• Log, document, and track bugs or data anomalies.
• Collaborate with data engineers and developers to troubleshoot and verify resolution of issues.
• Proactively raise risks and blockers during test cycles to ensure timely delivery.

Regression & Automation Support

• Maintain regression test cases as data products evolve.
• Identify repetitive test cases suitable for automation and assist in building out test scripts as needed.
• Ensure previous features and deliverables continue to work after new releases.

Documentation & Collaboration

• Document test plans, cases, and results clearly for audit and traceability.
• Participate in Agile/Scrum ceremonies and provide QA status updates.
• Collaborate with cross-functional teams to ensure product quality at each development stage.

Required Skills and Experience

• Strong SQL skills, with the ability to write complex queries for data validation and reconciliation.
• Understanding of relational database design, ETL processes, and data modeling concepts.
• Experience testing data products or platforms built on Azure SQL and/or Databricks.
• Familiarity with testing concepts such as QA, UAT, regression, exploratory, and post-production deployment testing.
• Ability to work with datasets of varying complexity, volume, and sensitivity.
• High attention to detail and ability to detect inconsistencies or inaccuracies in data.
• Strong written and verbal communication skills for documenting and explaining findings.

Qualifications

Preferred Qualifications

• Prior experience in data platform testing, preferably in financial services or enterprise environments.
• Familiarity with Azure Data Factory or other Azure-native data tools.
• Knowledge of scripting for automation or test frameworks.
• Experience with Agile methodologies and tools.

Education & Experience

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or a related field.
• 4+ years of experience in a QA role focused on data platforms or data-centric applications.

Additional Information

At Tech Vedika, we are looking for talented individuals who want to work with driven people. Attain success while working on interesting projects with a culturally diverse group of individuals.

Perks & Benefits:

• Health Insurance
• Meal Vouchers
• Learning Aids
• Client/Customer Interactions
• Working with great minds

If you want an exciting and dynamic career with unlimited growth potential, then Tech Vedika is the place for you!