ETL Validation Tester

Fidelity TalentSource is your destination for discovering your next temporary role at Fidelity Investments. We are currently sourcing for a ETL Validation Tester to work in Fidelity’s Charitable group in Durham, NC!

The Role

Fidelity Charitable is seeking a talented Quality Software Engineer who is experienced in data warehouse / data lake testing, analyzing data, validating and independently troubleshooting data issues.

In this role, you will work with data analysts, data engineers, data governance and business partners who take pride in building a quality data environment and analytical platform.

You’ll be involved in all phases of the development lifecycle and have a direct impact on the quality of the customer experience.

This role requires a combination of both developer, data analysis, and quality assurance skill sets, as well as experience working on an Agile development team.

The Value You Deliver

We work within an agile software development model, focused on building our foundational Snowflake analytics environment.

Our goal and your skills ensure we deliver high value, high quality data that augments our growing analytical environment and to do so in an automated, efficient manner.

To be successful in the role, you must be quality obsessed and able to quickly gain a deep understanding of our data and data transformations.

You will ensure the highest product quality and end user satisfaction through thorough testing and the implementation of quality assurance standard methodologies.

The Expertise and Skills You Bring

• Direct experience implementing QA standard processes for data warehouse / data lake quality assurance; Snowflake experience preferred
• demonstrated ability in functional testing, test automation tools and implementation
• Proficiency in professional software development skills (Snowflake exposure, ETL dev etc)
• Strong abilities around writing complex SQL queries and performing data analysis.
• Experience in using any automation tools for data analysis like Python, Alteryx, ICEDQ, etc.
• Ability to organize and conduct proof of concept exercises on Snowflake compatible automation tools with the intent to recommend solutions to the organization.
• Proven understanding and passion for QA engineering, Test Driven Development, developing robust software, writing testable and maintainable automation code.
• Experience integrating the automation code with DevOps pipeline for CICD and usage of tools like Jenkins, etc.
• Excellent written and verbal communication skills
• Highly collaborative team player that works well within a cross functional team across multiple locations
• Strong problem identification and solving skills; Ability to perform root cause analysis
• Ability to perform requirement analysis, defect tracking, test reporting and closure, while partnering with developers to address QA findings.
• You have excellent understanding of Oracle, Snowflake, SnowSql
• Working knowledge of Relational Database Management System
• Knowledge on Cloud (AWS / Azure) and Cloud Data platforms
• Good working experience in scripting languages, preferably Python, Unix, and Shell scripting
• Experience in reporting tools like Tableau, Power BI, etc. is an advantage.
• Experience or knowledge of using a Selenium automation framework (Java based)
• Experience or understanding of Agile software development methodology using Scrum.
• Continuous improvement mindset where mistakes and failure are viewed as opportunities to learn and improve.

The Team

Fidelity Charitable is the brand name for the Fidelity® Charitable Gift Fund, an independent public charity, established in 1991 with the mission to further the American tradition of philanthropy by providing programs that make charitable giving simple and effective.

Our culture is compassionate, empowered, and innovative. You will build a legacy, embody the vision of our founder, and shape the future of philanthropy.

As part of Fidelity Charitable’s Data & Shared Services Product Area, you will join a team responsible for the robust data ecosystem the Charity relies upon to deliver significant philanthropic benefit to our donors and non-profit organizations.

Personally, you will have a key role in developing a culture of quality data, by embedding Data Quality principles in the Charity’s core business and technical functions.

COVID work policy

Safety is our top priority. Once we can be together in person with fewer safety measures, this role will be moved to our dynamic working approach.

You’ll be spending some of your time onsite depending on the nature and needs of your role.

Dynamic Working Post Pandemic

Our aim is to combine the best of working offsite with coming together in person. For most teams this means a consistent balance of working from home and office that supports the needs of your role, experience level, and working style.

Your success and growth is important to us, so you’ll want to enjoy the benefits of coming together in person face to face learning and training, quality time with your manager and teammates, building your career network, making friends, and taking full advantage of cultural and social experiences Fidelity provides for you

Company Overview

Fidelity TalentSource is the in-house temporary staffing provider for Fidelity Investments, one of the largest and most diversified global financial services firms in the industry.

We welcome individuals from all backgrounds, including technology and customer service, to fill assignments across Fidelity’s U.

S.-based regional and investor center locations. If you would like to experience Fidelity’s supportive and collaborative culture while expanding your skill set and developing your professional network, consider a role with Fidelity TalentSource. Apply today at

FTSJobs.com

We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.

Fidelity TalentSource will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process.

To initiate a request for an accommodation, please contact our HR team at

HR@ ftsjobs.com

Information about Fidelity investments

At Fidelity Investments, our customers are at the heart of everything we do. As a privately held company with a rich 75-year history, our mission has remained the same since our founding : to strengthen the financial well-being of our clients .

We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees.

And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients’ money.

For information about working at Fidelity, visit

FidelityCareers.com

Fidelity TalentSource's working model blends the best of working offsite with maximizing time together in person to meet associate and business needs.

Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).

Fidelity Investments and Fidelity TalentSource are equal opportunity employers.