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

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

Date Posted: 2/17/2019

Job Snapshot

  • Employee Type:
  • Location:
    College Park
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
  • Job ID:

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.

Job Requirements

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

  1. Minimum of six (6) years of demonstrated on the job experience in JAVA/J2EE development doing ETL work.
  2. Minimum of two (2) years of demonstrated on the job experience with JavaScript/UI framework(s).
  3. Demonstrated on the job experience with Pentaho.
  4. Demonstrated on the job experience with Spring and Hibernate or REST services.
  5. Experience with a data transformation tool such a Pentaho.
  6. Demonstrated experience working with and transforming XML, JSON, or CSV.
  7. Demonstrated experiencing working with and or authoring XML Schemas.
  8. Familiarity with AWS data storage environment such as S3.
  9. Author documentations to include artifacts such as ETL flow diagram, source-to-target mappings, and others.

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.