Job Description

Job Title: ETL Tester

Work Location: Phoenix, AZ
 

Job Overview

In this role, you will bring proven expertise in system and complex integration testing across multiple platforms and technologies. Your focus will be on both functional and non-functional testing, with a comprehensive understanding of the entire development lifecycle. The role requires adaptability in a dynamic environment, with the ability to interpret complex issues and adjust plans accordingly. You will join an Agile-driven team and play a key part in managing workloads, prioritizing tasks, and consistently delivering projects on time. We are seeking someone with a forward-thinking mindset, who can envision automation frameworks and testing strategies across a range of products.

Key Responsibilities

• Design and Execute Test Plans: Develop, plan, and implement comprehensive test cases, scenarios, and scripts specifically for ETL validation and regression testing.
• Data Accuracy Verification: Utilize ETL tools and SQL queries to verify and validate data accuracy, completeness, and consistency throughout the data transformation process.
• Test Case Management: Create, update, and maintain test cases, scripts, and associated documentation using test management platforms such as JIRA and HP ALM.
• Cross-functional collaboration: Work closely with developers, data analysts, and business stakeholders to thoroughly understand both business and technical requirements for effective ETL testing.
• Defect and Risk Management: Identify, document, and report any defects, issues, or risks encountered during testing, ensuring timely resolution.
• Root Cause Analysis: Conduct thorough root cause analysis for any issues found, and offer actionable recommendations for remediation.
• Agile Workflow: Operate within an Agile environment, contributing to the timely delivery of high-quality ETL testing results.
   

Key Skills

• Testing & Data Validation: Hands-on experience testing data validation scenarios, including data ingestion, pipelines, and transformation processes (ETL).
• Big Data Expertise: Knowledge of big data engineering tools like Spark, Hive, Hadoop, and Dask, and their strategic use in testing.
• Automation & Tools: Proficiency with automated testing tools, and the ability to apply them throughout the full development lifecycle.
• Information Governance: Understanding of information governance principles and how they can be integrated into the testing process.
• Cross-Platform Testing: Demonstrated experience in automating tests across various platforms and technologies.
• Test Case Management: Familiarity with test case management tools and their application.
• Issue & Defect Management: Experience managing issues and defects through hands-on processes.
• System Testing: Proven experience testing systems that handle field-generated metadata.
• Technical Knowledge: Familiarity with back-end and front-end languages, libraries, databases, web servers, services, APIs, and UI/UX design.
• Modern Testing Practices: Knowledge of modern testing development practices, including tools such as Selenium, and Mocha, and integration with platforms like GitLab.
• Diverse Technology Experience: Experience working with a wide range of technologies and solving complex problems.
• Non-Functional Testing: Expertise in non-functional testing, including backup/recovery, disaster recovery (DR), and performance testing.
• Agile Methods: Solid experience with Agile software development and testing methods, particularly in cloud environments.
   

Benefits

• PerkBox Access: Global benefits and rewards platform offering a variety of perks to celebrate and support our employees, no matter their location or preferences.
• Cycle to Work Scheme: Tax-free bike and equipment purchases with potential savings of up to 42%.
• Generous Holiday Allowances: Earn additional holiday days based on length of service, up to a maximum of 24 days plus bank holidays.
• Annual Flu Jabs: Available for colleagues over 50 upon request.
• Flexible Working: Our Flex program allows employees to work from home up to five days per week.
• Wellbeing Support: PerkBox offers various resources to prioritize your wellbeing.
• Team Events: Opportunities for team-building and celebrating company successes.
• Bonus Scheme: Financial rewards aligned with both company and individual performance.
• Training & Development: Ongoing commitment to personal and professional growth, including access to digital learning platforms and tailored development plans.
• Referral Rewards: Earn bonuses for helping recruit new team members through our referral program.
• Long-Term Recognition: Special recognition for colleagues celebrating 5 years of service and participation in our EMI scheme.