As a QA Automation Engineer in our Enterprise Data department, you will be
responsible for creating and managing automated tests to identify issues with the ETL
process to ensure the quality of data in the Enterprise Data Warehouse.
The role involves working together with the onshore Enterprise Data team to decide on
the required tests on the process, automate them through creating stored procedures,
custom dbt tests and scheduling these as part of the ETL process which loads data
from source into the EDW.
Responsibilities:
Translate project requirements into effective and comprehensive test cases.
Define clear testing objectives that align with overall project goals.
Establish the testing scope, prioritizing critical features and functionalities.
Document expected deliverables, such as detailed test plans, scripts, and
reports.
Use dbt to build tests that ensures the ETL process is working as intended
Automate the common manual testing done by the QA through creating macros
in dbt
Build and monitor automated system health checks
Collaborate with Enterprise Data Engineers to investigate root cause of issues
and suggest resolutions.
Orchestrate data testing solutions using airflow
Be able to support the team in doing releases
Develop and maintain test automation frameworks, integrating them with CI/CD
pipelines.
Collaborate effectively with developers to implement testing strategies at lower
levels, facilitating a "shift left" approach and promoting early defect detection.
Take ownership of application quality from requirements gathering through
development and testing, ensuring a high standard of product excellence
Qualification:
Strong SQL and data transformation skills
Experience in programming or scripting languages such as Python, C#, Java
JavaScript/TypeScript
Understanding of ETL/ELT process fundamentals
Experience in designing, developing, and maintaining robust and scalable test
automation frameworks such as Playwright, Selenium or Cypress
Experience in testing of data with tools such as PowerBI, DBT and Snowflake
(nice to have)
Experience with GitHub Actions or similar platforms for automating and
managing test workflows.
Technical Skills:
You are a proactive advocate for "shifting left", aiming to identify and address
defects earlier in the development lifecycle.
You are passionate about test automation and committed to continuously
improving testing processes.
You enjoy collaborating with your team members to build solutions which
improves the data quality within the data warehouse
You have a drive to automate processes that mainly focuses on ensuring data
quality and process rigidity
You have experience within data engineering.
You have experience working with relational databases and investigating root
cause of issues.
Your SQL and data transformation skills are a key skill of yours
You have an understanding of database management systems and scripting
Keyskills: Snowflake Selenium Automation Data Warehousing SQL Automation Testing
Saama Technologies is one of the largest pure-play business analytics solutions and services company in the industry. Based in Campbell, CA, Saama has over 21 years of history in implementing business analytics, big data, predictive analytics and data management solutions for global clients in life ...