ETL Developer (Mid-Level)

Company: TriTech Enterprise Systems
Location: Lanham
Posted on: March 19, 2023

Job Description:

PLEASE NOTE:Current Active IRS Minimum Background Investigation MBI/ 58C Tier 2RS clearance required. Permanent Resident or U.S. Citizenship required for MBI/ 58C Tier 2RS.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 10% of the time and must be within a 2-hour commute time of DC area. This can vary from week to week. TriTech Enterprise System is seeking a "Mid-Level ETL Developer" to support the Internal Revenue Services (IRS), Affordable Care Act (ACA) project. 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.Task Description: This individual will act as the ETL Developer for the CDR/IRDB project and will be responsible for developing ETL application using Informatica. This position requires demonstrated experience using the Informatica Suite of tools including Power Center, Developer, and Power Exchange. This position will develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data loading tasks in support of CDR/IRDB 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. Prior experience with SQL on Oracle databases will be required. Duties:Job duty 1 - Develop new ETL application using Informatica Power Center to load large amount of data from multiple data sources into CDR Repository using Oracle database - 40%Job Duty 2 - Develop Data Integration procedures using Informatica suite of tools including Informatica Developer and Power Exchange - 10%Job duty 3- Develop SQL programs and Stored Procedures as required for the ETL processes and Data Integration activities - 10%Job Duty 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%Job duty 5- Coordinate, plan, communicate, develop, and review client presentations and documentation required under the IRS Enterprise Lifecycle - 10%Job Duty 6 - Work with the ACA application teams to understand the nature of ETL interfaces to CDR/IRDB 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/Level of Experience :Demonstrated experience in designing ETL processes using Informatica for high-volume, complex data environments - 5 yearsData warehouse data modeling experience - 3 yearsDemonstrated Strong experience using the Informatica Suite of Tools - Power Center version 10 or higher, Power Exchange, Informatica developer - 5 yearsStrong experience in the design and development of mappings, transformations, sessions and workflows in PowerCenter - 5 yearsStrong experience in SQL in the Oracle environment - 5 yearsActive IRS Medium Risk MBI clearance"Nice to have skills:IRS system and data knowledge experience Healthcare system experience Massively parallel database experience Ability to create technical documentation content and templatesTriTech is an Equal Opportunity Employer!

Keywords: TriTech Enterprise Systems, Washington DC , ETL Developer (Mid-Level), Other , Lanham, DC