Share this Job

IT Quality Analyst Senior | Hybrid

Job Level:  Professional
Location: 

Minneapolis, MN, US, 55416-1297

Available until: 
Area of Expertise:  IT & Tech Engineering
Unit:  Allianz US Life
Employing Entity:  Allianz Life Insurance Company
Job Type:  Full-Time
Remote Job:  Not applicable
Employment Type:  Permanent
ID:  13179

 

At Allianz Life, we are driven by our mission – we secure your future – and by our common goal of caring for tomorrow. We care for our employees by promoting an inclusive culture where everyone has the opportunity to grow and be rewarded for their success. We care for our customers by creating new products that help them protect their families and pursue their retirement goals. We care for our community by giving time, resources, and donations. And we care for the future by supporting sustainability, protecting the local environment, and promoting societal equity.

 

What you do:

 

Responsible for test case creation and test execution for assigned projects. Coordinates and collaborates with QA Lead and Project team and contribute to successful delivery of projects in given timeline. Contributes to the overall uplift of the QA capability. May lead small to mid-size projects of diverse scope across functional areas or multiple systems. Leads and mentors QA resources, as appropriate.

 

A successful candidate will have background in:

 

  • 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 the strategy
  • Experience working in Agile / fast paced environment
  • Experience in Scrum methodology
  • Participate the QA efforts for planning, writing test cases, test execution along with participation in scrum calls, sprint planning, backlog refinement, demos and retrospectives
  • Create / collaborate in finding automation solutions

 

What you bring:

 

Candidate should have at least 3 years of experience in ETL testing with an overall experience of 5 or more years in IT

  • 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.

 

At Allianz Life, we’re proud to provide a benefits package that supports the True Balance of our employees and their families. We offer a choice of comprehensive medical and dental plan options, a generous time off plan and an outstanding 401(k) company match. Plus, our employees enjoy an award-winning campus with an array of discounted amenities, including an onsite health center, child development center, fitness facility, convenience store and two cafeterias. Our employees and leaders take an active role in shaping our culture through our Employee Resource Groups, whose activities and advocacy contribute to an environment that welcomes, includes and celebrates diversity. Our generous benefits, campus amenities and inclusive, engaged culture are among the many reasons we’re routinely recognized as a top workplace employer.