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
Rahul Sharma
IT Technical Recruiter
Phone : 321-323-1079
Email: *************
Gtalk: *************
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Stellent IT by 2x