Etl Tester

Servion; Pune District, Chennai; Hybrid; INR 2,500,000 - 3,500,000; Full time

Job summary

Servion is seeking a senior ETL/Big Data tester with 8+ years of experience to drive automated data validation across complex pipelines. You will ensure data quality from source systems through the data warehouse stack.

Responsibilities include validating migrations from SQL/Oracle to Snowflake or Postgres, and using ETL tools (SSIS, Informatica, Talend) with Airflow while building robust CI/CD for testing.

Qualifications

• 8+ years of ETL/Big Data manual and automated testing experience.
• Experience migrating data from SQL/Oracle to Snowflake or Postgres.
• Proficient in SQL, Python and PySpark in Jupyter Notebook.
• Hands-on with data automation and CI/CD for tests.
• Experience with AWS S3, Jira, Tableau/Superset is preferred.

Responsibilities

• Design and implement automated data validation frameworks.
• Collaborate with data engineers to validate data quality.
• Develop and maintain CI/CD pipelines for test automation.
• Validate data migrations and report issues.

Skills

ETL

Big Data

Manual Testing

Automation Testing

SQL

Python

PySpark

Airflow

SSIS

Informatica

Talend

Snowflake

Postgres

Tableau

Superset

Jira

Tools

AWS S3

MinIO

Airflow

Snowflake

Postgres

Tableau

Superset

Jira

Job description

Job Description :

• Strong Background of ETL/Bigdata Manual and Automation Testing(8+ years)
• Good understanding of Data warehouse concepts Fact / Dimensional modeling , Data Vault 2.0 modeling
• Having experience in migration of Data related projects , like validation of data from SQL / Oracle to modern databases like Snowflake / Postgres , etc
• Nice to have an experience in ETL Orchestration tools like Microsoft SSIS , Informatica , Talend , Apache-Airflow , etc and understanding its task flow .
• Proficiency in data automation using python, Pytest, BDD, Robot Framework, etc..
• Expertise in writing SQL, Python and PySpark queries in Jupyter Notebook .
• Should have hands on experience to implement On-prem and cloud data connections to automate the data validations between heterogeneous sources.
• Should have hands on experience in build automation robust framework to read Rest API's, jsons, text, and CSV files and compare against RDBMS.
• implement and maintain CI/CD pipelines for automated testing and reporting.
• Should have worked on AWS S3, Minio, Airflow, Snowflake, Postgres, Tableau, SuperSet, and Jira.
• Should be team player and supportive to the team members to upskill on automation implementation and maintenance.
• Preferred to have financial domain knowledge

Regards,

Aravindhan

9360366455