2024-7333_QA Automation Engineer

AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.

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.

• 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

Required Skills/Experience

• 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.
• 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.

Desired Skills/Experience

• Understanding of ETL/ELT process fundamentals
• Experience in dbt, snowflake, airflow 

• Required knowledge & skills would typically be acquired through a bachelor’s degree in computer science or related field.
• Experienced developers with at least 3-6 years in software development