1+ months

ETL Developer - AWS, Informatica, Teradata

Washington, DC 20004
Apply Now
Apply on the Company Site
Peraton Overview

Peraton drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the worlds leading mission capability integrator and transformative enterprise IT provider, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our 22,000 employees do the cant be done, solving the most daunting challenges facing our customers.

We are an Equal Opportunity/Affirmative Action Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state, or local law.

As a government contractor, Peraton abides by the following provision

Pay Transparency Nondiscrimination 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 the 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 contractors legal duty to furnish information. 41 CFR 60-1.35(c).


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, Teradata;
  • Experience with SQL, Unix scripts, Python required;
  • 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;
  • Knowledge of AWS, Informatica DEI, DataBricks, and Snowflake extremely helpful
  • IDR experience a plus
  • US Citizen

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


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.


Peraton has an immediate need in our Health Payer Segment for an ETL Developer to support the Centers for Medicare and Medicaid Services (CMS) Integrated Data Repository (IDR). The position is remote although a location close to Baltimore would be helpful. 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.

The Integrated Data Repository (IDR) is the centerpiece of CMS Enterprise Data Warehouse Strategy. The IDR responds to the Agencys 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 on-prem Teradata Enterprise Data Warehouse that is currently migrating to an AWS Snowflake Cloud Data Warehouse.

Position Overview: This position is for the CIO-SP3 Contract supporting the Integrated Data Repository Operations & Maintenance task order. The position requires the individual to analyze Medicare claims data and other sources of information for inclusion in Data Warehouse. It also requires ETL design, development and unit testing in support of Cloud migration and general ETL maintenance. The mission of this contract is to support CMS in efforts to maintain the Integrated Data Repository.

Key Responsibilities
  • Migrate ETL from on-prem Informatica to the cloud using Informatica DEI; convert Teradata BTEQ scripts to Python/SQL for execution in DEI;
  • 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;
  • 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

For Colorado Residents
Salary Minimum: $97,760.00 Salary Maximum:$209,019.20 The estimate displayed represents the typical salary range for this position, and is just one component of Peraton's total compensation package for employees. Other rewards may include annual bonuses, short- and long-term incentives, and program-specific awards. In addition, Peraton provides a variety of benefits to employees.


  • Information Technology
Posted: 2021-06-29 Expires: 2023-10-01

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:

ETL Developer - AWS, Informatica, Teradata

Washington, DC 20004

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast