ETL Testing

• 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

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

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

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

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

TechVedika