ETL Tester - Automation

Job Summary:

We are looking for an experienced ETL Automation Tester with 6 to 10 years of experience in data validation, ETL testing, automation, and database testing. The ideal candidate should have expertise in designing and executing automation test scripts for ETL processes, ensuring data accuracy, consistency, and quality across different data pipelines.

Key Responsibilities:

ETL Testing & Validation:

• Perform ETL testing to validate data movement from source to destination.
• Verify data completeness, transformation logic, and data integrity across different layers. Develop SQL queries for data validation and reconciliation.

Automation Testing:

• Design and implement automation frameworks for ETL testing.
• Develop automation test scripts using Python, Selenium, Java, or similar tools.
• Utilize tools like Informatica, Talend, SSIS, or any other ETL tool to validate the data pipeline.
• Automate data validation tasks using Selenium, PyTest, TestNG, or custom scripting.

Database Testing:

• Perform database testing for data warehouse solutions.
• Execute complex SQL queries, stored procedures, and performance tuning.
• Validate data integrity, consistency, referential integrity, and transformations.

Data Quality & Reporting:

• Implement data quality rules and validations to ensure correctness.
• Perform data profiling and generate reports for defects and inconsistencies.
• Work closely with Data Engineers and BI teams to ensure data accuracy.

CI/CD & DevOps Integration:

• Implement test automation in CI/CD pipelines using Jenkins, GitHub Actions, or Azure DevOps.
• Integrate automated test scripts with tools like JIRA, TestNG, or Cucumber.

Required Skills & Experience:

• 6-10 years of experience in ETL/Data Warehouse Testing.
• Strong SQL skills (Joins, Aggregations, Stored Procedures, Views).
• Hands-on experience with ETL tools (Informatica, SSIS, Talend, DataStage, etc.).
• Strong Knowledge in API Testing (Postman, Rest Assured).
• Experience in test automation frameworks (Selenium, TestNG, PyTest, Cucumber).
• Strong experience in Python/Java scripting for automation.
• Experience with Big Data Testing (Hadoop, Spark, Snowflake) is a plus.
• Hands-on experience with CI/CD tools (Jenkins, Git, Docker, Kubernetes).
• Strong analytical, problem-solving, and troubleshooting skills.

Preferred Qualifications:

Bachelor's/Master's degree in computer science, IT, or related field.

Interested candidate can share their CV to careers@minusculetechnologies.com or 8925815896, 6382901706