ETL QA Engineer

Motion Recruitment
Des Plaines, United States of America
2 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Remote
Des Plaines, United States of America

Tech stack

Business Analytics Applications
C Sharp (Programming Language)
Databases
Data Architecture
ETL
Data Migration
Data Mining
Data Warehousing
Database Testing
Software Design Documents
Python
Powershell
Regression Testing
Power BI
SQL Server Integration Services
Tableau
Test Data
Scripting (Bash/Python/Go/Ruby)
Freeform SQL
Data Analytics
Data Management
Redshift

Job description

This ETL Quality Assurance Engineer will be responsible for ETL process Data testing within the company's Master Data Management (MDM) system, Data Warehouse, as well as a Periscope Data Analytics platform. A successful candidate will deeply understand the needs of the organization and determine how to best test modeled data, as well as maintain and improve the health of existing data warehouse objects and ETL processes., * Constantly develop a deeper understanding of available data

  • Work to understand multiple operational departments and how data is captured and used within the organization
  • Become an expert in business rules, system functionality and architecture
  • Understand the current state to develop and/or enhance the data quality framework to support the Data Architecture and Data Analytics teams
  • Aptitude to evolve the current data quality processes into an enterprise data quality practice
  • 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 for both ETL and data migration activities providing robust coverage
  • Independently develop, modify, and execute test plans based on requirements and design documents including, but not limited to, the following methods: Load balance testing, Duplicate run testing, Negative testing with invalid test data, and Performance/volume testing

Requirements

  • Strong hands-on experience using complex SQL queries for results validation, data mining and evaluating foreign key dependencies
  • Must have experience with dimensional databases
  • Hands-on experience in ETL process testing is a must
  • Experience with Amazon Redshift, MPP Databases, or other cloud warehouses
  • Hands-on experience with Hex, Tableau, PowerBI or other analytics applications is a strong plus
  • Hands-on experience validating End User reports
  • Hands-on experience with one or more scripting languages (C#, Python, JS, PowerShell, etc.) is a strong plus
  • Hands-on experience in Regression Test Strategies, Regression suite maintenance and execution
  • Hands-on experience with Kodda or SSIS packages is a strong plus
  • Deep understanding of Development and Test cycles, including respective best practices
  • Strong communication and Client/Business interfacing and interpersonal skills are a must

Apply for this position