Quality Assurance Engineer w/ VS Code / PostgresSQL / Cloud

CONTRACT - DATA QUALITY ASSURANCE ENGINEERlooking for a person in Chicago that can come in for occasional in-office for team building.BILL RATE: open/hourDURATION: 1-2 YEARSLOCATION: RemoteSponsorship: Open to H1BSELLING POINTS: SQL Database ETL data quality process data testing within data management MDM system data warehouse as well as data analytics manual and automation amazon redshift mpp databases or other cloud warehouses hex tableau power bi or other analytics applications validation end user reports ETL process testing scripting C# python Js PowerShell regression test strategies Kodda or SSIS packages is a strong plus strong communication a must and business customer interfacing. Keys are PostgreSQL API Cloud AWS Vscode (Visual studios) python GitHub oracle a plus, they are developing an eligibility pension into the cloudThe Data Quality Assurance Engineer will be responsible for ETL process Data testing within Master Data Management (MDM) system, Data Warehouse, as well as Data Analytics.The 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 our existing data warehouse objects and ETL processes. Data Quality engineer is responsible for planning and executing manual and automated testing activities on new and existing products to ensure that they meet the Business, Functional and Technical specifications and maintain high overall product quality.The Data Quality Assurance Engineer must be an advocate for all things Testing and Quality while driving and implementing best practices and must possess strong analytical and critical thinking abilities.The successful candidate is entrepreneurial at heart and open to building an entirely new set of capabilities for the organization.o Load balance testingo Duplicate run testingo Negative testing with invalid test datao Performance/volume testingo Build and execute regression test scenarios• Provide estimates and timeframe necessary for testing a project to ensure a high-quality implementation.• Participate in data migration testing activities, including data validation, integrity checks, and reconciliation across source and target systems.• Contribute to and maintain project documentation• Identify, report and track defects and User Experience issues through a system of record.• Collaborate with external teams on root cause analysis.• Maintain close interaction with business and technical peers during the project life cycle.• Actively participate in requirements and code reviews.• Actively participate and drive improvements in Agile Scrum delivery.• Be a thought leader in the test design and execution arena (manual and automated).• Identify process bottlenecks and suggest improvement actions.• Creation and input of test data, either manually or by using tools, programs or masked production data to execute test cases.Qualifications.• Must have experience with dimensional databases.• 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 in ETL process testing is a must.• Strong hands-on experience using complex sql queries for results validation, data mining and evaluating foreign key dependencies.• Strong ability to troubleshoot issues, identify root causes, and support external teams in development of resolutions.• 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.• 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.• Strong communication and Client/Business interfacing and interpersonal skills are a must.