This site uses cookies. To find out more, see our Cookies Policy

ETL Software Developer w/Poly in College Park at General Dynamics Information Technology

Date Posted: 1/30/2019

Job Snapshot

Job Description

Researches, designs, develops and/or modifies enterprise-wide systems and/or applications software.

1. Participates in the design and coding of software products.

2. Performs systems modeling, simulation, and analysis.

3. Prepares comprehensive test plans and conducts tests.

4. Analyzes test results and recommends moderately complex corrections to more experienced software engineers.

5. Designs and develops compilers, assemblers, utility programs, and operating systems.

6. Advises hardware engineers on machine characteristics that affect software systems, such as storage capacity, processing speed, and input/output requirements.

7. Writes and updates technical documentation such as user manuals, system documentation, and training materials.

8. Troubleshoots problems and provides customer support for software operating system and application issues.

9. Maintains current knowledge of relevant technology as assigned.

10. Participates in special projects as required.

Job Requirements

2-5 years of related software development experience.

Position Description

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


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.

As a trusted systems integrator for more than 50 years, General Dynamics Information Technology provides information technology (IT), systems engineering, professional services and simulation and training to customers in the defense, federal civilian government, health, homeland security, intelligence, state and local government and commercial sectors. With approximately 32,000 professionals worldwide, the company delivers IT enterprise solutions, manages large-scale, mission-critical IT programs and provides mission support services. GDIT is an Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Individuals with Disabilities.