View Our Website View All Jobs

IRS ETL Informatica Developer - Active MBI Clearance Required

TriTech Enterprise Systems, Inc. is actively seeking a skilled ETL Informatica Developer. This individual will act as the ETL Developer for the CDR/IRDB project and will be responsible for developing ETL application using Informatica for high volume data. 

Contract: Total Information Processing Support Services-4 (TIPSS-4)

Client: IBM/IRS

Status: Full Time (40+ hours)

Work Hours: 8:00am – 5:00pm

Primary Work Location: Lanham, MD 20706

Clearance: IRS Minimum Background Investigation (MBI) clearance is required

Citizenship: US Citizen or Permanent Resident

NOTE: This position is a combination remote/work at home and work at the IRS office. Depending on the needs of the business, the worker may need to work at the IRS building in New Carrollton, MD 50% of the time. This can vary from week to week.

Task Description:

The Internal Revenue Service (IRS) will administer the various tax provisions included in the Patient Protection and Affordable Care Act (PPACA), many of which either add to or amend the tax code, and several that require the IRS to build new tax administration processes that do not currently exist. The IRS Affordable Care Act (ACA) Coverage Data Repository (CDR) and Information Returns Database (IRDB) project will create a data repository to serve as the backbone for more than 16 other ACA projects. This will include acting as the operational database for ACA projects; storing data from ACA projects; and making data available to IRS systems, Health and Human Services (HHS) and other external organizations.

Summary of Position:

This position requires demonstrated experience using the Informatica Suite of tools including Power Center, B2B, and Power in an Agile/Scrum environment. This position will develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data loading tasks in support of CDR Data Repository from IRS and non-IRS data sources. The Database environment for the project is Oracle and for the data sources, it will vary depending upon the data source (XML, flat file, Relational Databases).  Prior experience with SQL on Oracle databases will be required.


  1. Develop new ETL application using Informatica Power Center to load large amount of data from multiple data sources into CDR/IRDB Repository using Oracle database. – 40%
  2. Develop Data Integration procedures using Informatica suite of tools including B2B and Power Exchange. – 10%
  3. Develop SQL programs and Stored Procedures as required for the ETL processes and Data Integration activities. – 10%
  4. Provide support to technical team, write the necessary required documentation as per the IRS development methodology for ETL processes, and Develop unit test plan, test cases and resolve ETL related test problems. – 20%
  5. Coordinate, plan, communicate, develop and review client presentations and documentation required under the IRS Enterprise Lifecycle. – 10%
  6. Work with the ACA application teams to understand the nature of ETL interfaces to CDR and the architecture of the application. Design the appropriate interface interactions for each, while being cognizant of opportunities for reuse and standardization of interactions across applications. – 10%

Required Skills:

  1. Current Active IRS Medium Risk MBI clearance
  2. Demonstrated experience in designing ETL processes using Informatica for high-volume, complex data environments in an Agile environment– 10 years
  3. Demonstrated Strong experience using the Informatica Suite of Tools - Power Center version 8 or higher, Power Exchange version 8 or higher, B2B Data Transformation – 7 years
  4. Strong experience in the design and development of mappings, transformations, sessions and workflows in PowerCenter – 7 years
  5. Strong experience in SQL in the Oracle environment – 10 years
  6. Data warehouse data modeling experience – 3 years

Nice To Have Skills:

  1. IRS system and data knowledge experience
  2. Healthcare system experience
  3. Massively parallel data loading experience
  4. Ability to create technical documentation content and templates


Benefits Overview: TriTech offers a competitive benefits package to all eligible employees.


TriTech is an Equal Opportunity Employer


Read More

Apply for this position

Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file