Data Automation Engineer (4-9 Yrs, Pune, Coimbatore, Chennai)

Job Description

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. 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 ensure 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 the 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