ETL Tester - Claims

Job Description:

Our client is seeking an ETL Tester - Claims. In this position, Sr. Data Quality Tester will be responsible for ETL process Data testing.  

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 ETL processes. The Sr. 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 Sr. Data Quality Engineer must be an advocate for all things Testing and Quality while driving and implementing best practices. And must poses 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.  

Duties and responsibilities:

• 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. 
• 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 in order to create effective, value add test plans. 
• Independently develop, modify, and execute test plans based on requirements and design documents including, but not limited to, the following methods: 
• Duplicate run testing 
• Negative testing with invalid test data  
• Build and execute regression test scenarios 
• Provide estimates and timeframe necessary for testing a project to ensure a high-quality implementation.  
• Contribute to and maintain project documentations. 
• 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. 
• Ability to handle multiple projects simultaneously and meet deadlines in a fast-paced environment. 
• Be a thought leader in the test design and execution arena (manual and automated).  
• Identify process bottlenecks and suggest improvement actions.  

Position Requirements:

• Experience with dimensional databases. 
• 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. 
• Hands-on experience validating End User reports. 
• Hands-on experience in ETL process testing is a must. 
• Strong hands-on experience using SQL complex queries for results validation, data mining and evaluating foreign key dependencies. 
• Strong ability to troubleshoot issues, identifying root causes and support external teams in development of resolutions.  
• Hands-on experience with one or more scripting languages (C#, Visual Basic, Python, JS, PowerShell etc.) is a strong plus. 
• Hands-on experience in Regression Test Strategies, Regression suite maintenance and execution
• Hands-on experience with SSIS packages is a strong plus. 
• 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. 
• Experience using QA/test automation frameworks (Selenium or ReadyAPI) will be a plus. 
• Experience levering any AI tools or command prompting for QA testing will be a plus. 

Rate: $65-75/hour (depends on experience level). This is a contract position with candidates expected to work 40 hours/ week.