Back to Careers

ETL Developer

Tuesday, July 9, 2019
Organization Unit: 
DOS-ER (DAPR)
Job Type: 
Full-Time
Start Date: 
Immediately

Position Description and Candidate Requirements:

Must have active Secret Clearance !

General Job Description:
Extract, Transform, and Load (ETL) developer with ETL tool and Oracle PL/SQL knowledge to support a large enterprise reporting team. Large volume, complex transactional data stores must be transformed to support high-performance analytics applications via dimensional models. Analysis and design of source to target requirements required.

 

Job Responsibilities:

  • Develop and document data requirements from business requirements
  • Perform source system data analysis to understand data relationships
  • Investigate data quality and develop data cleansing routines
  • Design and document logical and physical data models in data modeling tool
  • Generate Data Definition Language (DDL) scripts from modeling tool
  • Design and document source to target data mappings
  • Design, develop, and test ETL routines
  • Design, develop, and test SAP HANA calculation views
  • Participate in data team peer reviews
  • Provide content for data related software development lifecycle documentation
  • Provide ad hoc query support for ad hoc query requests
  • Participate in program, project, and functional team meetings
  • Provide timely and accurate input for status reporting

 

Candidate Requirements:

  • 3+ years experience working with complex data warehouse projects
  • 1+ years experience designing ETL processes to populate the data warehouse preferably with a COTS ETL tool
  • Ability to analyze source data for potential data quality issues and address these issues in the ETL procedures
  • Experience with Oracle databases
  • Proficient in dimensional data modeling
  • Ability to effectively communicate information, both verbally and written to end users, team members and management
  • Sufficient knowledge to identify and help avoid pitfalls associated with data warehousing and ETL processes specifically
  • Capable of documenting ETL subsystem architecture and prepare a design document that is easily understandable to less technical individuals
  • High-level knowledge of various industry leading data warehouse components (databases, ETL tools, BI/reporting tools)
  • Must be self-motivated and take initiative in performing tasks
  • Must be able to work on multiple projects concurrently

 

Candidate Desired Skills/Experience:

  • Experience with SAP BusinessObjects Data Services ETL tool
  • Experience with SAP HANA
  • Experience with SAP BusinessObjects Business Intelligence tool suite
  • Experience with Agile development
  • Experience with Oracle Golden Gate
  • Experience with SAP Smart Data Integration
  • Experience participating in end user and technical requirement sessions
  • Exposure to a DataOps environment
LOA: 
Permanent