Data ETL Support Engineer

Overview

On Site
$40 - $50
Contract - W2
Contract - 12 Month(s)

Skills

Data engineering
ETL
PL/SQL
SQL
API
Looker

Job Details

Title: Data ETL Support Engineer (Local Only)

Location: Clayton, MO (Hybrid)

Duration: 12+ Months (Possibly extension)

About the Role:
ETL support Engineer will be the main daily responsibility of this role.


Top skill needed is very strong SQL and PL/SQL skills
Must be a data detective being able to dig through the data pipeline to find out the source of the issue. Most of the tickets come in saying that the API and/or Reporting(Looker) data doesn t match the source system(s) or is not accurate, so being able to trace that down and fix the root cause (this is 90% of the role)
Ideal candidates should have strong experience in building/modifying tables, schemas as they migrate their Oracle Data Integrator workflows into Matillion. Second priority is Matillion or Snowflake, the ETL tool doesn t necessarily matter but they should be strong with one of the ETL tools and change data capture. (10% of the role)
When they are not performing production support duties, they may be responsible for migrating ODI to Matillion/Snowflake and enhancing performance of existing workflows and data processes. Finally, they may need some Python scripting for automation of data movements so that is a plus. Looker reporting is also a plus. (10% of the role)

Good communication is important for these roles.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Intellisoft Technologies