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
Click
here to apply!
|