• US Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 28th Sep 2022

Candidate should have multiple years of ETL testing experience

Excellent skills on working with database queries writing complex queries which include multiple joins and conditional statements updating existing queries written by other tester understanding existing code in Stored procedures / DB Views Should know how to work with batch logic like soft deletes / timestamps / current record vs historical records, how to use foreign keys and surrogate keys.

Ability to understand data mappings in mapping documents and ask questions if there are any.

Candidate should have worked on batch feeds / Data warehouse updates.

Ability to use CA Workload or any other job scheduling / batch job management tool will be an advantage.

Ability to use Informatica or SSIS or Wherescape or any other tool will be an added advantage.

Understand look ups, transformation logic provided in the design documents and ask questions if there are any.

Ability to engage and discuss with data architects / data developers, ask questions and get the information required.

Prior experience with an ETL automation tool like Query Surge / any other will be an added advantage.

Candidate will be expected to learn Automation and deliver if he does not have prior experience with Query Surge.

Candidate should be a quick learner and ready to take new challenges.

Requirements:

Excellent communication skills (verbal and written) Excellent collaboration skills, building relationships with the business and development team.

Excellent analytical skills, must be able to dig deep and understand stand the strategy.

Lead the QA efforts for planning, writing test cases and test execution along with status reports. Coordinate / collaborate automation solutions.

Create SQL scripts with test cases