Note: The job is a remote job and is open to candidates in USA. Motion Recruitment is seeking a Senior Data Quality/ETL Test Engineer to join their team in Chicago. This role involves testing ETL processes and data migration activities within a Master Data Management system and Data Warehouse, ensuring data quality and integrity during a significant cloud migration project.
Responsibilities
- Develop, modify, and execute test plans for both ETL and data migration activities
- Perform load balance testing, duplicate run testing, negative testing with invalid test data, performance/volume testing, and regression testing
- Conduct data validation, integrity checks, and reconciliation across source and target systems
- Understand the needs of the organization and determine how to best test modeled data
- Maintain and improve the health of existing data warehouse objects and ETL processes
- Write complex SQL queries for source and target systems to verify the data for the ETL processes
- Review business requirements, functional specifications, use cases, design, and architecture documents to create effective test plans
Skills
- Must have experience with dimensional databases and strong hands-on experience using complex SQL queries for results validation, data mining and evaluating foreign key dependencies
- Hands-on experience validating End User reports
- Hands-on experience in ETL process testing is a must
- Strong ability to troubleshoot issues, identify root causes, and support external teams in development of resolutions
- Hands-on experience in Regression Test Strategies, Regression suite maintenance and execution
- Experience with Amazon Redshift, MPP Databases, or other cloud warehouses
- Ability to thrive in a project-based environment with evolving requirements
- Strong analytical skills with the ability to collect, aggregate, analyze, and wrangle significant amounts of information with attention to detail and accuracy
- Deep understanding of Development and Test cycles, including respective best practices
- Strong hands-on experience in Agile and Waterfall methodologies
- Hands-on experience with Hex, Tableau, Power BI or other analytics applications is a strong plus
- Hands-on experience with one or more scripting languages (C#, Python, JS, PowerShell, etc.) is a strong plus
- Hands-on experience with Kodda or SSIS packages is a strong plus
Benefits
- 100% company-paid family insurance benefits including health, dental, RX & vision
- 100% company-funded pension plan (at no cost to the employee)
- 401(k) retirement plan with company match
- 35-hour work week
Company Overview
Company H1B Sponsorship