Saxon - Senior ETL Tester - Datawarehouse Testing (7-10 yrs)

Job Description :

Core skills needed : Main important areas SQL SSIS/ETL/SSRS/POWERBI/Data warehousing concepts.

Essential Job Functions :

To perform this job successfully, an individual must be able to satisfactorily perform each essential function listed below :

- 7-9+ Years of Software QA experience on enterprise level applications which includes ETL, Database & DWH Testing.

- Sound experience and knowledge of SSIS, SSRS, SSAS & MSSQL experience (intermediate or senior level).

- Strong in SQL, RDBMS, and DW concepts & Proven experience in testing ETL and DB solutions.

- Experience in validating Reports/Dashboards on tools like MS Power BI etc.

- 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.

- Knowledge of data models and entity relationship diagrams.

- Demonstrate a fundamental understanding of data warehouses, data marts, and BI.

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

- Should have adequate experience & clear understanding of data warehouse & data mart testing.

- Identification and Test Data Preparation Techniques.

- Thorough knowledge of STLC, Test Cases, Defect Life Cycle etc.

- Proficiency with Test Case Preparation and Execution.

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

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

- Defect tracking tools experience (i.e. ALM, VSO/TFS, Jira etc.)

- Review functional and technical solutions to develop test plans and scripts for various data quality checks.

You're a Great Fit If You Have :

- Must have the ability to multi-task & adapt quickly to changes, maintaining urgency in completing assigned tasks.

- Should be detail oriented with analytical mind set.

- Good communication skills with a confident personality so that can gather requirement from onsite team as well as demonstrate the output to other members of the team.

- Ability to communicate well to both technical and non-technical staff.

- Excellent problem solving & analytical skills, able to handle challenging situations and act appropriately.

- Excellent learning skills must learn and guide other team members on their knowledge.

- Should be a self-starter; takes responsibility and ownership and is self-driven.

- Ability to work independently with minimal supervision as well as ability to work within a team.

- Good team player; commitment to high-quality output and service.

- Motivate and challenge self for continued innovation.

- Great attention to detail with a result-driven test approach.