ETL Tester

HCL Hiring for ETL Testing role!!

Location-Bangalore/Chennai/Noida/Hyderabad

Experience-5 to 7 Years

Notice Period-Immediate to 45 Days

Mandatory Skills-

ETL/DWH Testing

Snowflake, Cloud-AWS Experience

SQL Query

Informatica

JD-

1. ETL QA experience on enterprise level applications which includes Data Warehouse Testing.

2. Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered.

3. Understanding of different databases like SSMS, Oracle, Workbench, Snowflake.

4. Should have hands on experience on Cloud(AWS/Azure).

5. Should have experience testing multiple test phases in medium to large projects.

6. Should have adequate experience and clear understanding of data warehouse and data mart testing.

7. Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test cases.

8. Experience in Test Management tools like HP ALM/JIRA.

9. Identification and Test Data Preparation Techniques.

10. Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc. Proficiency with Test Case Preparation and Execution.

11. Extensive exposure to Back-end/ETL Testing with high-level of SQL skills is required.

12. Possess experience in using Informatica suite of tools.

13. Should have exposure to large data sets and understand Data Quality Framework.