Senior Associate, QA Engineer - Data Warehousing

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 accommodations@ankura.com 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.