ETL QA Engineer - Platform Ops

Job Title: QA / ETL Tester

Responsibilities:

ETL Testing: Develop and implement comprehensive test plans and strategies for ETL processes, ensuring data accuracy, consistency, and completeness in the data warehouse.

Data Validation: Validate data at various stages of the ETL process, including data extraction, transformation, and loading, to ensure the integrity of the data warehouse.

Test Automation: Design, develop, and maintain automated test scripts and frameworks to streamline testing processes and enhance efficiency.

Regression Testing: Conduct thorough regression testing to identify and mitigate any potential issues or bugs introduced during the development process.

Performance Testing: Perform performance testing to assess the responsiveness, scalability, and stability of ETL processes and data pipelines, collaborating with the development team to optimize performance.

Collaboration: Work closely with data engineers, data analysts, and other stakeholders to understand project requirements, identify potential risks, and provide QA insights throughout the development lifecycle.

Documentation: Create detailed test cases, test reports, and documentation to facilitate effective communication and knowledge sharing within the team.
Data Warehouse Concepts: Apply knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, and facts, in the testing process.

Sign-offs: Ensure all sign-offs on deliverables (overall test strategy, test plan, test cases) and that testing meets governance requirements.

Quality Assurance: Ensure the quality of work and the work of the entire development team.

Data Analysis: Write and execute queries to validate data and troubleshoot erroneous results, logging defects, and working with the development team to resolve software-related defects.

Technical Skills:

ETL Tools: Experience with ETL tools and frameworks, preferably with Azure Data Factory and DBT.
Cloud Platforms: Proficiency in using Snowflake for data warehousing.
API Testing: Experience with API testing tools such as Postman, SoapUI, or similar.
SQL and Scripting: Proficiency in SQL and scripting for data validation and test case data comparison.
Automation: Experience in test automation using tools like Selenium WebDriver, pytest, or similar.
Agile/Scrum: Understanding of Agile/Scrum development principles.
Data Integration: Knowledge of data integration techniques and best practices.

Requirements:

Bachelor's degree in Computer Science, Engineering, or a related field.
5-8 years of experience in quality assurance, with a focus on ETL and data warehousing.
Strong proficiency in SQL and experience with data warehousing concepts.
Experience with cloud data platforms, preferably Snowflake.
Familiarity with ETL tools like Azure Data Factory and DBT.
Knowledge of software testing best practices, methodologies, and tools.
Excellent analytical and problem-solving skills, with the ability to troubleshoot complex issues and provide effective solutions.
Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.
Experience or familiarity with healthcare domain concepts and regulations is a plus.

As a leading payments company in healthcare, we guide, price, explain, and pay for care on behalf of insurers and their members. We’re Zelis in our pursuit to align the interests of payers, providers, and consumers to deliver a better financial experience and more affordable, transparent care for all. We partner with more than 700 payers, including the top-5 national health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, over 4 million providers, and 100 million members, enabling the healthcare industry to pay for care, with care. Zelis brings adaptive technology, a deeply ingrained service culture, and a comprehensive navigation through adjudication and payment platform to manage the complete payment process.

Commitment to Diversity, Equity, Inclusion, and Belonging 
At Zelis, we champion diversity, equity, inclusion, and belonging in all aspects of our operations. We embrace the power of diversity and create an environment where people can bring their authentic and best selves to work. We know that a sense of belonging is key not only to your success at Zelis, but also to your ability to bring your best each day.

Equal Employment Opportunity
Zelis is proud to be an equal opportunity employer. All applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. 

We encourage members of traditionally underrepresented communities to apply, even if you do not believe you 100% fit the qualifications of the position, including women, LGBTQIA people, people of color, and people with disabilities.

Accessibility Support 

We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email [email protected]

SCAM ALERT: There is an active nationwide employment scam which is now using Zelis to garner personal information or financial scams. This site is secure, and any applications made here are with our legitimate partner. If you’re contacted by a Zelis Recruiter, please ensure whomever is contacting you truly represents Zelis Healthcare. We will never asked for the exchange of any money or credit card details during the recruitment process. Please be aware of any suspicious email activity from people who could be pretending to be recruiters or senior professionals at Zelis.