W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    Hadoop & Big Data

  • Job Title:

    Hadoop

  • Location:

    Baltimore,MD

  • Duration:

    13 Months

  • Domain Exposure:

    IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

Responsibilities

The Integrated Data Repository Operations and Maintenance, National Level Repository Data Quality (IDR O&M NLR DQ) team has an opportunity for an ETL Developer. This position requires the individual to analyze Medicare claims data and other sources of information for inclusion in Data Warehouse. The IDR is a Teradata database and ETL is used to map data from source to the warehouse.

This position is for the Medicare Enterprise Services Development (ESD) Contract supporting the Integrated Data Repository Operations & Maintenance National Level Repository Data Quality (NLR). The mission of this contract is to support CMS in efforts to maintain the production Integrated Data Repository (Teradata Data Warehouse).

Key Responsibilities
  • Analyze new data sources for inclusion into the enterprise data warehouse;
  • Work with federal and contractor staff to identify ETL requirements;
  • Create and update Interface Control Documents (ICDs);
  • Create ETL Functional specifications that document source to target mappings;
  • Create new Informatica ETL streams for additional data sources. The likely sources, though not limited to only these, would be data from the Shared Systems, Providers systems, or Medicaid claims data;
  • Follow established CMS standards for implementing Informatica ETL on a IDR database. These standards include, but are not limited to, enforcing referential integrity and following purgatory requirements;
  • Collaborate and coordinate with the other contract Government Task Leads as directed by CMS;
  • ETL Utilizing IDR staging tables while following CMS standards.
  • Becomes knowledgeable on the IDR Data Model using Informatica ETL
  • Applies developed subject matter knowledge to solve common and complex data issues within established guidelines and recommends appropriate actions.
  • Works 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

Apply Now
Equal Opportunity Employer

DIGITAL TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DIGITAL TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DIGITAL TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract