Database Tester

Health

The Health group provides solutions to help government healthcare agencies lower administrative costs, reduce fraud and abuse, and improve the quality of services for individuals. We also provide analytics that combine clinical knowledge with big data technology and techniques to transform petabytes of data into meaningful solutions for our customers.

Perspecta has an immediate need in our Health Payer Segment for a Cloud Database Tester to support the Centers for Medicare and Medicaid Services (CMS) Integrated Data Repository (IDR) O&M Contract. The position location is Washington DC., Camp Hill, PA or Baltimore, MD. Ability to achieve Public Trust Clearance is required. Must be a US Citizen or a Green Card Holder who has worked in the US three out of the past five years. Candidate must be able to drive to the CMS client site in Baltimore, MD for occasional meetings.

The Integrated Data Repository (IDR) is the centerpiece of CMS’ Enterprise Data Warehouse Strategy. The IDR responds to the Agency’s critical need to have an integrated data environment that contains Medicare and Medicaid data (e.g. claims, beneficiary, provider, and plan data). The underlying technology of the IDR is an integrated Hadoop and Teradata Enterprise Data Warehouse. It supports the massive volumes of data associated with CMS’ program benefits. This cloud migration will include migrating IDR data streams, setting up the IDR Cloud Data Warehouse, and establishing an Operations and Maintenance plan.

POSITION OVERVIEW: Tester/Developer role duties include supporting various development and maintenance activities following processes/standards/architecture using Python/Informatica skills. Activities include gathering requirements, developing, implementing, managing, monitoring, and maintaining IDR Streams. Multiple streams will be migrated, requiring python development for building code in the Cloud and Informatica development for creating workflows. Developers will provide technical expertise on cloud cluster computing techniques and technologies and expert advice to the program. Experience in Spark/Scala/Python based solutions and expertise in benchmarking/fine tuning/troubleshooting these solutions. They will assist customers with data integration and migration efforts. Testing activities include creating testing plans, testing new cloud ETL processes and producing results comparison towards signoffs. Responsible for verifying code replatformed from Informatica scripts, Unix scripts, Bteq scripts, Cobol Teradata code. Testers will test Python code in the Cloud and informatica workflows.

Key Responsibilities

• Applies Database tools and techniques to build code, test, troubleshoot Datasets in Cloud.
• Applies subject matter knowledge to solve complex data issues within established guidelines and recommends appropriate actions
• Supports Cloud Migration projects, gathering requirements, developing, testing, implementing, and monitoring IDR Streams
• Work with federal and contractor staff to support the Cloud Migration
• Follow established CMS standards for implementing Cloud configurations.
• Collaborate and coordinate with the other contract Government Task Leads as directed by CMS
• Become knowledgeable on the IDR Data Model
• Work on problems / projects of diverse complexity and scope
• Exercises independent judgment within generally defined policies and practices to identify and select a solution
• Strong proven analytical ability and ability to solve problems independently

Qualifications:

• BS with 10-12 years of experience, MS with 8-10 years of experience and PhD with 5-7 years of experience required
• Experience Testing and Maintaining Database Code, such as SQL, Stored procedures in any database
• Experience migrating code from one database to another database
• Experience in coding using languages such as Python or spark or Scala
• Experience in Informatica and RDBMS (preferably Teradata)
• Experience coding SQL and Unix required
• Experience with a Cloud Data warehouse tools, such as Redshift, Databricks, Snowflake, is beneficial
• Experience testing in a large data warehouse environment
• Excellent investigative skills to find root cause for ETL problems
• Strong data analytical skills
• Ability to identify and create detailed requirements
• Ability to create ETL design specifications and create data mappings.
• Ability to collaborate and coordinate with other contract Government resources.
• Industry experience a plus (Medicare, Medicaid, Healthcare or commercial insurance).
  #LI-SG2

What matters to our nation, is what matters to us. At Perspecta, everything we do, from conducting innovative research to cultivating strong relationships, supports one imperative: ensuring that your work succeeds. Our company was formed to bring a broad array of capabilities to all parts of the public sector—from investigative services and IT strategy to systems work and next-generation engineering.

Our promise is simple: never stop solving our nation’s most complex challenges. And with a workforce of approximately 14,000, more than 48 percent of which is cleared, we have been trusted to just that, as a partner of choice across the entire sector.

Perspecta is an AA/EEO Employer - Minorities/Women/Veterans/Disabled and other protected categories.