ETL Developer - DataStage

ACCUTREND DATA CORPORATION
Greenwood Village, United States of America
24 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior
Compensation
$ 120K

Job location

Greenwood Village, United States of America

Tech stack

Data analysis
Azure
C Sharp (Programming Language)
ETL
IBM InfoSphere DataStage
Microsoft SQL Server
SQL Stored Procedures
SQL Server Integration Services
Freeform SQL
Azure
Snowflake
Information Technology

Job description

  • Work with SQL Server 2012+
  • Work with Snowflake
  • Create Stored Procedures, Views, Functions, Custom Data Types in Microsoft SQL Server
  • Write queries to analyze data and produce results such as data differences between tables and creating reports for overlapping data
  • Utilize Outer Joins, Inner Joins, Not Exists, etc., commands in daily work
  • Create & Modify SSIS packages and models for Extract, Transform and Load
  • Create & Modify Azure Data Factory pipelines for Extract, Transform and Load
  • Document and provide guidance on database solutions to fulfill business or technology requirements

Requirements

  • Bachelor of Computer Science or relative work experience
  • Knowledge of Microsoft Azure
  • Understanding of C#
  • Understanding of Azure Data Factory
  • Understanding of Snowflake
  • Ability to write and understand complex SQL queries
  • Experience in SSIS
  • Ability to work on multiple tasks at once

Benefits & conditions

  • 401(k)
  • Dental insurance
  • Health insurance
  • Vision insurance

About the company

Accutrend Data Corporation is a big data provider in a small office environment. We have a great team of data experts but are looking to take on some new employees to help with day-to-day operations and our ever-increasing data shipments. This is a great entry level position for new graduates or for someone looking to expand their current skill set.

Apply for this position