Overview
Remote
$50+
Accepts corp to corp applications
Contract - Independent
Contract - W2
Skills
ELT
Oracle
PL/SQL
PostgreSQL
Python
Snow Flake Schema
airflow dag
AWS
Job Details
Required
- Experience working with Oracle RDS
- Experience working with one or more AWS Cloud services such as S3 storage, Managed Airflow (MWAA), Data Migration Service (DMS) in support of building data pipelines
- Experience working with a variety of backend data sources (e.g. SQL Server, Oracle, Postgres, DynamoDB, Snowflake)
- Advanced SQL coding skills and ability to translate Oracle PL SQL and Stored Procedure code to alternative SQL platforms such as Snowflake
- Familiarity with data warehouse and data mart concepts such as normalization, facts, dimensions, slowly changing dimensions
- Familiarity with Change Data Capture (CDC) concepts and implementations. Knowledge of Kafka or similar replication tools is a plus
- Understanding of common file formats such as JSON, XML, CSV
- Basic experience using scripting tools to automate tasks (e.g.: Python, Windows PowerShell, bash)
- Ability to write unit test scripts and be able to validate migrated ELT/ETL code
Preferred
- Experience configuring, managing, and troubleshooting Airflow tool. Knowledge of Airflow DAGs and concepts for managing dependent graphs and complex steps
- Knowledge of Snowflake data warehouse features such as Snowpipe streaming, cloning, time travel, role-based-access control
- Prior experience working at other large organizations, preferably state or federal government
- Business domain knowledge in the Education and Student data management area.
- Experience working with software development tools such as GitHub, Jira
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.