JOB SUMMARY:
- The QA Automation Engineer is responsible for designing, developing, and executing automated testing solutions and test plans for Source System and Business Data Products, validating the integrity, accuracy, and consistency of enterprise data across multiple business domains.
- This role ensures the quality of data processed through ETL/ELT pipelines and data modeling scripts across platforms such as Oracle, SQL Server, and Snowflake.
- The engineer collaborates closely with data engineering, QA, and business teams to support scalable, reliable, and high-quality data delivery across the organization.
POSITION RESPONSIBILITIES:
- Design and develop reusable automated tests to validate data ingestion, transformation, and loading across Oracle, SQL Server, and Snowflake.
- Validate data integrity, completeness, schema conformity, and business logic across ETL/ELT pipelines, from raw landing zone to curated data products.
- Automate functional and regression testing for data models, stored procedures, and materialized views, leveraging Snowflake native features (e.g., streams, tasks, time travel).
- Maintain and enhance existing cross-platform test automation frameworks and reusable test suites, documenting test approaches in alignment with team standards.
- Utilize TestRail for Test Case Management: Design, document, and maintain test cases and test plans; track execution, report defects, and maintain traceability across automated and manual tests.
- Integrate automated tests into CI/CD workflows and validate data integrity during production releases, schema changes, and migrations.
- Implement data quality checks for critical pipelines to identify anomalies such as volume variances, schema changes, and business rule deviations.
- Partner with data engineers, data modelers, and analysts to define test criteria, provide early feedback on development tickets, and participate in code reviews.
- Define and expand the scope of test automation, contributing to the evolution of testing strategies and configurations.
- Actively participate in planning meetings, daily stand-ups, and demos to align testing efforts with project goals and timelines.
- Perform other job-related functions or tasks as assigned.
QUALIFICATIONS:
DEGREE TYPE:
FIELD(S) OF STUDY:
- Business Management, Computer Science, Industrial Engineering, or other related field of study; or any combination of relevant work experience and education.
EXPERIENCE:
- At least 3 to 5 years of experience in Software Quality Assurance testing and at least 2 years of experience in writing and maintaining test automation scripts.
COMPETENCIES & SKILLS:
- Strong expertise in quality assurance practices for enterprise data platforms, including the design of automated testing frameworks, validation of data pipelines, and risk-based testing strategies.
- Strong understanding of data governance, regulatory requirements, and compliance standards that impact enterprise data products.
- Proficiency with TestRail for test management, Snowflake capabilities that support data validation, and scripting or continuous integration and delivery tools.
- Strong analytical and problem-solving skills to quickly isolate defects, perform root cause analysis, and drive continuous process improvement.
CERTIFICATIONS & LICENSES:
- Excellent communication and collaboration skills, partnering closely with Product Owners, Delivery Coaches, Engineering teams, and business stakeholders to ensure test coverage evolves with changing data product objectives and compliance expectations.
