View Our Website View All Jobs

IRS Junior ETL Developer | Active MBI Clearance Required

TriTech Enterprise Systems, Inc. is actively seeking a Junior ETL Developer. The Junior ETL developer is responsible for the development of ETL (Extract, Transform, and Load) code using Informatica tools. The candidate will design and develop ETL code to load large amounts of data from other IRS internal data sources to the Return Review Program (RRP).

The ideal candidate must have an active IRS Minimum Background Investigation (MBI) clearance and at least 2 years of experience with PostgreSQL and Informatica Mapping tools.

Status: Full Time (8:00 am - 5:00 pm)

General Background:
The key objective of RRP is to provide a unified system that is integrated into the IRS’s modernized Infrastructure for the detection of fraudulent returns and refund fraud schemes to ensure timely issuance of refunds and credits that are legally due to filers, while preventing issuance of refunds and credits that are not legally due to filers. 

Primary Work Location: Lanham, MD 20706


  • Design and develop ETL packages using Informatica tools. 
  • Support an Informatica based ETL solution.
  • Implement the coding of Informatica mappings for different stages of ETL.  Move staging table to the target table.
  • Design, code, and unit test ETL packages, triggers, stored procedures, views, and SQL transactions.
  • Understand and comply with development standards associated with the RRP SDLC to ensure consistency across the project.
  • Collaborate with subject matter experts, IBM team members, and other vendor teams.

Minimum Qualifications:

  • Current Active IRS Medium Risk MBI clearance
  • 2 years of PostgreSQL experience
  • 2 years of Informatica Power Center experience
  • 2 years of experience with ETL development using a diverse set of data sources
  • Advanced experience with Informatica Power Exchange including Control-M
  • Experience with data modeling concepts
  • Experience developmening, maintaining, and enhancing Informatica Mappings, Workflows, and processes (2 years)
  • Previous experience with Data Warehousing techniques that use Oracle, Linux, and IBM AIX                                                                                                                                           

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