Job Details

ID #41245377
State Minnesota
City Minneapolis / st paul
Job type Permanent
Salary USD $80,000 - $100,000 80000 - 100000
Source Capgemini America, Inc.
Showed 2022-05-20
Date 2022-05-19
Deadline 2022-07-18
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

Full Time

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

Vacancy expired!

Subscribe Report job