ETL Tester

Job Description

• 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 : Dallas TX

Preferred Skills:

• Data QA
  • ETL Tester
  • Informatica Powercenter
  • Control M
  • Banking
  • Financial