Job Details

ID #49581944
State District of Columbia
City Washington
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source Connect Resource Group
Showed 2023-03-29
Date 2023-03-17
Deadline 2023-05-16
Category Healthcare
Create resume

Tester with strong Snowflake, Oracle, SQL

District of Columbia, Washington 00000 Washington USA

Vacancy expired!

Intermediate C2C Health Insurance tester (cloud migrations)

Direct client - CareFirst BCBS

Immediate 6 mo contract (with high probability to multiyear extension).Location – Mostly REMOTE with an in-person meeting in

Washington,

DC office about once a month. (travel to meeting is not reimbursed so candidates close to DC are preferred)

Any work Visa

– H-1B, US, etc. Duration – 6+ months (high probability for extension)

Project: testing

both front and back end transitions of Healthcare EDI transaction (837 & 835) data to the cloud. Back end – moving

Oracle, Cloudera to

Snowflake (data lake) Front end – moving Angular JS, JavaScript to AWS Cloud

Both Manual and Automation testing (BDD, Cucumber, Selenium, Java)

Responsibilities:
  • Back end - Testing transition from Oracle database & Cloudera to Snowflake (data lake) to ensure that all EDI transactions that are posting to Snowflake are saved on the new system.
  • Front end - Testing transition to AWS Cloud. Experience testing Angular JS, JavaScript is essential.
  • Both Manual and Automation testing. Experience with BDD / Cucumber / Selenium / Java. This hiring manager tends to select Testers who started their careers as Java developers and moved into testing. • Manipulation of 837/835 EDI /XML files to generate a wide variety of valid claims• Write complex SQL queries for retrieval of required from multi-database environment. (Strong knowledge of Oracle database required).• Ability to execute all phases of the testing process in a multi-server environment. Requires the ability to define and maintain testing environments and/or configuration.• Hands on UNIX knowledge to write and execute queries would be preferred.
  • Ability to write scripts to run queries in an automated fashion would be a plus.

Requirements:
  • 5+ years of testing experience including front-end, back-end, database, manual, automation, rules-based, testing• Strong

    SQL,

    Oracle,

    Snowflake skills and experience. Ability to

    write complex SQL queries.
  • Experience database testing of migrations of data from

    data warehouse to

    Snowflake.
  • Experience with BDD / Cucumber / Selenium / Java and rule based engine testing is ESSENTIAL.

This hiring manager tends to select Testers who started their careers as true Java developers and moved into testing.
  • Some experience and knowledge of Claim Adjudication process – including knowledge of 837/835 EDI formats & ability to manipulate 837/835 EDI /XML files to generate a wide variety of valid claims
  • Experience with very large, high-volume transaction systems, MQ/JMS Messaging, web services, and GUI development (Angular JS)• 2+ years of

    relational database experience including generating complex queries, setting up database connections, and automating query processing.
Experience with databases testing in a data warehouse environment a plus.• 3+ years of testing experience with strong background in Software QA and Testing in a

multi-server environment. • Experience in

SOATest including WSDL, XML, JSON and messaging clients. (JMS, MQ) Preferred• Experience with tools

like JIRA, ZEPHYR and Toad, Jenkins• Bachelor degree. Technical degree preferred

Vacancy expired!

Subscribe Report job