Senior Associate, QA Engineer - Data Warehousing

February 14

Apply Now

Receive Emails with Similar Jobs

Ankura

WebsiteLinkedInAll Job Openings

Ankura is a leading global expert services and advisory firm, specializing in providing strategic advisory solutions across a multitude of industries. The company empowers clients by leveraging artificial intelligence to enhance decision-making, automate processes, and secure competitive advantages. Ankura is adept at handling crisis situations by offering strategic solutions that protect, create, and recover value for clients. The firm's multidisciplinary team collaborates to implement custom solutions that manage risk, compliance, and transformation challenges efficiently.

Technology • Risk & Compliance • Turnaround & Restructuring • Disputes & Expert Testimony • Investigations

1001 - 5000 employees

🏢 Enterprise

🤖 Artificial Intelligence

💰 Private Equity Round on 2021-11

📋 Description

• 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. • 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.

🎯 Requirements

• 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.