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.
Business Group Highlights 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.
Position: Perspecta 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 or a 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 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 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.
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
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
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
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 Perspecta's total compensation package for employees. Other rewards may include annual bonuses, short- and long-term incentives, and program-specific awards. In addition, Perspecta provides a variety of benefits to employees. 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 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 do just that, as a partner of choice across the entire sector.
Perspecta is anAA/EEOEmployer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
As a government contractor, Perspecta 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 contractor's legal duty to furnish information. 41 CFR 60-1.35(c).