Bachelor’s degree in computer science/engineering or equivalent., 3+ years of experience with ETL Testing and creating test cases for ETL components., Proficient in writing advanced SQL queries and understanding data flow between systems., Strong analytical and problem-solving skills, with experience in Agile environments..
Key responsabilities:
Perform functional testing to validate data pipelines and systems.
Create and automate test cases for applications using ETL components.
Test data accuracy and completeness, verifying data source locations and formats.
Collaborate with data engineering to ensure a sustainable testing approach.
Report This Job
Help us maintain the quality of our job listings. If you find any issues with this job post, please let us know.
Select the reason you're reporting this job:
Veeva Systems Inc. is a leader in cloud-based software for the global life sciences industry. Committed to innovation, product excellence, and customer success, Veeva has more than 875 customers, ranging from the world's largest pharmaceutical companies to emerging biotechs. Veeva is headquartered in the San Francisco Bay Area, with offices in Canada, Europe, Asia, and Latin America. Veeva is growing to 10,000 employees by 2025, so visit the Jobs section for open positions and remember that correspondence to new applicants and existing candidates will only come from an official @veeva.com email address.
Veeva Systems is a mission-driven organization and pioneer in industry cloud, helping life sciences companies bring therapies to patients faster. As one of the fastest-growing SaaS companies in history, we surpassed $2B in revenue in our last fiscal year with extensive growth potential ahead.
At the heart of Veeva are our values: Do the Right Thing, Customer Success, Employee Success, and Speed. We're not just any public company – we made history in 2021 by becoming a public benefit corporation (PBC), legally bound to balancing the interests of customers, employees, society, and investors.
As a Work Anywhere company, we support your flexibility to work from home or in the office, so you can thrive in your ideal environment.
Veeva OpenData supports the industry by providing real-time reference data across the complete healthcare ecosystem, to support commercial sales execution, compliance, and business analytics. We drive value to our customers through constant innovation, using cloud-based solutions and state-of-the-art technologies to deliver product excellence and customer success.
As a QA Engineer in OpenData, you will be expected to perform functional testing to validate data pipelines and data systems, working closely with data engineering functions to ensure a sustainable test approach. We value end-to-end ownership, which gives you the freedom to determine the correct course of action, do all due diligence, and execute solutions in your own creative way.
What You’ll Do
Identify the project scope, expected outcome, data model, and relevant business rules
Create test cases for applications that use ETL components
Identify key ETL mapping scenarios and create SQL queries that simulate them
Automate ETL test cases where possible
Test the accuracy of the data and its completeness
Check the data source locations and formats, perform a data count, and verify that the columns and data types meet the requirements
Requirements
3+ Years of experience with ETL Testing
Experience creating test cases for applications that use ETL components
Experience analyzing ETL mapping documents
Proficient in writing advanced SQL queries
Understanding the flow of data between the systems and their Data model
Experience with Cloud infrastructure platforms like AWS
Must possess strong analytical and problem-solving skills
Experience automating features for better regression coverage
Good verbal and written communication and proven experience of working and delivering in an Agile environment
Bachelor’s degree in computer science/engineering or equivalent
Familiar with object-oriented programming and scripting languages like Java, Python
Nice to Have
Hands-on experience using DevOps tools and CI/CD
Experience with PySpark
Previous experience in the Life Sciences sector
Perks & Benefits
Medical, dental, vision, and basic life insurance
Flexible PTO and company paid holidays
Retirement programs
1% charitable giving program
Compensation
Base pay: $65,000 - $120,000
The salary range listed here has been provided to comply with local regulations and represents a potential base salary range for this role. Please note that actual salaries may vary within the range above or below, depending on experience and location. We look at compensation for each individual and base our offer on your unique qualifications, experience, and expected contributions. This position may also be eligible for other types of compensation in addition to base salary, such as variable bonus and/or stock bonus.
#LI-Remote
Veeva’s headquarters is located in the San Francisco Bay Area with offices in more than 15 countries around the world.
Veeva is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin or ancestry, age, disability, marital status, pregnancy, protected veteran status, protected genetic information, political affiliation, or any other characteristics protected by local laws, regulations, or ordinances. If you need assistance or accommodation due to a disability or special need when applying for a role or in our recruitment process, please contact us at talent_accommodations@veeva.com.
Required profile
Experience
Industry :
Computer Software / SaaS
Spoken language(s):
English
Check out the description to know which languages are mandatory.