IntegriChain is the data and application backbone for market access departments of Life Sciences manufacturers. We deliver the data, the applications, and the business process infrastructure for patient access and therapy commercialization. More than 250 manufacturers rely on our ICyte Platform to orchestrate their commercial and government payer contracting, patient services, and distribution channels. ICyte is the first and only platform that unites the financial, operational, and commercial data sets required to support therapy access in the era of specialty and precision medicine. With ICyte, Life Sciences innovators can digitalize their market access operations, freeing up resources to focus on more data-driven decision support. With ICyte, Life Sciences innovators are digitalizing labor-intensive processes – freeing up their best talent to identify and resolve coverage and availability hurdles and to manage pricing and forecasting complexity.
We are headquartered in Philadelphia, PA (USA), with offices in: Ambler, PA (USA); Pune, India; and Medellín, Colombia. For more information, visit www.integrichain.com, or follow us on Twitter @IntegriChain and LinkedIn.
Job Description- Perform lead role in ETL testing, UI testing, DB testing and team management.
- Understand the holistic requirements, review and analyse stories, specifications, and technical design documents and develop detailed test cases and test data to ensure business functionality is thoroughly tested – both Automation & Manual.
- Validate ETL workflows, ensuring data integrity, accuracy and the Transformation rules using complex Snowflake SQL queries. Working Knowledge on DBT is a PLUS
- Create, Execute and maintain scripts on automation in BDD – Gherkin/Behave, Pytest.
- Experience in writing DB queries (preferably in Postgres/ Snowflake/ MySQL/ RDS)
- Preparation, review and update of test cases and relevant test data consistent with system requirements including functional, integration & regression, UAT testing.
- Coordinate with cross team subject matter experts to develop, maintain, and validate test scenarios to the best interest of that POD.
- Taking ownership on creating and maintaining artifacts on: Test strategy, BRD, Defect count/leakage report and different quality issues.
- Collaborate with DevOps/SRE team to integrate test automation into CI/CD pipelines (Jenkins, Rundeck, GitHub etc.)
- Should have the ability to oversee and guide a team of min 4 testers, lead them by example, institutionalizing best practices in testing processes & automation in agile methodology.
- Meet with internal stakeholders to review current testing approaches, provide feedback on ways to improve / extend / automate along with data backed inputs and provisioning senior leadership with metrics consolidation.
- Maximize the opportunity to excel in an open and recognized work culture. Be a problem solver and a team player.
- 8-11 years of strong expertise in STLC, defect management, Test Strategy designing, planning and approach. Should have experience with Test requirement understanding, test data, test plan & test case designing.
- Should have minimum 6+ years of strong work experience in UI, Database, ETL testing. Experience in ETL/data warehouse testing (DBT/Informatica, Snowflake, SQL).
- Any experience with AWS/Cloud hosted applications is an added advantage.
- Hands-on experience in writing DB queries (preferably in postgres/ Snowflake/ MySQL/ RDS)
- Should have 3+ years of experience with automation scripts execution, maintenance & enhancements with Selenium web-driver (v3+)/playwright, with programming experience in Python (MUST) with BDD – Gherkin and Behave, Pytest.
- Key competencies required: Strong analytical, Problem-Solving, Communication skills, Collaboration, Accountability, Stakeholder management, passion to drive initiatives, Risk highlighting and Team leading capabilities.
- Proven Team leadership experience with min 2 people reporting.
- Experienced working with Agile methodologies, such as Scrum, Kanban.
- MS Power BI reporting. Front end vs Back end validation
Professional Approach
- Ready to work in flexible working hours and collaborate with US/India/Colombia teams
- Excellent communication skills (written, verbal, listening, and articulation)
#LI-NS1
Additional InformationWhat does IntegriChain have to offer?
- Mission driven: Work with the purpose of helping to improve patients' lives!
- Excellent and affordable medical benefits + non-medical perks including Flexible Paid Time Off and much more!
- Robust Learning & Development opportunities including over 700+ development courses free to all employees
IntegriChain is committed to equal treatment and opportunity in all aspects of recruitment, selection, and employment without regard to race, color, religion, national origin, ethnicity, age, sex, marital status, physical or mental disability, gender identity, sexual orientation, veteran or military status, or any other category protected under the law. IntegriChain is an equal opportunity employer; committed to creating a community of inclusion, and an environment free from discrimination, harassment, and retaliation.
