Data Quality Analyst

Job Title:

Experience:

Location:

Job Summary:

experienced ETL Testers

Key Responsibilities:

• Develop and execute complex SQL queries for

  data validation

  ,

  data profiling

  , and

  test case automation

  .
• Perform

  ETL testing

  on large-scale datasets to ensure data integrity across systems.
• Use

  Python or Java

  to build automation scripts for data quality checks.
• Write and maintain test scripts using

  BDD frameworks

  (Selenium, Cucumber) where applicable.
• Collaborate with Data Engineers and Developers for continuous integration and deployment (

  CI/CD

  ) pipeline validations.
• Implement testing strategies for structured and unstructured data sources.
• Contribute to the identification and resolution of data quality issues and anomalies.
• Work with cross-functional teams to define test plans, data scenarios, and ensure full test coverage.
• Participate in code reviews and optimize SQL queries for performance improvements.

Required Technical Skills:

✅ Must Have:

• Advanced SQL

  – strong proficiency in:

• Window Functions

  (e.g., RANK, ROW_NUMBER, LEAD/LAG, PARTITION BY)

• CTEs (Recursive and Multiple)

• Subqueries

  (Scalar, Correlated, EXISTS/NOT EXISTS)

• Analytical Functions

  (CUME_DIST, NTILE, PERCENT_RANK)

• Full-text search

  ,

  hierarchical queries

  , and

  query optimization

• Programming Skills

  – Proficiency in

  Python

  or

  Java

• Strong

  functional testing

  background (manual + automation)
• Working knowledge of

  CI/CD pipelines

Good to Have:

• Exposure to

  Selenium

  ,

  Cucumber

  , or any

  BDD

  framework
• Experience in working with

  ETL pipelines

  ,

  data lakes

  , or

  big data systems

• Knowledge of data governance or data profiling tools (e.g., Informatica DQ, Talend, etc.)

Soft Skills & Competencies:

• Strong analytical and problem-solving skills
• Ability to communicate technical concepts clearly and effectively
• Self-driven and able to work independently as well as part of a distributed team
• Quick learner with adaptability to new technologies and frameworks

Other Details:

• Candidates should be open to working in a

  hybrid model

  with

  3 days in office

  .
• Immediate to 30-day joiners preferred.
• Flexibility to coordinate with distributed teams across locations.