Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

Ankura

Compare

4.5

based on 9 Reviews

8 Ankura Jobs

Senior Associate, QA Engineer - Data Warehousing

Ankura

4.5

based on 9 Reviews

7-10 years

Remote

1 vacancy

Senior Associate, QA Engineer - Data Warehousing

Ankura

posted 4d ago

Job Role Insights

Key skills for the job

Data Analysis Data Analytics Python SQL Healthcare Performance Testing

+ 3 more

Job Description

We are seeking a highly skilled and experienced QA Engineer specializing in data warehousing projects to ensure the quality and reliability of our data solutions. The ideal candidate will have a deep understanding of ETL and ELT processes, big data technologies, and data modeling concepts. This role requires strong SQL and Python skills, experience with data testing tools, and the ability to translate complex data transformation rules into effective test cases.

Responsibilities:

Develop and execute comprehensive test plans and test cases for data warehousing projects, covering ETL/ELT processes, data transformations, and data quality.
Perform various types of testing, including functional testing, integration testing, performance testing, and regression testing.1
Utilize data testing tools like QuerySurge and ICEDQ to automate data validation and reconciliation.
Write complex SQL queries to extract, transform, and compare data for testing purposes.
Develop Python scripts for data generation, test automation, and data analysis.
Analyze data transformation rules and data models (e.g., dimensional, star schema) to understand data flow and identify potential issues.
Create sample data for testing purposes, ensuring data accuracy and representativeness.
Collaborate with data engineers and developers to identify and resolve data quality issues.
Document test results and provide detailed reports on data quality and testing progress.
Participate in code reviews and ensure adherence to QA best practices.
Contribute to the improvement of data quality processes and testing methodologies.
Stay up-to-date with the latest data warehousing and QA trends and technologies.
[Optional: Include specific domain experience, e.g., Experience with financial data warehousing, healthcare data warehousing, etc.]

Required Skills:

7-10 years of experience in QA testing, with a focus on data warehousing projects.
Thorough understanding of ETL and ELT concepts and processes.
Strong proficiency in SQL, including complex queries for data manipulation and validation.
Proficiency in Python scripting for test automation and data analysis.
Hands-on experience with data testing tools like QuerySurge and ICEDQ.
Deep understanding of data warehousing concepts, including data modeling (dimensional, star schema), data integration, and data quality.
Ability to read and interpret data transformation rules and specifications.
Experience in creating sample data for testing purposes.
Excellent analytical and problem-solving skills.
Strong communication and collaboration skills.
Ability to work independently and as part of a team.2