Spatial ETL Developer

Science Applications International Corporation

United States

3 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

9 years minimum

Compensation

$120,001.0 - $160,000.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Geographic Information Systems ArcGIS (Software) BASIC (Programming Language) Databases Extract Transform Load (ETL) Data Warehousing Relational Databases Database Development Spatial Databases IT Management Python (Programming Language) PostgreSQL

+7 more

Oracle (Applications) Software Engineering Spatial Data Infrastructures PL-SQL SQL Databases Esri GIS (Software) Data Management

Job description

SAIC is seeking a skilled Geographical Information Systems (GIS) specialist with expertise in Extract, Transform, and Load (ETL) processes. This role involves supporting the design, development, and maintenance of geospatial data within a dynamic Enterprise Data Warehouse environment.

Responsibilities and Duties:

Development of spatial data structures, data loading business rules, and Feature Manipulation Engine (FME) ETL models to load geospatial data from source systems
Database support that includes knowledge of relational database including Oracle or Postgres database, ESRI SDE, and ESRI File geodatabase formats
Troubleshooting data issues
Documenting ETL processes and data requirements and ensuring metadata compliance
Working with data stewards from government agencies and commercial entities to facilitate data needs and requirements for the U.S. Forest Service
Provide support for monitoring daily ETL processes and resolving ETL issues as they arise

Requirements

9 years or more of relevant experience in an Enterprise IT Environment
Bachelor’s degree in Computer Science, Information Systems, or other related field, * Hands on experience with Safe Feature Manipulation Engine (FME), Informatica, or similar Extract, Transform, and Load (ETL) tools
Oracle or Postgres database development skills including SQL and PL/SQL
Knowledge of ESRI Enterprise Geodatabase (SDE) for Oracle or similar relational database system.
Spatial data formats including ESRI ST_Geometry, File Geodatabase, and shapefile
Knowledge of ESRI ArcGIS Tools including ArcPro
Software development lifecycle and documentation
Excellent communication skills, time-management, decision-making, and basic task organizational skills.

Desired Skills and Qualifications

Oracle
PostgreSQL
Python
Must be able to obtain USDA public trust clearance

Benefits & conditions

4.04.0 out of 5 stars Missouri Remote $120,001 - $160,000 a year - Full-time, Target salary range: $120,001 - $160,000. The estimate displayed represents the typical salary range for this position based on experience and other factors.