View Our Website View All Jobs

IRS Mid-level ETL Developer | Active MBI Clearance Required

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

The ideal candidate must have at least 4 years of prior ETL experience using Informatica tools and an active IRS Minimum Background Investigation (MBI) clearance as well as the flexibility to work overtime, as needed, to include weekends, holidays, and off-hours.

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

Duties/Responsibilities:

  • Design and develop ETL packages using Informatica tools.  
  • Implement Informatica-based ETL solutions while fulfilling stringent performance requirements.
  • Develop and 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, SQL and 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:

  • 6 years of PostgreSQL experience
  • 6 years of experience with Informatica Power Center and associated SQL development
  • 6 years of experience with ETL development and processes using diverse data sources
  • Advanced experience with Informatica Power Exchange including Control-M
  • Experience with data modeling concepts
  • 4 years of experience developing, maintaining, and enhancing Informatica mappings, workflows, and processes
  • Previous experience with Data Warehousing techniques that use Oracle, Linux, and IBM AIX              

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

​TriTech is an Equal Opportunity Employer

Read More

Apply for this position

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

Paste your resume here or Attach resume file