7 hours

Teradata - Informatica Developer

Washington, DC 20004
Apply Now
Apply on the Company Site
Business Group Highlights


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.


The Integrated Data Repository Operations and Maintenance (IDR O&M) team has an opportunity for an Extract/Transform/Load (ETL) Developer to support our contract. The 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 CIO-SP3 Contract supporting the Integrated Data Repository Operations & Maintenance task order. The mission of this contract is to support CMS in efforts to maintain the Integrated Data Repository.

The IDR is the centerpiece of CMS Enterprise Data Warehouse strategy and responds to the agencys critical need to have an integrated data environment that contains Medicare and Medicaid claims as well as beneficiary, provider, and health plan data in support of data analytics. The IDR is the largest government Teradata database in the world it is currently a one Petabyte Teradata system complimented by a two petabyte Hadoop system with 667 usable terabytes serving over 2,500 users.


  • Analyze new data sources for inclusion into the enterprise data warehouse;
  • Work with federal and contractor staff to identify ETL (extract, transform, load) 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 such as the Shared Systems, Providers systems, or other claims related data;
  • Follow established CMS standards for implementing Informatica ETL on an 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.
  • Become knowledgeable on the IDR Data Model
  • Apply developed subject matter knowledge to solve common and complex data issues within established guidelines and recommends appropriate actions.
  • Work on problems / projects of diverse complexity and scope.
  • Exercise independent judgment within generally defined policies and practices to identify and select a solution.
  • Utilize strong proven analytical ability and ability to solve problems independently


Requires 12 to 15 years with BS/BA or 10 to 13 years with MS/MA or 7 to 9 years with Ph.D.


  • Experience with developing ETL streams using Informatica and Teradata;
  • Experience with push down functionality of Informatica to maximize performance;
  • Solid investigative skills to find root cause for ETL problems;
  • Strong data analytical skills;
  • Ability to identify and create detailed requirements;
  • Ability to create ETL specifications and create data mappings;
  • Ability to collaborate and coordinate with other contract Government resources;
  • Good understanding of IDR processes;
  • Solid understanding of production IDR ETL streams.
  • Knowledge of SQL and Unix required, Teradata is the underlying database.
  • US Citizen

Essential functions:

  • Excellent organizational and communication skills
  • Ability to attend meetings, training, and conferences.
  • Can work remotely but must have high speed internet access and voice mail

About Perspecta

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 sectorfrom investigative services and IT strategy to systems work and next-generation engineering.

Our promise is simple: never stop solving our nations 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.

Email this job to a friendRefer
Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

As a government contractor, Perspecta abides by the following provision
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)


  • Information Technology
Posted: 2020-04-07 Expires: 2020-05-07

With offerings in mission services, digital transformation and enterprise operations, our team of 14,000 engineers, analysts, investigators and architects work tirelessly to create innovative solutions. We have the expertise and experience not only to devise solutions, but to execute on them successfully.

Sponsored by:
ADP Logo

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Teradata - Informatica Developer

Washington, DC 20004

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast