General Dynamics Information Technology ETL Software Engineer w/Poly in College Park, Maryland

Job Description

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

  1. Designs, develops, codes, tests, and debugs complex new software products, or makes significant enhancements to existing software.

  2. Researches and integrates design strategies, product specifications, development schedules, and user expectations into product capabilities.

  3. Resolves complex hardware/software compatibility and interface design considerations.

  4. Conducts investigations and tests of considerable complexity.

  5. Researches emerging technologies to determine impact on application execution.

  6. Provides input to staff involved in writing and updating technical documentation such as user manuals, system documentation, and training materials.

  7. Troubleshoots complex problems and provides customer support for software operating systems and application issues.

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

  9. Prepares reports on analyses, findings, and project progress.

  10. Provides guidance and work leadership to less-experienced software engineers.

  11. May serve as a technical team or task leader.

  12. Maintains current knowledge of relevant technology as assigned.

  13. Participates in special projects as required.


Bachelors Degree in Computer Science, Engineering or a related technical discipline, or the equivalent combination of education, technical training, or work/military experience.


8-10 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

  • Minimum of six (6) years of demonstrated on the job experience in JAVA/J2EE development doing ETL work.

  • Minimum of two (2) years of demonstrated on the job experience with JavaScript/UI framework(s).

  • Demonstrated on the job experience with Pentaho.

  • Demonstrated on the job experience with Spring and Hibernate or REST services.

  • Experience with a data transformation tool such a Pentaho.

  • Demonstrated experience working with and transforming XML, JSON, or CSV.

  • Demonstrated experiencing working with and or authoring XML Schemas.

  • Familiarity with AWS data storage environment such as S3.

  • Author documentations to include artifacts such as ETL flow diagram, source-to-target mappings, and others.

Desired Skills

  • Experience with code delivery mechanisms and code repositories (e.g. Subversion and/or Git).

  • Experience with continuous delivery solutions, such as Hudson, Jenkins, or Puppet

  • Experience in developing and maintaining applications in the Sponsor’s environment and associated security processes.

  • Experience developing in an Agile environment, including Scrum and user stories.

  • Demonstrated experience developing and operating enterprise scale, web-based applications in the IC/DoD environments.

  • Demonstrated experience working in a cross security domains environment.

  • Demonstrated experience participating in Agile development teams.

  • Familiarity with NoSQL environment and technologies.

For more than 50 years, General Dynamics Information Technology has served as a trusted provider of information technology, systems engineering, training and professional services to customers across federal, state, and local governments, and in the commercial sector. Over 40,000 GDIT professionals deliver enterprise solutions, manage mission-critical IT programs and provide mission support services worldwide. 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.




Job ID2018-41344

Number of Positions1

Job FunctionInformation Technology

Security Clearance LevelTop Secret/SCI with Polygraph

Full/Part TimeFull Time