Software Development Engineer - Test - ETL/Datawarehouse Testing (6-9 yrs)

We are seeking a skilled and detail-oriented SDET Engineer with a strong background in data systems to join our team. The ideal candidate will be responsible for developing and maintaining automated testing frameworks, ensuring the accuracy, reliability, and quality of complex data pipelines and systems. This role offers an exciting opportunity to collaborate with cross-functional teams, define QA best practices, and drive excellence in data integrity and process automation.

Roles and Responsibilities :

Automation Process Setup & Standardization :

- Propose, establish, and standardize processes for test automation.

- Define and document QA best practices and strategies to ensure quality delivery of data systems.

Framework Development & Tool Analysis :

- Develop and enhance automation frameworks, including those supporting ETL processes.

- Analyze and evaluate various tools to recommend the best feasible options for automation.

Collaboration & Roadmap Alignment :

- Work closely with Data Engineers, Data Analysts, and Data Product Owners to align testing activities with the product technical roadmap.

- Contribute to discussions on data platform improvements and technical decision-making.

Test Case & Script Development :

- Design, create, and document detailed test cases.

- Prepare and maintain automated test scripts for data systems.

Execution & Defect Tracking :

- Execute QA/UAT testing activities and track defects to ensure timely resolutions.

- Perform analysis of issues to identify root causes and recommend resolutions.

Automation Integration :

- Integrate automated workflows with CI/CD pipelines for continuous testing.

- Implement workflow automation for data systems, ensuring seamless orchestration.

Required Skills & Experience :

Data Platform & Tools Expertise :

- Hands-on experience working with AWS, Redshift, and Athena.

- Prior exposure to Data Lakehouse architectures and best practices.

ETL & Database Skills :

- Strong knowledge of SQL and ETL processes for data analysis and troubleshooting.

Automation Frameworks :

- Proficiency in QA automation using frameworks such as Data-Driven Testing and Behavior-Driven Development (BDD).

- Strong scripting skills in Python for automation tasks.

Workflow Automation & Orchestration:

- Experience with CI/CD pipelines for data systems.

- Familiarity with data orchestration tools like Apache Airflow.

Problem-Solving & Analysis :

- Excellent analytical and problem-solving skills, with attention to detail.

Collaboration & Communication :

- Ability to work collectively with cross-functional teams, fostering a collaborative environment