Ankura Logo

Ankura

Senior Associate, QA Engineer - Data Warehousing

Sorry, this job was removed at 12:10 p.m. (IST) on Thursday, May 01, 2025
Be an Early Applicant
Remote
Hiring Remotely in IND
Remote
Hiring Remotely in IND

Similar Jobs

4 Hours Ago
Remote
Hybrid
5 Locations
Senior level
Senior level
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
The Senior Manager oversees transparency reporting initiatives, ensuring compliance, managing projects, and providing analytics to stakeholders across global markets.
Top Skills: AccessAribaBusiness ObjectsConcurCventExcelSAP
8 Hours Ago
Remote
Hybrid
8 Locations
Senior level
Senior level
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
The Senior Manager, Enterprise Strategy will develop winning strategies, conduct analyses, and prepare documents for executive leadership while collaborating with teams to measure business performance.
Top Skills: Data AnalyticsExcelPowerPointThink-Cell
8 Hours Ago
Remote
Hybrid
8 Locations
Senior level
Senior level
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
This role manages health and welfare plans for active and retiree populations, overseeing vendor relationships and ensuring optimal employee experience across U.S. and Canada. It requires collaboration with internal management for plan design and effective communication.

Ankura is a team of excellence founded on innovation and growth.

Practice Overview:

Ankura’s Data & Technology Practice includes client services in the areas of Analytics & Data Strategy, eDiscovery & Cyber Security.  Our Data & Technology team helps our internal and external customers design, execute and test cutting edge solutions in each of our respective areas.

Role Overview:

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

Preferred Skills (Good to Have):

  • Experience with big data technologies (e.g., Hadoop, Spark).

  • Experience with cloud data warehouses (e.g., Snowflake, Databricks, Redshift).

  • Experience with data visualization tools (e.g., Tableau, Power BI).

  • Experience with Agile development methodologies.

  • Knowledge of data governance and security best practices.

  • Experience with performance testing tools.

Education:

Engineer of any branch from tier 2 colleges or higher

or

Masters in Computer Science

#LI-Remote

#LI-JK1

*

Ankura is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability. Equal Employment Opportunity Posters, if you have a disability and believe you need a reasonable accommodation to search for a job opening, submit an online application, or participate in an interview/assessment, please email [email protected] or call toll-free +1.312-583-2122. This email and phone number are created exclusively to assist disabled job seekers whose disability prevents them from being able to apply online. Only messages left for this purpose will be returned. Messages left for other purposes, such as following up on an application or technical issues unrelated to a disability, will not receive a response.

What you need to know about the Kolkata Tech Scene

When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account