Job Details

ID #44721452
State Minnesota
City Minneapolis / st paul
Job type Permanent
Salary USD $80,000 - $100,000 80000 - 100000
Source Capgemini America, Inc.
Showed 2022-08-09
Date 2022-07-29
Deadline 2022-09-27
Category Et cetera
Create resume

ETL Tester

Minnesota, Minneapolis / st paul, 55401 Minneapolis / st paul USA

Vacancy expired!

Job Title: ETL Tester

Location: Minneapolis, MN (2 days onsite must/ Hybrid)

Full Time

Job Overview:
  • 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
  • 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

Vacancy expired!

Subscribe Report job