ETL Tester

About the Role:

Title : Data QA/ ETL Tester

Job Summary:

5 to 10 years of experience in Data/ETL/Datawarehouse Testing.
Strong experience in Control-M tool, or experience in any other scheduling tools .
Experience in writing SQL queries, data modeling and analytical skills on large data sets.
Prior experience executing, debugging and leading RCA in failures on control jobs.
Strong expertise in SQL Server, handling all the SQL objects.
Strong understanding of End-to-End data warehousing systems from Data modeling to Reporting
Experience in Informatica preferably, or experience in any ETL tool and knowledge in Informatica
Experience in Agile Project are preferred.
Knowledge or experience in IDQ and Tableau is an added advantage.
Execute workflows in informatica and debug and do RCA in failures are found.
Experience in preparing the Test artifacts needed for project delivery.
Experience in working with Business and UAT for demo of Test scenarios.
Experience in working with offshore and delegate the work properly on day to day basis.

Requirements

5-8 Year of ETL Testing Experience in Large Data warehouses.
Ability to understand the scope of the work and ask clarifications and escalate to the right leads in case of issues/delays
Advanced SQL skills. Including complex PL/SQL coding skills.
Should have prior experience working with Control-M.
Prior experience working/ troubleshooting Control M
Proved track record creating complex PL/SQL scripts.
Prior Experience in creating testing artifacts like Test Plan, Test Strategy, RTM, Defect Report and Test Closure.
Prior experience as a data tester. Experienced in preparing test plans and executing test case.
Prior Experience in working with Business/ UAT /Offshore.

Location: Local to Dallas.