Job Description
Role: ETL Testing Engineer
Experience range: 5-10 years
Location: Bangalore (WALK-IN DRIVE IN Bangalore on 24th Jan)
Job description:
Min 8 to 10 yrs of Exp in ETL Testing.
1. SQL - Expert level of knowledge in core concepts of SQL and query.
2. Lead and mentor a team of ETL testers, providing technical guidance, training, and support in ETL tools, SQL, and test automation frameworks.
3. Create and review complex test cases, test scripts, and test data for ETL processes.
4. ETL Automation - Experience in Datagap, Good to have experience in tools like Informatica, Talend and Ab initio.
5. Execute test cases, validate data transformations, and ensure data accuracy and consistency across source and target systems
6. Experience in query optimization, stored procedures/views and functions.
7. Strong familiarity of data warehouse projects and data modeling.
8. Understanding of BI concepts - OLAP vs OLTP and deploying the applications on cloud servers.
9. Preferably good understanding of Design, Development, and enhancement of SQL server DW using tools (SSIS, SSMS, Power BI/Cognos/Informatica, etc.)
10. Develop and maintain ETL test automation frameworks to enhance testing efficiency and coverage.
11. Integrate automated tests into the CI/CD pipeline to ensure continuous validation of ETL processes.
12. Azure Dev Ops/JIRA - Hands on experience on any test management tools preferably ADO or JIRA.
Experience range: 5-10 years
Location: Bangalore (WALK-IN DRIVE IN Bangalore on 24th Jan)
Job description:
Min 8 to 10 yrs of Exp in ETL Testing.
1. SQL - Expert level of knowledge in core concepts of SQL and query.
2. Lead and mentor a team of ETL testers, providing technical guidance, training, and support in ETL tools, SQL, and test automation frameworks.
3. Create and review complex test cases, test scripts, and test data for ETL processes.
4. ETL Automation - Experience in Datagap, Good to have experience in tools like Informatica, Talend and Ab initio.
5. Execute test cases, validate data transformations, and ensure data accuracy and consistency across source and target systems
6. Experience in query optimization, stored procedures/views and functions.
7. Strong familiarity of data warehouse projects and data modeling.
8. Understanding of BI concepts - OLAP vs OLTP and deploying the applications on cloud servers.
9. Preferably good understanding of Design, Development, and enhancement of SQL server DW using tools (SSIS, SSMS, Power BI/Cognos/Informatica, etc.)
10. Develop and maintain ETL test automation frameworks to enhance testing efficiency and coverage.
11. Integrate automated tests into the CI/CD pipeline to ensure continuous validation of ETL processes.
12. Azure Dev Ops/JIRA - Hands on experience on any test management tools preferably ADO or JIRA.
Apply for this Position
Ready to join ? Click the button below to submit your application.
Submit Application