ETL Developer

Clearance Level
Software Development
Washington, District of Columbia

REQ#: G2019-67182

Public Trust: None
Requisition Type: Pipeline

GDIT is looking for an ETL Developer in Washington (D.C.) to join our team supporting the USPS.


The candidate will plan, manage, execute, and oversee varied data integration and data management enhancements, customizations, migrations within the AWS environment. Gather information with the customer to determine project parameters and specifications. Candidate will work collaboratively with stakeholders to provide technical oversight with respect to data integration. The candidate will perform extraction transformation loading (ETL) using Penthaho.

Responsibilities include, but are not limited to:

  • Develop and maintain Extract, Transform, and Load functions from Epic and other operational data sources into their respective target environments
  • Performance monitoring to ensure timely and quality delivery of data into AWS data storage environment such as S3
  • Serve as a data management subject matter expert focused on modeling and designing data integrations, transformations, and migrations from various sources
  • Validate that data standards are implemented across several interfaces with other applications
  • Design data integration and management software to automated imports, exports or transfers of data to one or more other systems using approved USCB ETL tools (e.g., Pentaho Data Integration 7.x)
  • Work with data owners to document data mappings and transformations to support effective downstream analytics and alerts
  • Make recommendations and advise on data refresh, optimization of data, data storage, and data integration among two or more systems
  • Collaborate with team to manage risk as it pertains to data, software, lifecycle management, software development methodologies, and data modeling
  • Develop test data as necessary to support testing.
  • Attend various meetings as subject matter expert for ETL

This program only accepts US citizens and/or Green Card Holders. The security clearance for this program requires the selected candidate to have resided in the US for the past five years. The selected candidate cannot have left the country for longer than 90 consecutive days and no more than 180 cumulative days.


Bachelor's Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.


5 years of related software development experience.


Mandatory Skills 

  1. Demonstrated experience in JAVA/J2EE development doing ETL work.
  2. Demonstrated with JavaScript/UI framework(s).
  3. Demonstrated experience with Spring and Hibernate or REST services.
  4. Experience with a data transformation tool such a Pentaho.
  5. Demonstrated experience working with and transforming XML, JSON, or CSV.
  6. Demonstrated experiencing working with and or authoring XML Schemas.
  7. Familiarity with AWS data storage environment such as S3.


Desired Skills

  1. Experience with code delivery mechanisms and code repositories (e.g. Subversion and/or Git).
  2. Experience with continuous delivery solutions, such as Hudson, Jenkins, or Puppet
  3. Experience in developing and maintaining applications in the Sponsor's environment and associated security processes.
  4. Experience developing in an Agile environment, including Scrum and user stories.
  5. Demonstrated experience developing and operating enterprise scale, web-based applications in the IC/DoD environments.
  6. Demonstrated experience working in a cross security domains environment.
  7. Demonstrated experience participating in Agile development teams.
  8. Familiarity with NoSQL environment and technologies.







" We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.

GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.