ETL Test Automation Engineer

Job Description

GOBankingRates™ is unique in the digital marketing and media industry - we combine marketing, digital, content and fintech. Our performance based approach increases brand awareness and generates targeted audience engagement on our internal web properties and partner sites.

Learn More About What We Do

What's interesting about this role?

GOBankingRates is looking for a skilled ETL Test Automation Engineer. Who will be responsible for developing and maintaining an automated regression suite to prevent data loss, ensure quality, and optimize logical processes, all while ensuring seamless alignment with business requirements. They will be mentored in the company's Quality Assurance process and will be given opportunities to sharpen their knowledge of QA Methodologies & technologies. In this role, you will receive mentorship in the company's Quality Assurance process and have opportunities to work on best practices, technologies & products like AWS, SnowFlake, DBT, Airflow, and Machine Learning. Join us and contribute to our commitment to excellence in data quality and technological innovation.

How Will You Make an Impact?

Participate in Agile ceremonies, help analyze requirements, develop testing strategies, and facilitate the Agile process within all cross-functional teams.

Collaborate with product owners, project managers, data analysts, data scientists, and developers to refine user stories and acceptance criteria and provide feedback on missing business flows and strategies.

Write complex SQL queries on tables with hundreds of millions of records and ensure data integrity is maintained throughout the ETL lifecycle.

Build & maintain automated test coverage using PyTest/Python to validate business goals and technical solutions for new and existing functionality as part of the certification of each ticket, within each sprint.

Work with team leads from discovery to resolution and be the key point of contact for all QA aspects of releases, providing QA services, UAT guidance, and coordinating QA resources internally and externally for the squad.

The ETL Test Automation Engineer will be responsible for developing and maintaining an automated regression suite to prevent data loss, ensure quality, and optimize logical processes, all while ensuring seamless alignment with business requirements. In this role, you will be given opportunities to sharpen your knowledge of QA Methodologies and work with technologies & products like AWS, SnowFlake, DBT, Airflow, and Machine Learning.

What Do You Bring to Us?

Bachelors in Computer Science or Data Science, or Information Systems, or Mathematics, or Statistics or equivalent years of relevant work experience

5+ years of experience with agile software development testing, reviewing user stories, acceptance criteria, and other available information to develop test plans and test scenarios, both manual and automation.

3+ years of experience in database testing for relational databases( preferred Snowflake and MS SQL Server), ETL/ELT data solutions, and reporting and analytics tools.

Knowledge of data warehouse concepts, such as star schemas, snowflakes, facts, and dimensional modeling.

Experience in writing complex SQL queries. Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and creating a comprehensive test plan that supports the business and technological solutions being delivered.

Two or more years of experience creating automated scripts using pytest for data validation.

At least one year of experience with API testing; manual (using tools like Postman/swagger) & automated (REST Assured/CURL).

Demonstrate ability to work within a collaborative source-code repository system, i.e. Git, GitHub, etc.

Strong CI/CD background with working knowledge of deployment automation and tools (Jenkins, Docker, etc.)

Be Comfortable with Cloud-based service testing (AWS is a plus) and basic environment setup.

Experience using Jira or other bug-tracking software.

Must be self-motivated, able to work independently, and thrive in a fast-paced, multi-tasking, high-productivity environment while maintaining excellent working relationships with people in a wide variety of functional areas.

Excellent verbal and written communication skills

The salary range for this role is $120,000 - $135,000. Pay offered may vary within the posted range based on a number of factors including but not limited to job-related knowledge, skills, experience, and location.

Benefits

Competitive salary with excellent growth opportunity; we pride ourselves in having a team that exudes leadership, high initiative, creativity and passion.

Awesome medical, dental and vision plans with heavy employer contribution

Paid maternity leave and paternity leave programs

Paid vacation, sick days and holidays

Company funding for outside classes and conferences to help you improve your skills

Contribution to student loan debt payments after the first year of employment

401(k) -- employees can start contributing immediately. After the first year, GOBankingRates matches your contribution up to 4% of your salary

A note about our new norm: The world has changed and we know it's important to adapt and to do our part to do what's best for our team. Our number one priority is to have our team feel safe, balanced and connected. We're committed to providing our teams with the best resources and tools to navigate this new virtual world that we're living in. We've also reinvented the ways in which we recognize, celebrate, and engage with each other to keep our culture strong!

Here's a peek into our world at GOBankingRates -

Our teams are working remotely 100% for the foreseeable future. We're in the digital media space, so we're mobile and flexible!

*Option to work from an office (if you need to get away!)

Tools & resources are available to keep our team connected across North America. (JIRA, Trello, Slack, Zoom and so much more!)

To keep our community engaged and connected, virtual team building events are held weekly and monthly.

For wellness and balance, weekly virtual fitness classes such as yoga are available.

To care for the local communities that we're a part of across the U.S our team members host socially distanced philanthropic events every quarter.

And most importantly, we've committed to consistent and transparent communication to help us all stay informed, engaged and to keep us on our path to success and #greatness.

We are an equal-opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.