Description

We are seeking an experienced ETL Automation Tester with strong expertise in ETL testing, SQL, automation frameworks, and data validation. The ideal candidate should have experience in validating large-scale data warehouse solutions, developing automated test scripts, and ensuring data integrity across ETL pipelines. Experience in the Banking, Financial Services, or Asset Management domain is highly preferred.

Required Skills

• 5+ years of experience in ETL Testing and Data Warehouse Testing.
• Strong hands-on experience with SQL (complex queries, joins, stored procedures, CTEs, window functions).
• Experience in ETL tools such as Informatica PowerCenter, Talend, SSIS, DataStage, or similar.
• Hands-on experience in ETL Test Automation using Python, Java, Selenium (where applicable), or automation frameworks.
• Experience in validating data migration, transformation, and reconciliation.
• Strong understanding of Data Warehouse concepts (Fact & Dimension tables, Star Schema, Snowflake Schema).
• Experience working with relational databases such as Oracle, SQL Server, PostgreSQL, or Snowflake.
• Experience in API testing using Postman or REST Assured is an added advantage.
• Hands-on experience with CI/CD tools such as Jenkins, Azure DevOps, or GitLab.
• Knowledge of Agile/Scrum methodologies.
• Experience with defect management tools like JIRA and test management tools such as ALM or Zephyr.
• Good understanding of Unix/Linux commands.
• Excellent analytical, debugging, and communication skills

Key Skills

Education

Any Graduate