Lead Data Quality Automation Engineer

Data Quality Engineering, SQL, DB/ETL Test Automation, DWH & DB Concepts

Bangalore, Chennai, Hyderabad, Pune, Gurgaon

We are seeking a skilled Lead Data Quality Automation Engineer to maintain the precision and dependability of our data systems.

In this capacity, you will contribute to the creation of test scripts, the improvement of automated testing frameworks, and the collaboration with development teams. Your deep knowledge of data models, ETL architecture, and automation testing will enhance the quality and integrity of our data-centric solutions.

Responsibilities

Define quality standards and metrics for the current project/product
Collaborate with stakeholders to review, finalize, and agree upon quality metrics
Establish a list of milestones and checkpoints with measurable criteria to assess quality regularly
Develop processes for test plan creation and testing cycle phases
Plan and schedule milestones and tasks such as alpha and beta testing
Ensure all development tasks adhere to quality criteria through test planning, execution, assurance, and issue tracking
Focus on automation in addition to manual testing
Continuously innovate and elevate the standards of quality processes
Review and ensure coverage of various testing types like unit, functional, performance, stress, and acceptance
Identify areas to calculate project risk and create strategies to mitigate and control risks
Communicate risks to all stakeholders and review and escalate current risks
Advocate for automation in daily tasks and assist others in adopting automation
Set milestones for yearly improvement projects
Collaborate with the development team to support quality engineers with necessary tools like automation hooks or debug builds

Requirements

8 to 12 years of robust experience in QA/testing or application development
Proficiency in Database and ETL testing
Expertise in preparing test plans and conducting peer reviews
Strong command of essential technologies, including SQL scripting and PL/SQL
Capability to write complex and automated SQL scripts
Skills in ETL testing from various server feeds (S3, SQL, HIVE, Data Bricks, Snow Flake) using diverse testing strategies
Understanding of Hadoop & Big Data concepts and data validation on HIVE tables
Familiarity with large-scale data processing languages like pyspark is advantageous
Strong command of a programmatic language (Python/Java preferred)
Knowledge of API testing
Proficiency with software development lifecycle (SDLC) methodologies like Agile, QA methodologies, defect management systems, and documentation
Experience in automation, automation frameworks, and automation delivery is preferred
Competency in setting quality standards for new testing technologies in the industry
Skill in identifying and defining areas to calculate overall project risk and creating strategies to mitigate those risks
Excellent analytical and communication skills required

Technologies

Python/Java/Any Scripting
Azure/AWS