Work Schedule
Standard (Mon-Fri)
Environmental Conditions
Office
Job Description
Thermo Fisher Scientific Inc. is a global leader in the field of science, generating an annual revenue of around $40 billion. Our goal is to assist our customers in creating a healthier, cleaner, and safer world. Whether our customers are advancing life sciences research, tackling intricate analytical problems, enhancing efficiency in their labs, improving patient health through diagnostics, or producing life-altering therapies, we are dedicated to providing them with unwavering support.
Location/Division Specific Information
The SQA team is part of the corporate IT function under the Enterprise Technology Organization (ETO) and we are responsible for Quality and Continuous Process Improvement for Thermo Fisher Scientific.
How will you make an impact?
We are looking for an outstanding Software Quality Assurance Engineer II to join our team in Bengaluru. As a Data Test Engineer, you will have a vital role in our organization. Your main responsibilities will include validating, designing, documenting, and performing data quality checks. Moreover, you will collaborate with various teams to communicate and handle more intricate tasks.
What will you do?
- Support Data analysts by providing prepped and clean data to enable accurate and efficient analysis.
- Work as part of a team to find trends in data and raw data, contributing to data-driven decision-making.
- Discover ways to enhance report delivery, guaranteeing prompt and efficient communication of valuable insights.
- Develop SQL views or Queries for use by analysts or various departments, promoting efficiency in data access and analysis.
- Provide feedback on usability and serviceability, trace the result to the quality risk, and report it to the concerned people.
- Test all aspects of the product/system, including function/component, system, regression, and service, ensuring flawless performance.
- Support reporting and analysis functions that enable data-driven decision-making, contributing to the achievement of business goals.
- Provide summary analyses in written and oral presentation settings, presenting insights in a clear and compelling manner.
- Develop system test cases and document results, ensuring the quality and reliability of data systems.
- Research system issues and document findings, contributing to the continuous improvement of data processes.
- Work independently or with guidance as per team needs, demonstrating flexibility and adaptability.
- Actively participate in the evaluation and review of software requirements with Developers and Business System Analysts to define complete test plans and test scenarios.
- Ensure that testing activities allow applications to meet business requirements and systems goals, identifying and resolving any issues.
- Demonstrate expertise in Data warehouse testing, Integration, and system testing, contributing to the accuracy and reliability of data systems.
- Create and compose clear and concise test summary reports and weekly status reports, offering valuable insights to the relevant parties.
Education
- Equivalent experience in computer science engineering from an accredited university (desired not required)
- Bachelor’s degree with a major in computer science engineering (or equivalent experience) from an accredited university (preferred)
Experience
- 4 to 8 years’ experience in Database Management, generating medium to high complexity SQL queries for QA validation, debugging data issues, and ensuring data integrity.
- Working knowledge of Oracle, MSSQL, Redshift Databases, AWS S3, and SQL IDEs such as SQL Developer/DB Visualizer/Toad.
- 3 to 4 years’ experience in extraction, transformation, and Loading techniques (ETL) for data in multiple formats from multiple sources.
- Proficiency in Python programming language, enabling efficient data manipulation and analysis.
- Familiarity with cloud infrastructure like AWS or Azure and respective cloud storage systems like AWS S3 /Azure Blob.
- Experience in development models such as Agile or waterfall, ensuring successful project execution.
- Strong analytical skills, attention to details, and ability to work both independently and collaboratively.
- Requirement analysis and understanding of DWBI technical specification documents, contributing to accurate testing.
- Ability to analyze and understand ETL workflows, ensuring the reliability and efficiency of data processes.
- Strong SQL skills, enabling the validation of business rules and the identification of data issues.
- Experience in backend validation of reports developed using tools like Tableau or POWER BI, ensuring accurate and reliable reporting.
- Strong experience in data analytical testing and a good understanding of the data model, contributing to data-driven decision-making.
- Ability to work in a fast-paced team environment with minimal supervision, demonstrating self-motivation and accountability.
- Strong technical, problem-solving, project coordination, and analytical skills, ensuring successful project outcomes.
- Defect tracking till closure, ensuring the resolution of any issues in a timely manner.
- Ability to work on multiple releases and projects simultaneously and to work in different time zones if required.
Good to have Skills
- Work experience in Databricks and PySpark is an added advantage, expanding capabilities for data integration and analysis.
- Experience in Power BI dashboard testing, ensuring accurate and reliable reporting.
- Experience in Tricentis Tosca DI
Non-technical Qualifications
- Proficient in the testing methodology and has hands-on experience drafting requirements for regression and functional tests.
- Superior communication abilities in writing, verbally, and over the phone; experience working with big groups of people