Job Title: Senior Consultant
Location: TRIL GTC Chennai
GCL: D1

Role

The role holder (ETL Test Engineer) will be responsible for requirement analysis, test preparation and end to end test execution of Science Data Hub starting from Source CTMS application into Data Lake and the subsequent ODS and Marts until the final business reports. The ETL Test Engineer will work closely with Data Analysts, Development Team, Ingestion Team, Scrum Master and Product Owner to understand the business feature and the underlying data needs and complexity to prepare test scenarios and test scripts independently to perform ETL Validations on all entities within Science Data Hub. One key responsibility of the ETL Test Engineer will be to work collaboratively with the business team to support UAT Testing and clarify and close observations.

The key tasks of ETL Test Engineer will be (i) Test preparation and requirement analysis to understand ETL Data Model, Design and prepare test scenarios; (ii) support and fill any gaps in Data Model and Data Analysis and support Scrum Teams to improve the quality of ETL framework and suggest improvements; iii) Validate datasets containing millions of records from Clinical Trial applications in an Automated approach; iv) Leverage Automation as much as possible and increase the speed and efficiency of the Testing Process; v) Feedback continuously to the business and Tech Leads in GTC and Hub on the data challenges and provide appropriate recommendations.

The ETL Test Engineer will be an integral and respected part of the data engineering team and specifically the DataOps Testing team, whose input and expertise will be instrumental in ensuring the success of R&D Data Hub delivery.

Key Accountabilities

• Report to the Test Manager continuously on all the Test Metrics, challenges and possible deviations from the approved ways of working.
• Perform peer review of all test deliverables from the testing team to ensure maximum test coverage.
• Take complete ownership of the SIT Testing and perform regression testing for every release in PreProd Environment and also support business in UAT Testing.
• Perform analysis on priority issues from Production and help in root cause analysis for the same.
• Create Test Strategies and Test Plans for all feature-driven development within Science Data Hub by using AZ approved software and in-built tools.
• Deliver Test Artefacts like Test Summary Report and Requirements Traceability Matrix before Production deployment to Platform Lead and Quality Managers to give confidence on the data quality post go live.
• Engage in stakeholder communications on the quality of testing and continuously support process improvements and new ideas to get maximum quality from the testing process.
• Support test data preparation, identify possible source data issues and propose Technical Enablers to continuously improve the System design and model.
• Document all best practises and solutions in AZ Approved storage repositories.
• Assist Quality Managers, Data Governance and Data Privacy team to ensure the industry the best practises are maintained.
• Support all required documentation to ensure the validation and quality of the GxP Systems are maintained.
• Participate and drive all Lean initiatives to remove and optimise repetitive tasks.
• Development of subject matter expertise in sub-domains of the Science & Enabling Unit portfolio – understanding of the business process, data flows, data provenance, data restrictions and data use.

Highly Desirable Knowledge, Skills and Experience

• 6+ experience on ETL Testing with strong experience working in Data Engineering projects and Enterprise Dataware house systems.
• B.Tech in Computer Science.
• A strong understanding of databases and source systems.
• Experience writing complex SQL queries and validation of Enterprise Data Warehouse Applications.
• Strong invalidation of Visual Analytics reports using tools like Power BI, Microstrategy, etc. and running different types of the test within the same.
• Strong in ETL Testing with any industry ETL tool like Talend, Informatica, Data Stage.
• Good knowledge in any RDBMS like AWS Redshift/Postgres/Oracle/SQL Server.
• Identifies, manages, and resolves defects during testing cycles leveraging a test management tool like JIRA, HP ALM. Also, supports or leads UAT process, when appropriate.
• Should be strong in testing fundamentals.
• R Scripting or Python experience and knowledge of CI/CD Pipeline.
• Knowledge of Automation and Automation framework within ETL space.
• UNIX and shell programming knowledge.

Additional skills and experience sought

• In addition, these are the bonus skills (not mandatory) for this position:
• IT Experience in working with Clinical Trial datasets.
• Excellent communication and facilitation skills.
• Good written and verbal skills, fluent English.
• Experience of delivering solutions within IT projects delivered through Agile methodologies.
• Working with API testing and data extraction testing from API.
• Knowledge of XQuery and XML validations.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
 

Date Posted

Closing Date

AstraZeneca embraces diversity and equality of opportunity.  We are committed to building an inclusive and diverse team representing all backgrounds, with as wide a range of perspectives as possible, and harnessing industry-leading skills.  We believe that the more inclusive we are, the better our work will be.  We welcome and consider applications to join our team from all qualified candidates, regardless of their characteristics.  We comply with all applicable laws and regulations on non-discrimination in employment (and recruitment), as well as work authorization and employment eligibility verification requirements.