Be part of the team that's poised to transform the fight against cancer. Backed by the strength of a Fortune 8 company, our entrepreneurial organization develops technologies used by the oncology community to deliver evidence-based, personalized care, as well as insights used by biopharma companies to accelerate drug development and support the entire treatment journey. Our work powers informed decision-making at every pivotal moment in oncology - from the treatment options presented to patients, to the operational considerations for oncology practices, to the design of clinical trials, to the commercial launch plans for new therapies.
Sr. Backend Data Base Test Engineer
McKesson Specialty Health is seeking a Sr. Backend Database Test Engineer to provide Quality Assurance Testing services for market-leading healthcare applications. This position will support release readiness, SQL script development, execution and data validation, metric tracking, reporting, AWS cloud migrations, and Quality Assurance best practices and testing standards implementation.
Primary Responsibilities :
Create and implement test strategies, test plans, manual test cases, and automated test scripts for backend data validation.
Collect requirements and analyze and create test cases and procedures for system, backend, functional, and regression testing.
Work with software developers, business analysts, and project managers to analyze test results and debug problems.
Work in parallel with the business SMEs and BA staff to create thorough, accurate, and comprehensive SQL test queries and scripts.
Validate the excellence, quality, consistency, security and performance of large quantity of data transformation through ETL and Business Intelligence.
Validate database procedures along with possible outcomes.
Validate integrity and accuracy of ETL data flow across multiple data tiers satisfying the business logics and meeting performance goals.
Develop SQL and Unix scripts for test data generation or test harness automation for iterative test cycles.
Develop scripts to automate the backend data workflow for data integrity and accuracy across different data sources and among all data staging schemas.
Conduct front-end data validation, API, stored procedures, and REST and web service testing.
Write complex SQL queries to pull data residing in multiple databases, including SQL Server, Oracle, and other platforms.
Update and maintain SQL scripts and test cases as applications and business rules change and identify areas of improvement
Create and execute efficient database queries to support, perform, or validate test cases to compare backend data with dashboard visualization metrics created in BO and Tableau
Evaluate comprehensive visualization reports (BO and Tableau) that verify and validate functional and non-functional system requirements.
Explore and understand the Enterprise Data Warehouse (EDW) and bigdata architecture.
Ensure the program performance meets service level agreements, with proper change management and configuration management.
Provide guidance and support to associate and intermediate level QA engineers.
Strong background in SDLC, agile (scrum) development methodology, test scenarios identification, database automation script development, and execution and report analysis.
Must be familiar and experienced with cloud computing, AWS data warehouse technology (Redshift), Aurora & PostgreSQL databases, cloud-based data migration services, AWS Data Lake, and other rational and non-rational (DynamoDB) databases.
Experience with the Requirements analysis, Test Case management and Defect Tracking tools, for example Jira, qTest, etc.
5+ years of experience with writing SQL (preferably PL/SQL) and ETL, stored procedures validation experience in large data warehouse settings.
Strong skills in an object-oriented programming like Java or Python
Experience building test automation frameworks from scratch using testng, selenium etc
Understanding and experienced with Flat Files, ETL backend testing, and source target Mapping.
Must have foundational understanding of data modeling, quality and metadata, etc.
Solid understanding of CI/CD tools and processes like Jenkins, Bamboo.
Experience with AWS and cloud based computing
Experience working with AWS and Kubernetes.
The ability to lead or have in the past of a technical team.
Demonstrate excellent communication skills including the ability to summarize status and progress, raise concerns about risks or dependencies, and discuss team strategy with both internal and external stakeholders.
Willingness to learn new technologies, research solutions to new and complex challenges, share lessons learned, and collaborate with the team on projects.
4 years degree or equivalent work experience
Internal Use Only: P4
Must be authorized to work in the U.S, now or in the future, without support from McKesson. Relocation is NOT budgeted for this position.
McKesson is an Equal Opportunity/Affirmative Action employer.
All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, disability, or protected Veteran status.Qualified applicants will not be disqualified from consideration for employment based upon criminal history.
McKesson is committed to being an Equal Employment Opportunity Employer and offers opportunities to all job seekers including job seekers with disabilities. If you need a reasonable accommodation to assist with your job search or application for employment, please contact us by sending an email to [email protected] . Resumes or CVs submitted to this email box will not be accepted.
Current employees must apply through the internal career site.
Join us at McKesson!
Internal Number: JR0040100
About McKesson Corporation
We deliver careers with purpose and potential. Our focus on better health starts with creating an inclusive environment with strong values where you can build a fulfilling career. You can count on us to provide you with resources and opportunities to grow and be your best, while contributing to our pursuit of improving lives. Every day, McKesson’s employees deliver products to healthcare providers that make a difference in the care and life of a patient. We work to distribute medical supplies, bandages, syringes, vials of flu vaccine, and pharmaceutical drugs to help real patients like Jack, an eight-year-old boy battling cancer. We take that job seriously. Together, the work we do is shaping the future of healthcare. If you are passionate about combining a meaningful career with a balanced life, join us on this journey and apply for a job with McKesson today. Every day, McKesson’s employees deliver products to healthcare providers that make a difference in the care and life of a patient.