| Data Warehouse ETL QA Tester Wilmington, MA-Local at Wilmington, Massachusetts, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1821204&uid= From: Shambhu, SUS Infotech [email protected] Reply to: [email protected] Title: Data Warehouse QA Tester Location: Wilmington, MA (Hybrid)-Need Local Duration: 6 months/contract to Hire Qualifications: Education: Bachelor's degree in Computer Science, Information Technology, or related field. Experience: 7-10 years of experience in software testing, including both manual and automation testing. Experience working on SQL server versions 2017,2019, 2022 Proven experience with Microsoft technologies (SSMS) or Toad IDE and testing of ETL processes and data warehouses. Extensive experience with T-SQL for database testing and data validation. Strong SQL skills for data validation, especially with supply chain datasets (invoice, billing, revenue, product, customer, route, contracts, inventory, logistics, procurement). Extensive experience with Data warehouse concepts and architecture. Solid knowledge of Agile methodologies. Technical Skills: Proficiency in writing and executing SQL queries for database validation. Good to have experience with cloud-based testing on any AWS, Azure or Oracle. Familiarity with tools like GIT, Zephyr, Confluence, and Power BI. Knowledge of automation testing frameworks. Soft Skills: Strong analytical and problem-solving skills. Excellent communication skills, both written and verbal. Ability to document processes clearly for both technical and non-technical audiences. Team player with the ability to lead and collaborate across departments. Overview: The ideal DW QA engineer comes with relevant manufacturing, supply chain (invoice, billing, revenue, product, customer, route) data set QA experience. A candidate coming from a different industry but exposure and experience in similar data sets would qualify for the role as well. Key Responsibilities: Data & ETL Testing: Conduct extensive data testing, validating ETL processes, and ensuring data accuracy/reconciliation, integrity, and consistency across data warehouses and server upgrade project. Write and execute complex SQL queries to validate data across databases, ensuring correct data extraction, transformation, and loading (ETL) operations. Design, develop, and implement comprehensive test plans, test strategies, test scenarios, and test cases. Execute both manual and automated test cases. Perform end-to-end testing of SSIS packages, ETL jobs, and data transformations to ensure the integrity, accuracy, and consistency of data across various platforms. Optimize testing methods to improve coverage and efficiency. Defect Management: Use tools like Jira for defect tracking, test case management, and test execution. Collaborate with development teams for defect triage, ensuring timely resolution of bugs and issues. Documentation & Reporting: Prepare detailed test documentation including test plans, test reports, and user manuals. Provide regular status reports to stakeholders and management, ensuring transparency on QA progress. Lead Other QA Initiatives: Lead the QA process for multiple projects, ensuring alignment with the organization's quality objectives. Serve as a Subject Matter Expert (SME) in data, ETL, and data warehouses. Collaboration: Work closely with developers, business analysts, and product owners in Agile environments to ensure seamless delivery of high-quality releases. Participate in daily stand-ups and sprint planning sessions to provide QA insights and identify potential risks. Thanks & Regards Shambhu Team Lead Recruiter Keywords: quality analyst business intelligence Massachusetts Data Warehouse ETL QA Tester Wilmington, MA-Local [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1821204&uid= |
| [email protected] View All |
| 05:05 AM 08-Oct-24 |