4 days old

ETL Informatica Developer

Rancho Cordova, CA 95670
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.


Perspecta is seeking an ETL Informatica Developer with our Health team. The Information Warehouse (IW) ETL Developer will be responsible for the processes required to extract, transform, and move data and metadata so they can be loaded into the data warehouse. The developer must understand and analyze what Health Net Federal Services (HNFS) would like to accomplish with its data and designs the best possible ETL process around those goals. The following HNFS Information Warehouse components will be available to support this position:
Informatica PowerCenter V10 Extract Transform Load (ETL) tool
Business Objects XI 4.x Data Access Reporting tool
SAS 9.4 (Office analytics, Access Interface to Teradata)
Teradata database V 16.10
Microsoft SQL Server database
The Informtica developer should have extensive experience supporting ETL in similar environments.
Typical Duties:
Assist development teams to maintain all data sources and data storage options.
Coordinate with application team and develop all ETL processes.
Provide an efficient interface with brand for all processes across various platforms.
Administer all requests and analyze issues and provide efficient resolution for same.
Design all program specifications and perform required tests in same.
Prepare codes for all modules according to require specification and client requirements and prepare all required test plans.
Design all programs and systems and associate documentation for same.
Prepare all program and system implementation for all informatics programs.
Monitor all production issues and inquiries and provide efficient resolution for same.
Evaluate all functional requirements and map documents and perform troubleshoot on all development processes.
Collaborate with application groups to prepare effective solutions for all programs.
Documents all technical specifications and associate project deliverables.
Design all test cases to provide support to all systems and perform unit tests.


Requires 5 to 8 years with BS/BA or 3 to 5 years with MS/MA or 0 to 2 years with PhD.

5 or more years of ETL experience with Informatica PowerCenter is required; at least 1 year with version 9.x or 10.
Strong experience with SQL and Teradata databases, preferably version 16.10.
Strong experience with Oracle 12 or higher.
Strong UNIX and shell scripting experience is required.
3+ years of experience with SQL, PL/SQL, and Teradata Stored Procedural Language (SPL)
2+ years of experience with Teradata Data Warehouse Architecture
Knowledge of data warehousing, data governance processes, data quality processes, testing methodologies, reporting tools, application development
Multi-platform and multi-system integration experience.
Demonstrated record of success with problem-solving skills, creativity, and the ability to manage multiple priorities
Proficiency with metadata, data modeling and data quality tools an asset.
Working knowledge of Information Management, Business Intelligence, Health Care Analytics a plus.
Ability to analyze business cases, extract requirements and understand business needs

Must be a US citizen, level of trust security clearance is required.
Position can be located remotely (within USA) with travel up to 75%

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-03-25 Expires: 2020-04-24

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.

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 Informatica Developer

Rancho Cordova, CA 95670

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast