Quality Engineer
Apply NowCompany: Takeda
Location: Memphis, TN 38109
Description:
The Quality Engineer, Data will work with the Data Engineering team to develop/run test scripts across all data pipelines to track and validate data from end to end. They will also be able to automate scripts to perform daily monitoring and validation to catch anomalies and prevent drift. This is different than traditional test automation engineers in that they are not automating a path through a UI but are developing targeted tests around large-scale data movement to verify Extract/Transform/Load (ETL) requirements and performance.
Responsibilities:
Works with Data Engineers to understand new stories under development and specific testing that is required for it.
Develops test cases for individual stories as well as for entire releases.
Performs ETL testing as part of story and release testing - following data sets through entire data lifecycle from end to end starting with raw source, data landing, cleansing, integration and transformation into data warehouse and testing to ensure data completed journey as intended
Compares schemas (tables, views and stored procedures) across different environments to verify consistency and that the SDLC has been adhered to for deployments
Utilizes SQL, ADF, Query Surge, Data Bricks, Pandas, Fabric, and other tools/libraries to develop, execute and schedule automated repeatable tests to ensure ETL quality does not stray
Tracks and benchmarking Production nightly ETL refresh times and monitoring impacts of code changes to that time.
Controls and validates data refreshes into test environments to ensure data sets are adequate for load and performance testing
Documents and communicates all test results per SDLC requirements within each story and across a whole release.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Required Skills & Experience
Bachelors degree in computer science or a related field, or in lieu of degree related experience and education
5+ years of experience performing tests against very large datasets and developing, running, and deploying automation scripts in a production environment
Strong Structure Query Language (SQL) skills including the ability to generate dynamic SQL to quickly develop and scale out queries to cover a large number of data objects
Proficient Python development skills to setup automated test scripts
Strong quality mentality knowing common failure points, patterns and edge cases to test in ETL
Experience with a full range of data testing (ETL, performance, load, etc.)
Comfortable working with Azure tools (Azure Data Factory [ADF], Fabric, Data Bricks, etc.)
Comfortable following a structured Software Development LifeCycle (SDLC) to capture/control all work/test cases/scripts using tools like Jira, Azure DevOps, Git
Specialty Pharmacy and/or Healthcare experience preferred; aptitude for acquiring strong industry knowledge
Ability to work under pressure, organize and prioritize responsibilities
Ability to quickly grasp complex technical and business concepts and express them in clear language
Self-motivated with the ability to work independently as well as part of a team
Effective communication skills (both written and verbal) with internal and external clients
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.
Responsibilities:
Works with Data Engineers to understand new stories under development and specific testing that is required for it.
Develops test cases for individual stories as well as for entire releases.
Performs ETL testing as part of story and release testing - following data sets through entire data lifecycle from end to end starting with raw source, data landing, cleansing, integration and transformation into data warehouse and testing to ensure data completed journey as intended
Compares schemas (tables, views and stored procedures) across different environments to verify consistency and that the SDLC has been adhered to for deployments
Utilizes SQL, ADF, Query Surge, Data Bricks, Pandas, Fabric, and other tools/libraries to develop, execute and schedule automated repeatable tests to ensure ETL quality does not stray
Tracks and benchmarking Production nightly ETL refresh times and monitoring impacts of code changes to that time.
Controls and validates data refreshes into test environments to ensure data sets are adequate for load and performance testing
Documents and communicates all test results per SDLC requirements within each story and across a whole release.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Required Skills & Experience
Bachelors degree in computer science or a related field, or in lieu of degree related experience and education
5+ years of experience performing tests against very large datasets and developing, running, and deploying automation scripts in a production environment
Strong Structure Query Language (SQL) skills including the ability to generate dynamic SQL to quickly develop and scale out queries to cover a large number of data objects
Proficient Python development skills to setup automated test scripts
Strong quality mentality knowing common failure points, patterns and edge cases to test in ETL
Experience with a full range of data testing (ETL, performance, load, etc.)
Comfortable working with Azure tools (Azure Data Factory [ADF], Fabric, Data Bricks, etc.)
Comfortable following a structured Software Development LifeCycle (SDLC) to capture/control all work/test cases/scripts using tools like Jira, Azure DevOps, Git
Specialty Pharmacy and/or Healthcare experience preferred; aptitude for acquiring strong industry knowledge
Ability to work under pressure, organize and prioritize responsibilities
Ability to quickly grasp complex technical and business concepts and express them in clear language
Self-motivated with the ability to work independently as well as part of a team
Effective communication skills (both written and verbal) with internal and external clients
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.