sql-etl developer

Job Summary

Unified Strategic is seeking a SQL/ETL Developer to fill a six-month contract with federal government client, potential long-term extension based on performance. The SQL / ETL Developer applies knowledge of database concepts and techniques to develop data models and write ETL components that manipulate and transformation data for business data acquisition, aggregation, and dissemination. Uses scientific and engineering logic to independently identify conceptual or theoretical solutions to problems of data design and operation. 

Responsibilities

  • Design relational data models
  • Write ETL code querying relational databases, tabular excel data, and CSV data
  • Write ETL routines to confirm full data content is transferred successfully
  • Write procedures to perform automated operations on data and provide business rule views of data
  • Perform data discovery to profile data for ETL requirements and find anomalous data
  • Optimize queries for large volumes of data
  • Write ETL code to migrate data to specific shards in a database farm

 

Requirements

  • Bachelor’s degree in Computer Science, Information Technology, or related field or equivalent combination of education/experience.
  • 4+ years of experience working with relational databases: writing complex SQL, designing data models, and/or developing ETL. Experience with SQL Server Version 2016 or later. Experience with SQL Server Integration Services (SSIS).

Must be able to perform the following with minimal guidance: 

  • Write performant complex SQL statements against terabyte+ size datasets
  • Develop relational data models to accommodate in-process data for automated ETL processes
  • Optimize ETL and SQL statements
  • Analyze and troubleshooting database performance issues
  • Develop ETL routines that manipulating and transfer large volumes of data and perform quality checks to confirm all data is transferred
  • Using version control systems, GIT preferred
  • Works well in a distributed team environment

Preferred Experience

  • Querying REST API’s and consuming JSON data
  • Oracle
  • AWS S3 and Glacier

 

To apply for this position, send an email with the subject SQL-ETL Developer (3628) to [email protected]. Attach your resume as a PDF file.